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 in moving charts to the dashboard?

• Copy the chart using Control C and paste it using Control V.

• Use the 'Insert' menu to add charts.

• Export the chart as an image and import it.

• Create a new chart directly on the dashboard.

How can you remove the borders from the charts on the dashboard?

• Borders cannot be removed from charts.

• Use the 'Design' tab to hide borders.

• Right-click the chart and select 'Remove Borders'.

• Select the chart and choose 'No Outline' from the format menu.

What is the purpose of linking text boxes to cells in the calculations worksheet?

• To display dynamic data that updates automatically.

• To add decorative elements to the dashboard.

• To create hyperlinks to other worksheets.

• To format text boxes with different colors.

Which formula is used to calculate gross sales by country?

• SUMIFS

• VLOOKUP

• AVERAGE

• COUNTIF

What should you do if the data needed for calculations is missing?

• Add the necessary data to the calculations area.

• Contact the data provider.

• Skip the calculation step.

• Use a different worksheet.

How can you ensure that all text boxes are aligned on the dashboard?

• Text boxes cannot be aligned automatically.

• Use the 'Align' option in the Home tab.

• Manually adjust each text box.

• Use the alignment tools on the Shape Format ribbon.

What is the final step to ensure the dashboard is working correctly?

• Share the dashboard with a colleague for feedback.

• Print the dashboard to check its layout.

• Save the dashboard as a PDF.

• Select a different year from the drop-down to see if all elements update.