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.

​