Master Reporting Automation with Google Sheets

- Description
- Curriculum
- FAQ
- Reviews
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
-
6IntroductionVideo lesson
-
7Key Formula Combination - INDEX & MATCHVideo lesson
-
8Determining Year with TEXTVideo lesson
-
9Smart use of IF's - Dynamic SUMIF and AVERAGEIFVideo lesson
-
10Use of COUNTIF(S)Video lesson
-
11Identify ROW & COLUMN NumbersVideo lesson
-
12RANK the DataVideo lesson
-
13Avoid Errors with IFERRORVideo lesson
-
14Improve Calculation Accuracy with AVERAGE.WEIGHTEDVideo lesson
-
15Key Formula QuizQuiz
Let's see what you've learned!
-
16IntroductionVideo lesson
-
17Pulling Data with INDIRECT & ADDRESSVideo lesson
-
18Use OFFSET for Dynamic CalculationsVideo lesson
-
19IMPORTRANGE with INDEX & MATCHVideo lesson
-
20Advanced Formula: QUERYVideo lesson
-
21Advanced Formula: QUERY 2Video lesson
-
22Section RecapVideo lesson
-
23Key Formula 2 QuizQuiz
Let's see what you've learned!
-
24IntroductionVideo lesson
-
25Mapping Down the MetricsVideo lesson
-
26Defining the Week Periods and Week ReferencesVideo lesson
-
27Connecting the Formulas with INDEX & MATCHVideo lesson
-
28Setting Up Budget Connections and CalculationsVideo lesson
-
29Formatting of Week NumbersVideo lesson
-
30Visual FormattingVideo lesson
-
31Project Mapping QuizQuiz
Let's see what you've learned!
-
32IntroductionVideo lesson
-
33Defining Sheet StructureVideo lesson
-
34Setting Up Forecasting FormulasVideo lesson
-
35Advanced: Connecting Stable Metrics to DatasetVideo lesson
-
36Linking Targets with ActualsVideo lesson
-
37Defining Current Week through TODAY FormulaVideo lesson
-
38Target Conversion from Weekly to MonthlyVideo lesson
-
39Comparison between Targets and BudgetsVideo lesson
-
40Notification for Reconciliation with BudgetsVideo lesson
-
41Sections RecapVideo lesson
-
42Forecasting QuizQuiz
Let's see what you've learned!
-
43IntroductionVideo lesson
-
44Defining Sheet StructureVideo lesson
-
45Connecting the FormulasVideo lesson
-
46Not Showing Data for Unpassed WeeksVideo lesson
-
47Calculating the VariancesVideo lesson
-
48Conditional Formatting for VariancesVideo lesson
-
49Conditional Color NotificationsVideo lesson
-
50Final TouchesVideo lesson
-
51Comparison Building QuizQuiz
Let's see what you've learned!
-
59IntroductionVideo lesson
-
60Defining Sheet StructureVideo lesson
-
61Connecting the Data to the TabVideo lesson
-
62Color Coding for Weekly TrendsVideo lesson
-
63Color Coding for Monthly BudgetsVideo lesson
-
64Final TouchesVideo lesson
-
65Actuals vs Budget QuizQuiz
Let's see what you've learned!
-
66IntroductionVideo lesson
-
67Defining Sheet StructureVideo lesson
-
68Creating the Framework for Competitor TrackingVideo lesson
-
69Adding Formulas to FrameworkVideo lesson
-
70Estimating Competitor and Market SizeVideo lesson
-
71Summary of Key MetricsVideo lesson
-
72Final TouchesVideo lesson
-
73Connection with Other TabsVideo lesson
-
74Sections RecapVideo lesson
-
75Market Sizing QuizQuiz
Let's see what you've learned!
-
76IntroductionVideo lesson
-
77Intro to the First GraphVideo lesson
-
78Data Visualisation PrinciplesVideo lesson
-
79Graph I: Key Actuals with TargetsVideo lesson
-
80Graph II: Monthly Actuals with Budgeted ForecastsVideo lesson
-
81Dynamic Table: Data Layout for Competitor TrackingVideo lesson
-
82Dynamic Table: Ranking for Competitor TrackingVideo lesson
-
83Graph III: Tracking Weekly Performance over Monthly BudgetVideo lesson
-
84Final TouchesVideo lesson
-
85Section RecapVideo lesson
-
86Data Visualisation QuizQuiz
Let's see what you've learned!

External Links May Contain Affiliate Links read more