Bring your Google Sheets skills to the next level.

Learn to solve any business modeling task you might ever experience! Have you ever felt that you're regularly repeating some tasks in Google Sheets or Excel? Have you ever thought about the time you would save if you would automate those tasks?

All the work you're doing in a repetitive manner in Google Sheets or Excel could be automated. And that’s where I can help. I’m the Head of Business Analytics at European fastest growing technology firm Bolt, where I’m standing just in the middle of tech and business people. And as you might know, business people love spreadsheets. Simply because they are so easy to use, you can do so many ad-hoc analyses there, and it’s purely a common-sense tool to use.

But that doesn’t mean that people know how to use it right. People often use clunky formulas and esthetically unappealing formatting practices, which doesn’t make the dashboards and files the most user-friendly to use. Moreover, when something is not visually and technically working as effectively as it could, it slows down every user from focusing on things that matter and that results often in lower quality of work — with absolutely no good reason for that.

Hence, I’m a pure advocate of well-looking and fully automated spreadsheets that require a minimal amount of manual effort and can easily be scaled to hundreds of different files used by thousands of people daily. All this involves a combination of highly complex formulas, effective data visualisation, mathematical thinking and often syncing your spreadsheets with scripts such as Python or Google Apps Script.

And that’s why I have created this course. I've worked with spreadsheets for a long time and always have got amazing feedback from all the people who've been using dashboards and tools built by me. So one day, I decided that instead of only producing dashboards for other people, I'd rather teach them how to do ones themselves. And that’s why I have created this course. To give all my core knowledge over to you, so you can become more effective in what you do, and continue building on top of this knowledge even further.

It’s all up to you, eventually. But what I can offer is 6.5 hours of highly valuable content, packed to an online course using the skills that I’d want to pass over to you.

What you'll learn

• Advanced Google Sheets / Excel formulas that help you to solve any business modeling task you might ever experience

• How to make your files look professional and easy-to-track

• Creating highly complex formula combinations that will save you hours of time from automating manual work

• How to minimise manual reporting and focus on value-creating tasks

• Analytical skills on how to approach competitor analytics and market size estimation

• Tips and tricks to effective data visualisation

• Create an automated business forecasting framework that works

• How to build a complete reporting system in Google Sheets with maximum automation

• Ideas how to combine Google Sheets with (Python) scripts

• Secrets how to impress your colleagues with your exceptional Excel skills

Spreadsheets (Excel or Google Sheets) are the core part of every professional’s toolbox who’s working closely with management or other business people. So be sure to have your skills on the expected level to climb up in your professional career and achieve everything you’ve come after for.

Who this course is for:

• Experienced Financial Analysts, Financial Controllers, CFOs or Business Analysts interested in automating their company's reporting

• Students who want to get a job in financial / business modelling or reporting area and wants to boost their chances by adding new skills to their resume

• Business professionals, who want to increase the efficiency of their reporting work and focus more time on things that matter

• People interested impressing their managers and co-workers with their exceptional skills