How To Use The SUMIF And SUMIFS Functions To Build Dynamic Dashboards [VIDEO]

In today’s #FunctionFriday post we’re going to look at how the SUMIF and SUMIFS functions can be used to build out interactive dashboards like the ones below I just added to my dashboard course for subscribers to apply to their data.   Note: If you want to reanimate the images, just refresh the page with a […]

Best Tool To Master Dimensions And Metrics In Google Analytics

I’m kicking off a new series of posts where I highlight different dimensions in Google Analytics. And I thought of no better way to start than to share my go-to tool any time I’m stuck on which dimension or metric to use. It’s actually published by Google in their resource for developers. I know what you’re thinking […]

The INDEX Function: Excel’s More Stable Alternative To OFFSET [VIDEO]

Back in March I did a post on three marketing uses for the OFFSET function. But, truth be told, I avoid the OFFSET function like the plague. The reason is that it’s very unstable and can bring large Excel files to their knees. Why? Every time you modify the file the OFFSET function takes that as […]

The Annielytics Dashboard Course Is Live!

I’ll keep this brief. As I predicted in this post, the Annielytics Dashboard Course is now live! We’ve been working around the clock to take the footage from my last live seminar and bring it online. What Drove Me I’m not going to repeat what I’ve already written at length in my last blog post […]