Upon successful completion of this course, participants will be able to:

• Define a dashboard, noting its characteristics, components, and how it differs from a report;
• Recognize the design component of the dashboard;
• Identify different types of charts and their appropriate usage, and note the process for creating and editing appropriate charts for a dashboard;
• Recognize the process of creating and editing in-cell charts and tables, noting efficient methods to format for consistency;
• Define a Sparkline and note its historical significance;
• Note the application of different linking methods in a dashboard;
• Note the different filtering techniques and data validation to data;
• Recognize absolute cell references and range names, noting their application;
• 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 the different functions within a dashboard, noting their syntax and application; and
• Recognize the process of protecting and distributing dashboards.