Interactive Sales Dashboard Tutorial | Pivot Table | Pivot Charts | Slicers

In this video we will talk about how to create an interactive sales dashboard in Excel. We will be using feature like Pivot Table, Pivot Chart, Sliers and Tables in Excel.
We are going to learn how to setup your source data, then create a Pivot Table and Pivot Chart. I also show you how to reformat the chart to upgrade the look from the default settings.
It is easier than what you think, the process is just few drags and drops and clicks and you are ready with the dashboard.

There is no need of complex formulas, VBA or Macros to create this dashboard.

00:00 Intro
00:45 Format Data as Table
01:10 What should the dashboard show?
01:51 Create Pivot Tables for the Dashboard
05:25 Create Charts based on Pivot Tables
06:25 Arrange all charts on Dashboard Sheet
07:45 Clean and Format all charts
12:20 Add Slicers for Interactivity
14:20 Connect Slicer with Other Charts & Pivots
19:25 How to update Data next time
20:07 Dashboard Security & Protection

You can download the file used in the video from the below link:
https://bit.ly/3gyGwPP

If you are new to the pivot table i would suggest you to watch below playlist it will help you to understand what we are doing and why.

Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports
   • Pivot Tables  

Also, check these videos if you want to learn more

1 Min Excel: If you enjoy short videos check this section
   • Shorts : Random  

Excel: Check this playlist for Excel-related things
   • Excel  

Keyboard Shortcuts: Check this section to save some time in everyday excel work
   • Excel Keyboard Shortcuts  


Power Query: Check the Power Query playlist for Data Preparation & its Automation
   • Power Query  

Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations
   • Power BI  



Please subscribe to our channel and Follow us on other social media platforms for regular updates :

Tiktok https://vm.tiktok.com/ZSH28XEt/
Facebook   / datacense  
Twitter   / datacense  
LinkedIn   / datacense  
Instagram   / datacense32