Here is where you will find all of the videos available for the Annielytics Google Analytics and Excel Mini-Course. These videos were selected from the Annielytics Dashboard Course, which is a 16-hour online course that will teach you how to leverage the Google Analytics API to create sexy reporting dashboards. These videos will teach you how to navigate the Google Analytics user interface and create reports, along with how to create charts and graphs, format data dumps, and use conditional formatting in Excel.
If, at any point, you have questions or complaints about the course or technical issues, please let us know by filling out one of our insanely short forms.
Google Analytics
Excel
| Excel Formatting | 00:13:48 |
| Excel Navigation Tips | 00:16:03 |
| Table Formatting | 00:18:09 |
| Number Formatting | 00:22:38 |
| Data Bars | 00:12:28 |
| Icon Sets | 00:17:00 |
| Heat Maps | 00:11:57 |
| Date Alert Formatting | 00:17:21 |
| Pie & Column Charts | 00:28:29 |
| Bar, Area & Scatter Charts | 00:28:57 |
| Creating Pivot Tables | 00:09:33 |
| Formatting Pivot Tables | 00:11:72 |
| Pivot Charts | 00:16:01 |
| Linking AdWords to Google Analytics | 00:13:03 |
| Functions & Dynamic Titles | 00:12:21 |
| YoY % Change Visualization | 00:11:31 |
| Combination Column Charts | 00:14:58 |
| Dynamic Drop Down Chart I | 00:17:36 |
| Dynamic Drop Down Chart II | 00:12:40 |
| Dynamic Check Box Chart | 00:14:03 |
| Dynamic Radio Button Chart I | 00:16:18 |
| Dynamic Radio Button Chart II | 00:06:13 |
| Dynamic Scrolling Chart | 00:14:17 |
| Dynamic Ranges | 00:14:38 |