Note: Bad news — All the cool API Excel extensions are PC swim only. Backstory When the Annielytics' Dashboard Course was first released, Excellent … [Read more...]
How to Dynamically Generate URLs on the Fly in Excel or Google Sheets
Why Include Dynamic Links in Dashboards When I create dashboards, I like to add as many resources as possible for stakeholders who want more … [Read more...]
How To Create A Scrolling Table In Excel [VIDEO]
In today's video I demonstrate how to create a scrolling table in Excel using the scrollbar option in your format controls. This is a great way to … [Read more...]
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 … [Read more...]
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 … [Read more...]