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

EXCEL DATA VISUALISATION AND DASHBOARDSCOURSE 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.
• Individual attention: Max group size is 4.

Online: Instructor-led, interactive 

Software: 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