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
-
Build scalable and automated reporting tools that don’t break
-
Build files that don’t require any manual intervention for keeping them working
-
Learn how to make your files look professional and easy-to-track
-
Work out automated and semi-automated business forecasting methodology
-
Build a framework for market size estimation and competitor tracking (with real examples!)
-
Create impressive charts
-
Receive a fully functional business reporting template
-
Learn tips & tricks for future development (like using scripts)
-
Complete a lot of exercises
-
Save hundreds of hours of time with only you being required to take this course
Learn and Practice the Key Formulas
Learn and Practice the Key Formulas: Advanced Section
-
6Introduction
-
7Key Formula Combination - INDEX & MATCH
-
8Determining Year with TEXT
-
9Smart use of IF's - Dynamic SUMIF and AVERAGEIF
-
10Use of COUNTIF(S)
-
11Identify ROW & COLUMN Numbers
-
12RANK the Data
-
13Avoid Errors with IFERROR
-
14Improve Calculation Accuracy with AVERAGE.WEIGHTED
-
15Key Formula Quiz
Let's see what you've learned!
Putting Together the Project
Adding the Forecasts
Building the Comparison Between Actuals and Forecasts
-
32Introduction
-
33Defining Sheet Structure
-
34Setting Up Forecasting Formulas
-
35Advanced: Connecting Stable Metrics to Dataset
-
36Linking Targets with Actuals
-
37Defining Current Week through TODAY Formula
-
38Target Conversion from Weekly to Monthly
-
39Comparison between Targets and Budgets
-
40Notification for Reconciliation with Budgets
-
41Sections Recap
-
42Forecasting Quiz
Let's see what you've learned!
Designing the Landing Page
Reconciling Weekly Actuals with Monthly Budgets
Setting Up Competitor and Market Size Tracking
Professional and Effective Data Visualisation
-
66Introduction
-
67Defining Sheet Structure
-
68Creating the Framework for Competitor Tracking
-
69Adding Formulas to Framework
-
70Estimating Competitor and Market Size
-
71Summary of Key Metrics
-
72Final Touches
-
73Connection with Other Tabs
-
74Sections Recap
-
75Market Sizing Quiz
Let's see what you've learned!
Creating Dynamic and Reliable Data Connections
-
76Introduction
-
77Intro to the First Graph
-
78Data Visualisation Principles
-
79Graph I: Key Actuals with Targets
-
80Graph II: Monthly Actuals with Budgeted Forecasts
-
81Dynamic Table: Data Layout for Competitor Tracking
-
82Dynamic Table: Ranking for Competitor Tracking
-
83Graph III: Tracking Weekly Performance over Monthly Budget
-
84Final Touches
-
85Section Recap
-
86Data Visualisation Quiz
Let's see what you've learned!