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 Chart Year-Over-Year Google Analytics Reports In Excel [VIDEO]
Measuring year-over-year growth in your analytics data is oftentimes much more important than month-over-month traffic trends, especially if your … [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...]