• Skip to main content

Annielytics.com

I make data sexy

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

Excel Mini Course

Annie Cushing in Google Analytics training
So I may or may not get a little animated when I talk about making data sexy …

What Is It?

Comprehensive

The Excel Mini Course is an pivot on the Annielytics Dashboard Course, which is a full, comprehensive course on how to create dynamic dashboards that connect with Google Analytics in Excel. The Google Analytics Mini Course covers day 2 of the three-day course I originally did in person. It includes 24 instructional videos, totaling 6+ hours of instruction and is the perfect solution if you’re just looking to learn more about Excel but don’t need to build out dynamic dashboards at this time.

Practical 

While most courses take more of an academic approach to Excel (which I’ve personally benefited from tremendously), this course takes much more of a hands-on, soup-to-nuts approach to teaching marketers what to report on, and how to visualize their findings. I break the concepts down in the simplest of terms so that even someone totally new to Excel could follow along.

Basically, any concept that was more difficult for me to grasp in my early days was treated with special care to ensure subscribers have a fighting chance at really mastering the skills needed to put me out of work ramp up your skill set as a marketer. I’m actually jealous of subscribers because this course covers everything I wish I had known starting out.

Career Boosting

Seriously, these skills will set your LinkedIn profile on fire. Do you know how desperate companies are for marketers who can walk into a job and be able to help them visualize and make sense of their data? Potential employers will be fighting over you. (And anyone who has followed me knows that I’m not given to hyperbole.)

buy-now-button

My Sojourn

The bane of most marketers’ existence is proving the effectiveness of their work. I remember all too well, in my early days as an in-house analyst, the utter frustration of taking screenshots and exporting PDFs from Google Analytics (hey, don’t judge!) and trying to tell a story decision makers would find compelling.  Because of that struggle, I’ve made it my mission to provide as many resources as is humanly possible for other marketers and analysts who face the same frustrations I have had to scale. Some of these include my Google Analytics campaign tagging guide, my Hundreds of Tools for Marketers resource, and my inexpensive, self-guided audit template. And my blog has also been recommended by Google itself as a useful resource for marketers and analysts.

Have you checked out @anniecushing's blog before? Lots of useful posts on Analytics. Explore them here: http://t.co/2GLyKXMKPQ

— Google Analytics (@googleanalytics) February 27, 2014

By the time you get to the end of this course, you will have a solid grasp on how to work with Excel to tell the story your data is dying to tell.  

Curriculum

I couldn’t possibly reduce everything you will learn in this section to a bullet list. But here are just a few of things you will be able to:

  • Tightly organize the data in your dashboard
  • Create a blueprint for others to be able to easily find the data that feeds each of your visualizations
  • Interlink elements of your dashboard for ease of navigation
  • Choose which charts should be used for various types of data sets
  • Spice up tabular data (data in tables) to make it easier to interpret
  • Create visualizations that maintain best practices of data design
  • Align your dashboard design with your branding (including how to easily replicate these formats in all of your Excel docs across your entire company)
  • Create charts with varying depths of detail without overwhelming your dashboard recipients
  • Display month-over-month and year-over-year data in charts and tables
  • Organize complex data sets with pivot tables before charting them

Here’s a list of the video titles:

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

buy-now-button

Pricing

The Excel Mini Course is $95 and includes 24 videos, totaling 6+ hours of video instruction.

Fine Print

Please look over the Terms of Service to read all the scintillating fine print. At least check out the pic of my attorney after writing up this exhausting piece of legalese! 🙂

Copyright © 2025