Compare 2 Lists
A common task for many Excel Users is to compare 2 or more lists and find out the missing values[…]
Read moreCategory: Excel Dashboards
Smileys in Dashboards
A Smile is an Inexpensive way to improve your look. By that analogy, Smileys can improve the look of your[…]
Read moreInformative Charts / Data Visualizations
“All that glitters is not GOLD” Similarly “All Cool Looking Charts are not necessarily Informative Charts” An Informative Chart is[…]
Read moreTennis Dashboard in Excel
Who was better? Federer or Djokovic.. Nadal or Murray ATP uses following Dashboard to compare statistics between the players Although[…]
Read moreDASHBOARDS THAT INTERACT ON MOUSE MOVE
In my earlier post, I showed you how to create Excel Dashboards that interact when a cell is CLICKED or[…]
Read moreZoom Excel Dashboard to Fit Screen Size
I typically have to share my dashboards with a large audience. Some people use them on their laptops and others[…]
Read moreConditional Formatting Data Bars
In this post I am going to show you a simple but yet very informative Excel Dashboard constructed using Conditional[…]
Read moreDashboards that Interact on Cell Clicks
Today I was viewing one of the earliest Dashboards I created. This is one of the favorites of my colleagues.[…]
Read moreCustomized Sorting and it Limitations
Quite often we need Customized Sorting for our lists, pivot tables and slicers. Being an accountant and working with Financial[…]
Read moreDynamic Named Range
Dynamic Named Ranges can be very useful in creating Interactive Dashboards and Charts. I created the Interactive Chart below using[…]
Read more