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