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?

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

What formula is used to calculate gross sales by country?

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF