Excel Mini Course

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.)

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

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! 🙂