Dashboards, also known as “infographics,” are ideal for delivering information in a graphical, dynamic, user-friendly form, and Excel is an 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.
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.
Audience: This course is for Excel users that want to display data from excel in multiple dynamic ways.
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.
Requires 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.
