Drive Your Dashboard with Excel
SKU: CPE-07-062
Credit Hours: 11
Level: Basic
Field of Study: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: Online PDF
Instructor: Patricia McCarthy, MBA
By the end of this course, you should 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