Training Annielytics Dashboard Course (Online) If you are a marketer who wants to learn more about how to work with Google Analytics and create sexy data in Excel using Google Analytics API data, you will love my Annielytics Dashboard Course video course. You will receive 16+ hours of training, a 142-page workbook, two starter dashboards that […]
Search Results for: excel
How To Create A Dynamic Chart From A Pivot Table [VIDEO]
In a post I wrote last week, I demonstrated in a video how to use advanced filters (one of Excel’s best-kept secrets) to divide a list of keywords into categories. I promised a commenter I would create a follow-up video demonstrating how I took those data sets and created a pivot chart that updated when […]
My Biggest Pivot Table Annoyance (And How To Fix It)
If you use pivot tables in Excel a lot like I do and you’ve ever had to pivot data with long entries, such as URLs (like from a Screaming Frog export or a content report from your analytics software), Excel will autofit your column to fit the longest entry in the column. This can […]