How to Create a Stunning Interactive Dashboard in Excel - Sales Excel Dashboard Crash Course

How to Create a Stunning Interactive Dashboard in Excel - Sales Excel Dashboard Crash Course

Simon Sez IT via YouTube Direct link

- Dashboard Overview

1 of 15

1 of 15

- Dashboard Overview

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

How to Create a Stunning Interactive Dashboard in Excel - Sales Excel Dashboard Crash Course

Automatically move to the next video in the Classroom when playback concludes

  1. 1 - Dashboard Overview
  2. 2 - Data Setup
  3. 3 - Wireframce Design
  4. 4 - Combo Box Setup
  5. 5 - Headline Stats - SUMIFS, MAX, LARGE and INDEX and MATCH
  6. 6 - Sales Tables Calculations - IF, SUMIFS and COUNTIFS
  7. 7 - Map Chart - Dynamic Filled Map
  8. 8 - Discount Charts - Setup
  9. 9 - Stacked Column Chart - Dynamic with Totals
  10. 10 - Donut Chart - Dynamic with Icon
  11. 11 - Sparklines
  12. 12 - Conditional Formatting
  13. 13 - Dynamic Titles
  14. 14 - Assemble Dashboard - Part 1
  15. 15 - Assemble Dashboard - Part 2

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.