All in One Offer! | Access Unlimited Courses in any category starting at just $29. Offer Ends in:

Browse Library

  • Business Solutions
  • Become an Instructor
  • 0
    Shopping Cart

    Your Cart is empty. Keep shopping to find a course!

    Browse Courses
Get Unlimited Learning Access
$29
6 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Instant access to 11,000+ online courses
  • Play & Pause Course Videos
  • HD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Chat Support
  • Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
$348 $244 a year Save 30%
6 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Instant access to 11,000+ online courses
  • Play & Pause Course Videos
  • HD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Chat Support
  • Cancel Plan Anytime
$29
$244
  • 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

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

  • At least intermediate level Excel / Google Sheets skills
  • Google account to build the reporting solution along with the course
  • 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
View More...
  • Section 1 : Introduction 4 Lectures 00:03:00

    • Lecture 1 :
    • Lecture 2 :
    • Why Google Sheets, not Excel?
    • Lecture 3 :
    • Quick Example: How to Efficiently Automate Reporting
    • Lecture 4 :
    • Overview of Course Projects
  • Section 2 : Learn and Practice the Key Formulas 10 Lectures 00:09:00

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Key Formula Combination - INDEX & MATCH
    • Lecture 3 :
    • Determining Year with TEXT
    • Lecture 4 :
    • Smart Use of IF's - Dynamic SUMIF and AVERAGEIF
    • Lecture 5 :
    • Use of COUNTIF(S)
    • Lecture 6 :
    • Identify ROW & COLUMN Numbers
    • Lecture 7 :
    • RANK the data
    • Lecture 8 :
    • Avoid Errors with IFERROR
    • Lecture 9 :
    • Improve Calculation Accuracy with AVERAGE.WEIGHTED
    • Lecture 10 :
    • Key Formula Quiz
    • Key Formula Quiz
  • Section 3 : Learn and Practice the Key Formulas: Advanced Section 8 Lectures

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Pulling Data with INDIRECT & ADDRESS
    • Lecture 3 :
    • Use OFFSET for Dynamic Calculations
    • Lecture 4 :
    • IMPORTRANGE with INDEX & MATCH
    • Lecture 5 :
    • Advanced Formula: QUERY
    • Lecture 6 :
    • Advanced Formula: QUERY 2
    • Lecture 7 :
    • Section Recap
    • Lecture 8 :
    • Key Formula 2 Quiz
    • Key Formula 2 Quiz
  • Section 4 : Putting Together the Project 8 Lectures 00:13:46

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Mapping Down the Martics
    • Lecture 3 :
    • Defining the Week Periods and Week References
    • Lecture 4 :
    • Setting Up Budget Connections and Calculations
    • Lecture 5 :
    • Formatting of Week Numbers
    • Lecture 6 :
    • Visual Formatting
    • Lecture 7 :
    • Connecting the Formulas with INDEX & MATCH
    • Lecture 8 :
    • Project Mapping Quiz
    • Project Mapping Quiz
  • Section 5 : Adding the Forecasts 11 Lectures

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Defining Sheet Structure
    • Lecture 3 :
    • Setting Up Forecasting Formulas
    • Lecture 4 :
    • Advanced: Connecting Stable Metrics to Dataset Preview
    • Lecture 5 :
    • Linking Targets with Actuals
    • Lecture 6 :
    • Defining Current Week through TODAY Formula
    • Lecture 7 :
    • Target Conversion from Weekly to Monthly
    • Lecture 8 :
    • Comparison between Targets and Budgets
    • Lecture 9 :
    • Notification for Reconciliation with Budgets
    • Lecture 10 :
    • Sections Recap
    • Lecture 11 :
    • Forecasting Quiz
    • Forecasting Quiz
  • Section 6 : Building the Comparison Between Actuals and Forecasts 9 Lectures 00:07:39

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Defining Sheet Structure
    • Lecture 3 :
    • Connecting the Formulas
    • Lecture 4 :
    • Not Showing Data for Unpassed Weeks
    • Lecture 5 :
    • Calculating the Variances
    • Lecture 6 :
    • Conditional Formatting for Variances
    • Lecture 7 :
    • Conditional Color Notifications
    • Lecture 8 :
    • Final Touches
    • Lecture 9 :
    • Comparison Building Quiz
    • Comparison Building Quiz
  • Section 7 : Designing the Landing Page 7 Lectures

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • What to Include in the Cover tab?
    • Lecture 3 :
    • Table of Contents
    • Lecture 4 :
    • Linking Key Information
    • Lecture 5 :
    • Use your Brand Colours
    • Lecture 6 :
    • Section Recap
    • Lecture 7 :
    • Landing Page Quiz
    • Landing Page Quiz
  • Section 8 : Reconciling Weekly Actuals with Monthly Budgets 7 Lectures 00:15:43

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Defining Sheet Structure
    • Lecture 3 :
    • Connecting the Data to the Tab
    • Lecture 4 :
    • Color Coding for Weekly Trends
    • Lecture 5 :
    • Color Coding for Monthly Budgets
    • Lecture 6 :
    • Final Touches
    • Lecture 7 :
    • Actuals vs Budget Quiz
    • Actuals vs Budget Quiz
  • Section 9 : Setting Up Competitor and Market Size Tracking 10 Lectures 00:00:56

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Defining Sheet Structure
    • Lecture 3 :
    • Creating the Framework for Competitor Tracking
    • Lecture 4 :
    • Adding Formulas to Framework
    • Lecture 5 :
    • Estimating Competitor and Market Size
    • Lecture 6 :
    • Summary of Key Metrics
    • Lecture 7 :
    • Final Touches
    • Lecture 8 :
    • Connection with Other Tabs
    • Lecture 9 :
    • Sections Recap
    • Lecture 10 :
    • Market Sizing Quiz
    • Market Sizing Quiz
  • Section 10 : Professional and Effective Data Visualization 11 Lectures

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Intro to the First Graph
    • Lecture 3 :
    • Data Visualisation Principles
    • Lecture 4 :
    • Graph I: Key Actuals with Targets
    • Lecture 5 :
    • Graph II: Monthly Actuals with Budgeted Forecasts
    • Lecture 6 :
    • Dynamic Table: Data Layout for Competitor Tracking
    • Lecture 7 :
    • Dynamic Table: Ranking for Competitor Tracking
    • Lecture 8 :
    • Graph III: Tracking Weekly Performance over Monthly Budget
    • Lecture 9 :
    • Final Touches
    • Lecture 10 :
    • Section Recap
    • Lecture 11 :
    • Data Visualisation Quiz
    • Data Visualisation Quiz
  • Section 11 : Creating Dynamic and Reliable Data Connections 6 Lectures

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Status for Data Dump
    • Lecture 3 :
    • Dynamic Budget Connection with IMPORTRANGE & TRANSPOSE
    • Lecture 4 :
    • Dynamic Budget Connection with QUERY
    • Lecture 5 :
    • Final Touches
    • Lecture 6 :
    • Data Connections Quiz
    • Data Connections Quiz
  • Section 12 : Wrapping Up the Project 7 Lectures

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Adding Instructions
    • Lecture 3 :
    • Reviewing Links in Cover tab
    • Lecture 4 :
    • Final Touches on Whole File
    • Lecture 5 :
    • Protecting the Sheets
    • Lecture 6 :
    • Recap of Course Project
    • Lecture 7 :
    • Project Wrap-Up Quiz
    • Project Wrap-Up Quiz
  • Section 13 : Further Development Tips and Tricks 8 Lectures 00:02:13

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Automating Data Dump through a Script
    • Lecture 3 :
    • Creating Multi-Level Reporting System
    • Lecture 4 :
    • Optimise Spreadsheet Performance
    • Lecture 5 :
    • Workaround for IMPORTRANGE Internal Errors
    • Lecture 6 :
    • Manage Reporting Files through Scripts
    • Lecture 7 :
    • Section Recap
    • Lecture 8 :
    • Quiz
    • Quiz
  • Section 14 : Conclusion 2 Lectures

    • Lecture 1 :
    • Conclusion
    • Lecture 2 :
    • Bonus Lecture
  • How do i access the course after purchase?

    It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certificate for the courses?

    Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
  • For how long can i access my course on the platform?

    You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
  • Is there any free trial?

    Currently, we do not offer any free trial.
  • Can i cancel anytime?

    Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

