Excel Mini Course Table of Contents

Here is where you will find all of the videos available for the Annielytics 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 focus solely on Excel, how to create charts and graphs, format data dumps, use conditional formatting, and more.

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.

Course Downloads

You can download the course files here.

Table of Contents

Excel Formatting	00:13:19
Excel Navigation Tips	00:09:51
Excel Tips	00:09:51
Dashboarding Tips	00:09:35
Data Mapping	00:07:17
Dashboard Updating	00:10:11
Table Formatting	00:14:13
Table & Number Formatting	00:11:36
Date Formatting	00:13:44
Conditional Formatting & Percent Change	00:15:48
Conditional Formatting & Icon Sets	00:11:37
Heat Maps & Date Alert Formatting	00:16:39
Pie Charts	00:14:19
Column Charts	00:11:32
Bar Charts	00:12:14
Bar Charts Continued	00:07:43
Area & Scatter Charts	00:13:04
Creating Pivot Tables	00:09:42
Pivot Tables & Charts	00:12:28
Excel Templates	00:08:58
Excel Formulas	00:15:55
Excel Functions	00:15:21
YoY % Change Visualization	00:11:30
Combination Column Charts	00:12:47
Combination Column Charts Continued	00:09:27
Dynamic Drop Down Chart I	00:14:58
Dynamic Drop Down Chart II	00:10:09
Dynamic Check Box Chart	00:14:03
Dynamic Radio Button Chart I	00:15:22
Dynamic Radio Button Chart II	00:06:13
Dynamic Scrolling Chart	00:14:17
Dynamic Ranges	00:14:38
Dynamic Ranges & Wrap Up	00:05:08