Drive Your Dashboard with Excel
SKU: 02-062-01-CPE
Credit Hours: 11
Level: Overview
CPE Category: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: PDF
Instructor: Patricia McCarthy, MBA
Course Description:
This is an Excel course so the focus is on using Excel to create an effective dashboard.
At the end of this course, students will be able to:
- Identify and define a dashboard and its different components
- Recognize the design component of the dashboard
- Recognize, create and edit appropriate charts for a dashboard
- Recognize, create and edit in-cell charts and tables
- Recognize and create Sparklines
- Apply different linking methods in a dashboard
- Apply different filtering techniques and data validation to data
- Recognize and understand how to use absolute cell references and range names
- Recognize the pros and cons of pivot charts and how to use them in a dashboard
- Recognize the different types of conditional formatting and how to apply them
- Recognize and apply different functions within a dashboard
- Recognize how to protect and distribute dashboards