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 new insight or understanding did you gain from this video?