Fill All Blank Cells in an Excel Range With a Desired Value
Here’s a nifty little trick I use every day while working in Excel. It’s a two part trick. Part one will be selecting all the blank cells in a range… Read more »
Monthly Archives: June 2016
Formula to get the start or end of the week date
On many occasions and in many dashboards, time will be the main factor of your analysis and reports. As far as time goes, you can do a Yearly, Quarterly, Monthly,… Read more »
Creating PowerView Dashboards from the PowerPivot Gallery Data Sources
The real benefit of hosting your PowerPivot workbooks within a PowerPivot Gallery is that people can then report off the data source as if it were a mini data warehouse… Read more »
IFERROR Puts an End to Messy Workarounds
It can be used as a ‘wrapper’ to hide many different errors; #DIV/0, #NAME?, #NULL, #NUM, #REF, #VALUE, and one of the most common being VLOOKUP’s #N/A error. In this… Read more »