Microsoft Excel 2021365 - Beginner to Advanced - What Is a Dashboard?

This video tutorial introduces interactive dashboards, explaining their complexity and components. It covers the process of building a dashboard from raw data, including setting up calculations and using combo boxes. The tutorial also explores advanced techniques and design recommendations, emphasizing non-pivot charts and the use of dropdowns for data control.

What is the main purpose of an interactive dashboard?

Describe the components typically found in a sales dashboard.

How does changing the year in a dashboard affect the displayed data?

What skills are required to create an interactive dashboard?

What techniques can be used to design interactive dashboards?

What resources can you explore for inspiration on Excel dashboard designs?

Explain the difference between using regular charts and pivot tables in dashboards.