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 moreI typically have to share my dashboards with a large audience. Some people use them on their laptops and others[…]
Read moreThe normal behavior of slicer is to filter the associated Pivot Tables and Pivot Charts How can we make Slicers[…]
Read moreCONCATENATEX is a DAX function introduced in Power Pivot for Excel 2016. It wont work in Excel 2013 or 2010[…]
Read moreGrouping and Banding makes analysis easier and convenient Consider for example this table of 250 billionaires taken from www.forbes.com/billionaires/list Click[…]
Read moreIn this post I am going to show you a simple but yet very informative Excel Dashboard constructed using Conditional[…]
Read moreToday I was looking at an old post from www.powerpivotpro.comĀ https://powerpivotpro.com/2011/10/user-friendly-report-sorting-with-slicers/ Rob Collie uses an ingenious technique to sort the[…]
Read moreToday I was viewing one of the earliest Dashboards I created. This is one of the favorites of my colleagues.[…]
Read moreEARLIER function is hard to understand in first go but it is even harder to explain. “EARLIER” is needed when[…]
Read moreArray formulas are powerful formulas in Excel that perform calculations using multiple ranges of cells. They are also known as[…]
Read moreQuite often we need Customized Sorting for our lists, pivot tables and slicers. Being an accountant and working with Financial[…]
Read more