A free 5 lesson email course

Google Sheets for Marketers

“What Google Sheets skills should I have as a marketer?”

Above question is from a user in a marketing forum – and it’s something I read a lot.

What future proof skills you should learn is one of the biggest concerns for every marketer who wants to stand out or who wants to be well prepared for the job.

A common answer to this is Google Sheets/Excel and I completely agree with how essential those skills are. Skills such as Google Sheets/Excel and basic marketing analysis will be expected as must haves from all marketers in the next couple of years.

But what exactly should you learn? What will be useful for the job and what will be a waste of time…?

  • Should you know pivot tables?
  • Should you only learn formulas such as MAX, MIN and VLOOKUP or is there anything else ?
  • Do you really need QUERY and AppScript?

Even worse most Google Sheets/Excel courses out there teach you one formula and function after the other without any context.

And afterwards you still don’t know how to apply them to marketing use cases… Or how to actually gain insights from marketing data….

“…impossible to find more detail-oriented and precise guides for marketers…”

I have to say that it would be impossible to find more detail-oriented and precise guides for marketers than the ones you wrote. I admit it wasn’t too easy to follow, especially when it came to formulas (it’s really everybody’s weakness, mine included), but overall the format really helped going forward.

★★★★★

Lino LacalandraDigital Marketer, Freelancer

So, wouldn’t it be great to learn Google Sheets in a way that it would actually be useful in a marketing environment?

Imagine:

  • You would learn exactly those Google Sheets skills that get you ahead and let you stand out as a marketer.
  • You would learn only those things you need – without wasting time on non-essential stuff.
  • You could draw actionable insights from data to recommend next steps for the business.
  • You would get specific use cases for how to use the learned formulas and functions.

And, while you’re imagining that lovely scenario… What if you could learn Google Sheets formulas and functions in a way where they are used as tools rather than being learning goals on their own…

A free 5 lesson Google Sheets course for marketers

I designed Google Sheets for Marketers from the ground up to help you get most out of the time you invest in the course. The course itself is based on real life marketing case examples to make it as hands on and practicable as possible.

You’ll analyze and report the performance of different marketing channels of an ecommerce store and finally create a marketing plan as well as an automatically updating reporting dashboard. All is done via step-by-step guides and ready to use templates.

It is designed to understand and learn…

  • the most important Google Sheets formulas & functions (incl. Pivot Tables) for marketers.
  • how to communicate data insights with charts.
  • how to build simple dashboards to report data from your marketing channels.
In less than a couple of hours you will have a solid  foundation in future proof Google Sheets skills – without wasting time researching what and where you should learn.