Long ago I was asked by one of my training participants that if his dump of events on specific dates can be plotted on a Calendar? Since then I have had all the setup in my mind but never executed it.

Well, I have executed it now. Presenting to you a Calendar Dashboard in Excel

 

A Quick Overview of the Dashboard

Visually the Dashboard is divided into 3 big parts

  1. A Single Month’s Calendar – Which shows what activity has been planned and day’s total
  2. Some Key Metrics – Which provide additional insights into the data
  3. Summary Table – Which displays more detail about activities

 

All of this work is done using PowerPivot and Excel’s native capabilities. In this short video I’ll explain 3 things

  1. How does the back-end data look like
  2. How does the Dashboard function
  3. How did I create it ?

 

Enjoy!

 

Excel Tactics discussed during the Video

  1. Download a sample Calendar (made by Microsoft) – to understand it workings
  2. How to do a Vlookup
  3. What is PowerPivot and DAX
  4. Dynamic Textboxes
  5. Pivot Tables Formatting Tricks
  6. Slicer Formatting Tricks
  7. Dashboard Design Guide – PDF
  8. Conditional Formatting in Pivot Tables

 

I won’t tease you anymore.. finally DOWNLOAD THE CALENDAR DASHBOARD

 

Other Visualizations using Excel and Power Pivot

  1. Indian Tech Startup Performance Dashboard
  2. Facebook Dashboard in Excel
  3. Airline Schedule Dashboard
  4. Learning and Development Dashboard for HR

 

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI