Microsoft Excel 2021365 - Beginner to Advanced - Assembling a Dashboard - Part 1

The video tutorial covers the basics of designing an interactive dashboard using Excel. It starts with setting up the dashboard layout using shapes and text boxes, followed by creating a combo box for year selection. The tutorial then explains how to use Excel functions like UNIQUE and INDEX to manage data. It also covers data preparation for charts using SUMIFS and advanced chart data setup using COUNTIFS and SUMIFS.

What is the first step recommended before building an interactive dashboard?

How can you ensure a clean page in your dashboard design?

What is the purpose of the combo box drop down in the dashboard?

What is the significance of the Developer ribbon in Excel for dashboard design?

What Excel function is used to create a unique list of years from the data source?

Explain how to sort the unique list of years in ascending order.

Describe the process to link the combo box to the years in the calculations worksheet.

What formula is used to sum the units sold by country based on the selected year?

What are the two criteria used in the SUMIFS formula for calculating units sold?

How do you ensure that the dashboard updates correctly when a different year is selected?