Interactive Dashboards in Excel | Excel Dashboards | Pivot Charts | Automated Reports in Excel

Hi everyone,

This video focuses on Interactive Dashboard creation in MS-Excel.

We may have a lot of data but data can not be presented anywhere. For presentation, it has to be in a summary form, precise, accurate, easily accessible and modifiable instantly

In this video, I have tried to give a detailed explanation how you can create dashboards for large data sets

Creation of dashboards served a lot of purposes, one time effort and enjoy later, dashboards can be copied directly copied/pasted to PPT presentations and a lot of

Here I have use Pivot tables and Pivot Charts and Slicers for creation of dashboards

In my previous video, I have given a detailed tutorial on Pivot Tables. The link is below:

This video is an extension of the above video. If you have any doubt on creation of pivot tables, please watch my previous video

I hope that this video is of some help for you

You can drop your doubts in the comments section and I will try to resolve them all. Also you can drop your Email-ID and I will email you the worksheet for practicing

Thanks
Excel Insider

Download the practice file here:

#Dashboards
#AutomatedReports
#DataAnalysis

Interactive Dashboards in Excel
Excel Dashboards
Pivot Charts
Automated Reports in Excel

[goan]

Good tutorial. Crisp and simple to understand. 👍

[amitapattanaik]

Very good tutorial, Excel 10 or what, pls do chart every thing

[KenyaCosmetics]

kindly @Excel Insider do a videdo on procurement KPI Dashboarding