- Headline Stats - SUMIFS, MAX, LARGE and INDEX and MATCH
6
- Sales Tables Calculations - IF, SUMIFS and COUNTIFS
7
- Map Chart - Dynamic Filled Map
8
- Discount Charts - Setup
9
- Stacked Column Chart - Dynamic with Totals
10
- Donut Chart - Dynamic with Icon
11
- Sparklines
12
- Conditional Formatting
13
- Dynamic Titles
14
- Assemble Dashboard - Part 1
15
- Assemble Dashboard - Part 2
Description:
Dive into a comprehensive video tutorial on creating an interactive sales dashboard in Excel from scratch. Learn step-by-step techniques for data setup, wireframe design, and implementing advanced Excel functions like SUMIFS, MAX, LARGE, INDEX, and MATCH. Master the creation of dynamic filled map charts, stacked column charts with totals, and donut charts with icons. Explore the use of sparklines, conditional formatting, and dynamic titles to enhance your dashboard's functionality. Follow along as the instructor guides you through assembling all components into a polished, professional dashboard over the course of nearly two hours. Download provided files to practice and reinforce your learning throughout this in-depth Excel dashboard crash course.
How to Create a Stunning Interactive Dashboard in Excel - Sales Excel Dashboard Crash Course