SUBTOTAL in Excel

I generally do not write about Microsoft Excel, for the daily inspiration dose of dashboard heroics I look at Chandoo’s site. However, today I stumbled upon SUBTOTAL and was amazed at what it can do! At work, in Pristine, we run daily numbers of all our online marketing campaigns. Reporting numbers in a template is one thing, and to analyze them is something totally different. As I was sifting through the daily numbers, I realized that for each Excel filter I am running, if there were a summary dashboard, then it will be easier to analyze. Continue reading