Premium Excel Slicer Tutorial: How to Filter and Sort Top/Bottom 5
Excel has many different tools that can be made more efficient or optimized simply by combining different concepts, tools or functions. Of course, there is no exception when it comes to Excel slicers. By default and out of the box, Excel slicers are made to...
How Option Buttons Can be Used to Control Your Dashboard Number Formatting
It has been far too long since I last posted on my blog. Between removing the popcorn ceilings throughout our entire upstairs of our home and just the general craziness of the holiday season, I've had very little time to do anything. One of my goals in 2015 will be...
11 Unexpected Things I learned From Dissecting Chandoo’s Excel Dashboard Template
When it comes to Excel, my favorite topic and the thing I have the most fun with is building Excel dashboards. The truth is, a dashboard is like a picture, it's worth a 1000 words. You can LITERALLY at a glance determine the health of your business by simply...
6 Excel Charts, One Excel Chart Guide: How to Choose the Best Chart For You
When we are in the process of building an Excel dashboard or even just a chart for that matter, we want to be able to decide on a whim what chart type we need to use based on the result that we are looking for. My friend John Michaloudis over at myexcelonline.com was...
How the Large Formula Can Be The Secret Ingredient To Your Dashboard Preparation
The large formula is an excellent tool that I haven't really used that much until just recently. The beauty about it is that you can search through a large set of data, and identify the first, second, third, fourth .....Nth largest number/value in any given data set...
3 Intelligent Ways to Use Shapes in Excel
Excel shapes can play a vital role in making your dashboards and reports look amazing and can also be used for functional and practical purposes. I've put together a short list of intelligent ways you can use shapes in Excel. We're going to look at how to pretty up...