Visual Data with Excel Dashboards

£385 per delegate. This may be less for special offers on specific course dates and in-company training courses

Duration: 1 day

Trainer: WC315P

Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...

Course Summary:

Dashboards will summarize and present the key indications of large data in an attractive visual display, hightlighting the most important trends so the most important aspects of data could could be seen in a snap second by glancing at attractive, colourful charts.

PowerPivot helps analyze the data and brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. Power Pivot help analyze and understand the growing quantities of data that are created on a daily basis.

Who should attend?

-Business users who analyse data with Excel or create management reports
-Excel users who want to analyze large data sets and also create relationships between tables
-Excel users who know how to Pivot Tables and Pivot Charts
-Excel users who wish to create interactive dashboards

Course Outline:

-Activating Power Pivot in Excel
-Browse, Filter and Sort PowerPivot Data
-PowerPivot Menu Options
-The AutoSum Function in Power Pivot

-Creating Pivot Tables with PowerPivot Data
-Creating PivotTables
-Changing the Method of Calculation
-Pivot Table Calculations
-Filtering with Slicers
-PivotTable Filters and Slicers
-Filtering PivotTables and PivotCharts
-Creating Hierarchies

Excel techniques that are essential for Dashboards: 

-Lookup formulae (Vlookup, Hlookup, Match, Index)
-Conditional formulae (If, Countifs, And, Or, etc.)
-Aggregate formulae
-Advanced filters to organise columns and filter rows

-Charting: Pie, Line, Area, Column, Scatter, Bar charts,
-Charting: Axes, 2D, 3D chart elements, -Sizing of charts
-Charting: Formatting of charts
-Create dashboard heat maps and other shapes
-Conditional Formatting
-Highlight top and bottom products/ people etc

Excel Dashboard Tips and Tricks including:

-Adding inter-activity
-Forms and controls (for drop down lists to choose what you are comparing)
-Linking cells to a text box
-Linking cells to chart labels
-Linking dynamically to changing ranges and values

-Create Relationships with PowerPivot Data
-Create Relationships to Master Data
-Create PivotTables with Table Relationships
-Refreshing Dashboards inline with changing data

What is included:

-Laptops and data for the course. Let us know beforehand if you would like to bring your own
Excel Course Certificate on completion (assessment based)
-Excel Course notes
-Practical Class exercises, Excel Course Homework
-Tea, coffees, but no lunch
-To assist after the course, 1 free session for questions online via Skype or Teamviewer.
Max group size is 4.
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
  • Corps Construct Logo
  • Safety & Health Logo
  • Hawks Logo
  • Know How Logo
  • Induct Ltd Logo
  • Ace Safety Logo
  • 1UPACCESS Logo
  • BAM Construction Training Logo
  • Citrus Training Logo
  • 3B Training Logo
  • Astutis Logo
  • Construction Industry Training Providers Logo
  • Health Life and Safety Logo
  • MI Construction Training Logo
  • Innov8 Training Logo
  • BSI Training Logo
  • OM Safety Training Logo
  • TotalComms Training Logo
  • SDA Safety Logo
  • Construction Skills People Logo
  • Phoenix Health and Safety Logo
  • Harris Safety Training Logo
  • First Response Training Logo
  • Alliance Learning Logo
  • ALS Safety Logo
  • KeyOstas Logo
  • Libben Health and Safety Logo
  • Global Management Academy Logo
  • Illumine Logo
  • CCAS Health and Safety Logo
  • ROSPA Logo
  • PJH Safety Training Logo
  • OMS Logo
  • Tala Training Logo
  • PRS Health and Safety Training
  • SSG Training and Consultancy Logo
  • RB Services Logo
  • Safety Training Services Logo
  • Clarkson Evans Training Logo
  • Lighthouse Training Logo
  • The Building Safety Group Logo
  • ProSafety Logo
  • Total Training Solutions Logo
  • Kentec Training Logo
  • Total Electrical Training logo
  • NTSS logo
  • Frinton Training logo
  • Envesca logo
  • The Safety Maintenance Company logo
  • APT Health and Safety logo
  • Sandwell Training Association logo
  • PC Workshops logo
  • Zero Harm Training logo
  • R2 Training logo
  • The Bradley Group logo
  • Risk Health and Safety logo
  • Wise Global Training logo
  • Total Training Company Logo
  • Sibbald Training logo
  • Total Construction Training logo
  • UTN Training logo
  • Collective Safety Solutions logo
Telephone Hotline (footer image)

Telephone Hotline

01933 233884

(Monday to Friday - 8:00am to 5:30pm).

© 2021 Book My Course Limited. All rights reserved

Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy