Course Length:  1.0 day

Course Description

Learn to use tools that are available in Excel to create an interactive and dynamic Excel Dashboard. Build an environment that will allow users to go to a single page to gain insight and analysis through graphs and tables. Use Excel tools to display key performance indicators, data trends and comparisons on one screen.

Examine methods that make it easy for reports to be updated quickly (often at the click of just one button!). Learn to load, organize, and display data in a fully interactive, dynamic, and easy to read format.

Target Student:

The ideal student is comfortable navigating in Excel and is familiar with using mathematical and lookup formulas and functions. Students should have created standard charts and graphs in Excel, and should be somewhat familiar with Pivot Tables and Pivot Charts.

The materials learned in this course will apply to anyone who works with large volumes of data and needs to display the data in a meaningful and easy to understand report that can be updated and drilled down to gain specific insight.

Prerequisites:

This is an Advanced level class. Students should have taken the listed classes or have equivalent knowledge:

Course Content

Lesson 1:  Introduction to dashboards

Lesson 2:  Getting your Data Ready

Lesson 3:   Building a Dashboard

Lesson 4:  Functions

 

 

Lesson 5:  Using Pivot Tables, Pivot Charts and Slicers for Data Analysis

Lesson 6:  Choosing the Right Chart for Your Data

Lesson 7:  Additional Dashboard Tools

Lesson 8:  Using Macros to automate your dashboard

You may also be interested in:

Excel Programming with VBA

MCSA BI Reporting