Google Analytics & Excel Mini-Course Table of Contents

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

Course Introduction	00:25:05
Custom Reports & Pivot Tables	00:16:31
Custom Reports & Regex	00:14:18
Google Analytics Interface & Channel Report	00:14:32
Audience Overview Report	00:17:10
Data Row Number Hack	00:07:51
Google Analytics Terminology	00:14:04
Google Analytics Filters & Admin Area	00:14:45
Deduping Content Reports	00:08:46
Site Search Reports	00:10:15
Google Analytics Dashboards	00:13:45
Real-Time & Audience Reports	00:04:36
Behavior Reports	00:07:40
Google Analytics API	00:13:11
Custom Variables & Device Category	00:14:02
Custom Variable Scope	00:10:49
Acquisition Reports & Campaign Tagging	00:14:47
How to Handle “Not Provided” Data	00:14:36
Linking AdWords to Google Analytics	00:13:03
Behavior Reports	00:12:48
Site Content & Site Speed Reports	00:14:38
Sight Search & Event Tracking	00:15:01
Campaign Tagging	00:08:33
Event Tracking & Goal Reports	00:13:18
Ecommerce & Multi-Channel Funnel Reports	00:13:21
Assisted Conversion Report	00:11:12
Sampling Explained	00:21:51
Google Analytics Campaigns	00:18:27

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