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

This video tutorial guides viewers through the process of creating a dashboard in Excel. It covers moving charts to the dashboard, linking text boxes to cells for headline statistics, calculating and linking gross sales data by country, and finalizing the dashboard with proper alignment and formatting. The tutorial emphasizes the use of Excel formulas and formatting tools to create a functional and visually appealing dashboard.

What is the first step mentioned for moving charts to the dashboard?

How can you organize the charts on the dashboard according to the text?

What is the process to remove the outline from the charts?

Describe how to link a text box to a cell in the calculations worksheet.

Explain how to ensure that all text boxes are aligned on the dashboard.

What formula is used to calculate gross sales by country?

What happens when you select a different year from the drop-down menu?