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.