Bonus – Sales Dashboard with Excel (Must Watch)

In this bonus dashboard tutorial, learn how to create the below interactive, beautiful & dynamic dashboard using Microsoft Excel 365.

PS: This is originally published on my YouTube channel, but you can watch it here and download for free, as a member of Excel School + Dashboards program.

Lesson topics & concept coverage

This lesson is broken into two videos, with a total of 2 hours 30 minutes view time. You will learn below concepts:

  • Dashboard design & theme development
  • Using Data model, Power Pivot & DAX for calculations
  • Using Excel 365 formulas such as XLOOKUP, FILTER, SORT, SORTBY to get dynamic data
  • How to show maps with dynamic picture links
  • Setting up tables with Conditional formatting
  • Showing trends with sparklines
  • Custom chart development with Bubble charts, donut charts
  • Slicer connections & manipulations for interactive effects

Watch the lesson [2 Videos, 2.5 hours]

Author: Chandoo

My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions. I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here. I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.

4 thoughts on “Bonus – Sales Dashboard with Excel (Must Watch)”

    1. @Nadeem,
      This class is for excel Dashboard subscribers only.
      you are a power Power BI Play Date subscriber and hence cannot access the same

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.