Visualizing Your Data with Excel Dashboard
1. Dashboard Designing Steps,Preparing Your Table and How
to Create a Basic Dashboard
This course is the first part of Visualizing Your Data with Excel 2016 Dashboard training series. In this part, participants will learn the necessary steps needed in creating an Excel Dashboard and preparing the proper data as well as how to create a basic dashboard by using Pivot Table and its capabilities.
2. Creating a Chart with a Limit Indicator
One visualization that is important,is to see which data that are above and below a specific limit. How to create this type of chart will be taught in this course.
3. Creating a Dynamic Chart
Nice and professional looking chart is essential in creating an Excel Dashboard. So,in this course,
participants will learn how to create such a chart when the source data range are different.
4. Using Form Control Tools
Participants in this course will learn how to control what will be displayed in their charts by using easy to use features of Excel form control tools.
5. Indicating Highest and Lowest Values
A chart that makes the audience focus on certain data is sometimes the goal when you present your report. This type of chart will be taught in this last part of the Visualizing Your Data with Excel 2016 Dashboard training series.