Dashboards, also known as “infographics,” are ideal for delivering information in a graphical, dynamic, user-friendly form; and Excel is a familiar, effective application that will enable you to do just that! This class will help you to extract information from your raw data and present it in a visual format that enables decision makers to view key trends and conclusions at a glance. Utilizing various combinations of Excel charts, Pivot Tables, Pivot charts/slicers, conditional formatting, Data Validation, Sparklines, hyperlinks, and advanced formulas, you will be able to synthesize your raw data into meaningful, dynamic visual presentations.

Performance Objectives: Upon successful completion of this course, you will be able to create dashboards in Excel by

• Creating range names and advanced formulas.
• Automating workbook functionality.
• Applying conditional logic.
• Visualizing data by creating basic charts.
• Creating trend line and Sparkline charts.
• Using PivotTables, Pivot Charts, and slicers.
• Building and developing dynamic data models using the above tools in a dashboard and/or report format

Intended Audience: This course is for Excel users that want to display data from excel in multiple dynamic ways

Recommended Prerequisite: This course is a combination of selected topics from the Microsoft Excel 2013/16 Level 2 and 3 courses and is specifically designed to provide students with the skills and knowledge to create effective dashboards.

Completion of the Microsoft Excel 2013/16 Level 1 course or have the equivalent knowledge and experience. In particular, students should have experience in creating workbooks with formulas and functions.

Sales Tax Notice: Effective October 1, 2025 
In accordance with Washington State law (ESSB 5814), sales tax will be applied to all training services. In addition to the course cost, sales tax will be calculated based on your agency's location and added to your final invoice after the class is completed.