Excel Dashboards and Data Visualization 1-Day Course, London/ Virtual Class...

Excel Dashboards and Data Visualization 1-Day Course, London/ Virtual Class...

Actions and Detail Panel

£290

Description

EXCEL DATA VISUALISATION AND DASHBOARDS

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 imporatnf 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. All versions of Microsoft Excel is covered. We use the latest in the class, but could deliver using your version on request.

Who should attend?

  • Business users who analyse data with MS Excel or create management reports
  • Excel users who want to analyze large data sets and also create relationships between tables
  • Microsoft Excel users who wish to create interactive dashboards
WHAT IS INCLUDED:
  • Excel Course Certificate on completion
  • Excel Course notes, exercises, examples.
  • To assist after the course, 1 free online question / revision session.
  • Max group size is 4.

Online: Instructor-led, interactive

Links: Connection link is emailed upon booking. Best if Excel is on your desktop/laptop

Our Style: Practical, Hands-on

COURSE OUTLINE

Introduction
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
Offset
Lookup formulae (Vlookup, Hlookup, Match, Index)
Conditional formulae (If, Countifs, And, Or, etc.)
Aggregate formulae
Advanced filters to organise columns and filter rows

Visuals
Sparklines
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


Share with friends

Save This Event

Event Saved