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
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.