Excel Dashboards Part 2 - Charts and PivotTables

OLEX8- *This course qualifies for 3.5 CPE Credits*

Course Description:
Learn Excel from the comfort of your office or home.

This two-hour LIVE Instructor-led course will give you the tools to create dashboards to display key business performance indicators that are relevant to a business process. A dashboard is a visual interface that shows data at a glance, and often includes conclusions that alleviate the need for the viewer to analyze the data being presented.

In Dashboards Part 2 we will look at building charts, dual access charts, creating chart Templates, creating PivotTables and PivotCharts and using Slicers and Sparklines to easily modify the information on a Dashboard. Topics include:

  • Visualize data with basic charts
  • Use advanced charting techniques and create Sparklines
  • Analyze date with PivotTables, Slicers and PivotCharts


Excel 2016 Introduction to Charts, Filters & Conditions, Excel 2016 Introduction to Tables & PivotTables, Excel 2016 Advanced Data Analysis using PivotTables or prior knowledge of the topics covered in those classes.

Contact Us