184947 Course Views

1 Courses

My name is Mariel Aim and I am so excited that you're reading this! Professionally, I work for the European fastest growing technology firm Bolt as the Head of Business Analytics where I'm responsible for the whole business analytics and financial planning domain of a business vertical with over €4B 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!
View More...
  • Unmatched Variety and Value!
    Learnfly's monthly subscription offers unlimited access to a vast range of courses. Affordable pricing, compared to competitors, makes it the ultimate choice for continuous learning.
    Jessica M.

    4.7

    JM
  • Top-Notch Quality, Affordable Rates!
    High-quality courses with certified instructors make Learnfly stand out. The affordable pricing is a game-changer for those seeking premium education.
    Alex P.

    4.5

    AP
  • Certified Excellence Every Time!
    Learnfly's courses, taught by certified instructors, ensure top-notch learning experiences. The course completion certificates add significant value to one's skill set.
    Sarah R.

    4.3

    SR
  • Round-the-Clock Support!
    Learnfly goes the extra mile with 24/7 course support. Their dedication to helping students succeed is commendable.
    Ryan K.

    4.1

    RK
  • Learn Anywhere, Anytime!
    Whether on mobile, PC, or tablet, Learnfly's platform offers flexibility. Learning on the go has never been easier.
    Emily S.

    4.7

    ES
  • Job-Ready Skills!
    Learnfly's job-oriented courses equip learners with practical skills for the workplace. An investment in career growth!
    Jake M.

    4.2

    JM
  • Budget-Friendly Brilliance!
    Learnfly's pricing is a steal for the quality and variety of courses offered. Quality education without breaking the bank.
    Olivia T.

    4.5

    OT
  • Instructor Excellence Unleashed!
    Learn from the best with Learnfly's certified instructors. The platform ensures that knowledge is imparted by industry experts.
    Daniel L.

    4.0

    DL
  • Achievement Unlocked!
    Learnfly not only offers courses but also recognizes your efforts with course completion certificates. A sense of accomplishment with every course finished.
    Maya H.

    4.6

    MH
  • Learning Revolution!
    Learnfly's platform is a revolution in education. Access to unlimited courses at affordable rates is a game-changer.
    Ethan W.

    4.7

    EW
  • google-sites-getting-started-guide-to-quick-websites

    Google Sites - Getting started Guid...

    By : Laurence Svekis

    Lectures 11 Beginner 0:56:45
  • google-analytics-basics-learn-on-live-ecommerce-data

    Google Analytics Basics - Learn on ...

    By : Atanu Ghosh

    Lectures 12 Beginner 0:34:44
  • complete-google-classroom-course-teaching-google-classroom

    Complete Google Classroom Course: T...

    By : Jan Ekhteyari

    Lectures 81 All Level 4:18:15
  • master-in-google-slide-the-complete-google-slides-masterclass

    Master in Google Slide | The Comple...

    By : Jan Ekhteyari

    Lectures 69 All Level 2:36:25
  • the-complete-google-docs-course-google-docs-tricks-tips

    The Complete Google Docs Course - G...

    By : Jan Ekhteyari

    Lectures 70 Beginner 1:46:36
  • complete-gmail-productivity-course-more-productive-email

    Complete Gmail Productivity Course ...

    By : Jan Ekhteyari

    Lectures 56 All Level 3:6:42

Students learning on Learnfly works with Fortune 500 companies around the globe.

Sign Up & Start Learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password
Enter your email address and we'll send you a link to reset your password.