Zoom 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 moreCategory: Excel Dashboards
Conditional 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 moreScroll Bar (Form Control)
Scroll Bars in Excel Dashboards In this post I am going to show you how to use Scroll Bars to[…]
Read morePower BI Charts’ Interactions
By default, Power BI data charts interact each other in the following manner. i.e. An item selection in a chart[…]
Read moreMultiple Select List Boxes
Multiselect Listbox is a very handy tool which allows users to make multiple selections from a complete list. It can[…]
Read more