View the Course Trailer
Want to become the go-to person for any topic related to Google Sheets? It can happen.
Watch the trailer to understand all the wonderful Google Sheets tricks this course will teach to you!
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. It requires no coding skills, add-ons, or special tools - all you need to know is how to execute advanced formula combinations that will do all the automation for you.
This course focuses on teaching you the right skill set, so you could solve any business modeling task you might ever experience. I don't want to teach you only to execute some certain format of automation, I want you to be able to think outside of a certain tool - to literally be able to solve anything in the reporting automation or business modeling area. Everything we're learning along the course (which is a lot, really!) is only the start for you. I promise that after you complete the whole course, you will have tons of ideas on how to make your current work more efficient and automated.
This is a very hands-on course. You will learn the key formulas, practice them, build a complex but rewarding project, and then try to solve the challenges on your own. The course is designed to give you advanced-level skills that you will feel comfortable executing later in your own work. Please note that this is not a beginner-level course by design and by any means. However beginners are welcomed to take the course in case you're prepared to learn a lot by yourself in parallel and make some extra effort while taking this course.
What you can look forward to in this course:
- Learn highly advanced and complex formula combinations that help you to solve any business modeling task you might ever experience
- Build scalable and automated reporting tools that don't break
- Expertise how to make your files look professional and easy-to-track
- Work out automated and semi-automated business forecasting methodology
- 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
- Build a framework for market size estimation and competitor tracking (with real examples!)
- Create impressive charts and learn tips & tricks to effective data visualisation
- Receive a fully functional business reporting template in Google Sheets with maximum automation, which you'll also build from scratch
- Secrets how to impress your colleagues with your exceptional Google Sheets skills
- Learn tips & tricks for future development
- Ideas how to combine Google Sheets with (Python) scripts
- Complete a lot of exercises
- Save hundreds of hours of time with only you being required to take this course
Are there any course requirements or prerequisites?
- At least intermediate level Excel / Google Sheets skills
- Google account to build the reporting solution along with the course
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
About the instructor: Mariel Aim
Director of Business Analytics in a tech company
My name is Mariel Aim and I am so excited that you're reading this!
Professionally, I work for the European fastest growing technology company Bolt as the Director of Business Analytics where I'm responsible for the whole business analytics and financial planning domain of a business vertical with over €7B valuation. Prior, I have a background in consulting (specifically M&A) and hold an MBA in Economics with sub-focus on data science.
One of my core competencies is business modeling - and anything that has to do with Google Sheets. I have worked out a number of key business reporting solutions from scratch for the management, cross-functional and operational teams to use, which have saved thousands of hours in time and improved the reporting quality and convenience to a very high extent. Sometimes I think that if Google Sheets Engineering would be a job, this probably would be mine. ☺
I'm a strong believer in a world full of automating the non-value creating and routine tasks. And I can't wait for sharing my knowledge with you!
From Ben R.
I've taken several online courses, some of which were fantastic, but this is the first course (I believe) that is so good that I feel compelled to leave a review. I'm a web developer with interest in Google Workspace automation. I've always preferred to do all the automation in Apps Script, but some of my clients asked for solutions using Google formulas. This course is excellent in going super-deep and hands-on on automating reporting. The instructor clearly has deep industry experience in not only the technical aspects of automating reports that business executives consume, but also in how to handle a spreadsheet effectively and efficiently. So it's not just about mastering the formulas but also about how to operate the spreadsheet and its data. I recommend this course wholeheartedly.
From Imtiaz S.
This is one of the extraordinary online courses I have ever undergone. The instructor is purely straight to the point and makes it very easier to understand. So far I completed almost 25% of it and "use of dollar sign" "IFERROR" , "INDEX and MATCH", "TRANSPOSE", "IMPORTRANGE' are great learnings and life savings. Thanks to the instructor for putting such effort. I highly recommend this course for those who want to get the most out of Google Sheets.
From Carlos A.
The course is FANTASTIC! First, it is clear that Mariel knows the topic. She is a real professional and it becomes clear as we progress in the course. I have used Excel for 21 years. I am still a heavy user. However I was made aware of the great use of query function within Google Sheets a while ago and started to understand the power of Google Sheets. This course may not be perfect for beginners, however, for intermediate and advanced users, it is FANTASTIC. Thanks Mariel for the amazing course. I really enjoyed your teaching style and your expertise. What a treat! Thanks.
Review The Curriculum
- Introduction (1:10)
- Key Formula Combination - INDEX & MATCH (7:03)
- Determining Year with TEXT (2:07)
- Smart use of IF's - Dynamic SUMIF and AVERAGEIF (7:51)
- Use of COUNTIF(S) (3:38)
- Identify ROW & COLUMN Numbers (2:14)
- RANK the Data (1:52)
- Avoid Errors with IFERROR (2:40)
- Improve Calculation Accuracy with AVERAGE.WEIGHTED (2:20)
- Key Formula Quiz
- Introduction (0:42)
- Defining Sheet Structure (5:01)
- Setting Up Forecasting Formulas (8:57)
- Advanced: Connecting Stable Metrics to Dataset (11:48)
- Linking Targets with Actuals (6:51)
- Defining Current Week through TODAY Formula (3:09)
- Target Conversion from Weekly to Monthly (5:28)
- Comparison between Targets and Budgets (6:04)
- Notification for Reconciliation with Budgets (8:40)
- Sections Recap (1:19)
- Forecasting Quiz
- Introduction (0:56)
- Defining Sheet Structure (1:40)
- Creating the Framework for Competitor Tracking (3:08)
- Adding Formulas to Framework (5:35)
- Estimating Competitor and Market Size (10:27)
- Summary of Key Metrics (8:34)
- Final Touches (7:10)
- Connection with Other Tabs (8:23)
- Sections Recap (1:36)
- Market Sizing Quiz
- Introduction (1:41)
- Intro to the First Graph (1:10)
- Data Visualisation Principles (2:11)
- Graph I: Key Actuals with Targets (17:55)
- Graph II: Monthly Actuals with Budgeted Forecasts (12:16)
- Dynamic Table: Data Layout for Competitor Tracking (10:57)
- Dynamic Table: Ranking for Competitor Tracking (6:03)
- Graph III: Tracking Weekly Performance over Monthly Budget (10:31)
- Final Touches (0:47)
- Section Recap (1:51)
- Data Visualisation Quiz
Featured Products
Interested in more? Learn skills via online course, get mentoring for career growth or consultation for projects. Your choice!
