top of page
Search
Writer's pictureVijay Perepa

How to create Complete Excel Dash Board in 15 minutes

Why you use Excel?


The answer from many Excel users is - "We create Reports / Dashboards"

But the creation of reports by using Formulae or Pivot table will vary from user to user.


What is the minimum / maximum time will be spent by you to create any Report containing

multiple Years?


The answer I heard most of the time varying from 1 Day to Many Days. Of course very few said they took few hours to complete. But is there any way to create in 15 minutes. Yes "Fifteen Minutes". In this Video I have explained how to achieve below items in just 15 minutes:


How to Create almost 5 Pivot Tables and then 5 Charts from the Data of 5 Years.

- Once the Pivot Tables and Report is Completed, you need to just add the incremental Data and Refresh the Pivot Table and THAT's IT.

- The Report is Live and Dynamic.


Watch this Video to know more about Pivot Tables, Dynamic Tables, Slicers, Slicer Connections. Keep Learning ! 😎


618 views2 comments

2 Comments


Vijay Perepa
Vijay Perepa
Aug 26, 2020

Thanks

Like

MED KARI
MED KARI
Aug 26, 2020

thank you so much professor

Like
bottom of page