What Is It? Comprehensive The Excel Mini Course is an pivot on the Annielytics Dashboard Course, which is a full, comprehensive course on how to create dynamic dashboards that connect with Google Analytics in Excel. The Google Analytics Mini Course covers day 2 of the three-day course I originally did in person. It includes 24 instructional videos, totaling 6+ hours […]
Search Results for: excel
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 business is seasonal. But even for non-seasonal sites like yours truly’s, it’s good to get the 100-foot view of how your site is performing compared to the same time last year. Here’s an example of how […]
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 allow more data in a small space, such as a dashboard. You can see how this will look in the animated gif below: I use the INDEX function […]