What Is It?
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.
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.
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.)
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.
— Google Analytics (@googleanalytics) February 27, 2014
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:
The Excel Mini Course is $95 and includes 24 videos, totaling 6+ hours of video instruction.
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! 🙂