• Skip to main content

Annielytics.com

I make data sexy

  • About
  • Services
  • Tools
  • Blog
  • Portfolio
  • Contact
  • Log In

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

Copyright © 2025