learning.marielaim.com Open in urlscan Pro
2606:4700::6811:5236  Public Scan

Form analysis
2 forms found in the DOM

GET /purchase

<form class="block__pricing flex-grow" action="/purchase" method="get">
  <input type="hidden" name="course_id" value="1490567" id="course_id">
  <div class="block__pricing__heading empty_state__heading-text b-162845249-heading_text_color rich-text">
    <h4><strong>Choose a Pricing Option</strong></h4>
  </div>
  <div class="block__pricing__plans">
    <label for="5193802">
      <section class="block__pricing__plan" data-id="5193802">
        <div class="block__pricing__plan__radio-wrapper">
          <input checked="" class="radio block__pricing__plan__radio" name="product_id" type="radio" id="5193802" value="5193802">
          <div class="block__pricing__plan__radio__custom-indicator"></div>
        </div>
        <div class="block__pricing__plan__text">
          <div class="block__pricing__plan__price" data-include-vat-price="5193802"> €99 </div>
          <h3 class="block__pricing__plan__name">Lifetime access</h3>
          <h4 class="block__pricing__plan__subtitle"> Get support on Google Sheets forever - via lifetime access </h4>
          <span htmlfor="5193802" class="hidden bnpl__installments__text product_5193802">or pay in installments:</span>
          <div htmlfor="5193802" id="payment-method-messaging-element" class="product_5193802 hidden"></div>
        </div>
      </section>
    </label>
    <label for="5356354">
      <section class="block__pricing__plan" data-id="5356354">
        <div class="block__pricing__plan__radio-wrapper">
          <input class="radio block__pricing__plan__radio" name="product_id" type="radio" id="5356354" value="5356354">
          <div class="block__pricing__plan__radio__custom-indicator"></div>
        </div>
        <div class="block__pricing__plan__text">
          <div class="block__pricing__plan__price" data-include-vat-price="5356354"> 3 payments of €33/month </div>
          <h3 class="block__pricing__plan__name">Flexible Payment</h3>
          <h4 class="block__pricing__plan__subtitle"> In case you prefer scheduled payments. Same perks, different payment timing. </h4>
          <span htmlfor="5356354" class="hidden bnpl__installments__text product_5356354">or pay in installments:</span>
          <div htmlfor="5356354" id="payment-method-messaging-element" class="product_5356354 hidden"></div>
          <div class="block__pricing__plan__description__container" data-collapsed="true">
            <button class="block__pricing__plan__description__show-button" type="button">
              <span class="block__pricing__plan__description__show-button__text" data-more="More" data-less="Less">More</span>
              <span class="block__pricing__plan__description__show-button__icon"></span>
            </button>
            <div class="block__pricing__plan__description hidden">
              <p><br></p>
            </div>
          </div>
        </div>
      </section>
    </label>
  </div>
  <div class="block__pricing__button-wrapper">
    <button class="block__pricing__button b-162845249-button_border_radius base-button" type="submit">Enroll now</button>
  </div>
</form>

<form onsubmit="return false" data-block-id="162845251" data-source="Email Leads" data-ss-school-id="1067877">
  <h4 class="b-162845251-heading_text_color"><strong>Let’s keep in touch</strong></h4>
  <p>Subscribe to the mailing list and receive the latest updates</p>
  <fieldset>
    <div>
      <label for="email">Email Address</label>
      <input type="email" name="email" class="block__email_leads__input" required="">
    </div>
    <div class="block__email_leads__checkbox_wrapper">
      <input type="checkbox" name="consent" class="block__email_leads__checkbox" required="">
      <label for="consent"> By clicking this checkbox, you consent to receiving emails from this school or course </label>
    </div>
  </fieldset>
  <button class="base-button" type="submit">Subscribe</button>
  <p class="disclaimer_text">We respect your privacy.</p>
  <div class="block__email_leads__error"></div>
</form>

Text Content

 * Login
 * Sign Up


MASTER REPORTING AUTOMATION WITH GOOGLE SHEETS


Bring your Google Sheets skills to the next level
and unlock the career you've always wanted


ENROLL NOW

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
Available in days
days after you enroll
 * Introduction (5:01) Preview
 * Why Google Sheets, not Excel? (3:00) Preview
 * Quick Example: How to Efficiently Automate Reporting (1:52) Preview
 * Overview of Course Projects (2:25) Preview

  Learn and Practice the Key Formulas
Available in days
days after you enroll
 * Introduction (1:10) Start
 * Key Formula Combination - INDEX & MATCH (7:03) Start
 * Determining Year with TEXT (2:07) Start
 * Smart use of IF's - Dynamic SUMIF and AVERAGEIF (7:51) Start
 * Use of COUNTIF(S) (3:38) Start
 * Identify ROW & COLUMN Numbers (2:14) Start
 * RANK the Data (1:52) Start
 * Avoid Errors with IFERROR (2:40) Start
 * Improve Calculation Accuracy with AVERAGE.WEIGHTED (2:20) Start
 * Key Formula Quiz Start

  Learn and Practice the Key Formulas: Advanced Section
Available in days
days after you enroll
 * Introduction (0:39) Start
 * Pulling Data with INDIRECT & ADDRESS (2:41) Start
 * Use OFFSET for Dynamic Calculations (4:34) Start
 * IMPORTRANGE with INDEX & MATCH (5:07) Start
 * Advanced Formula: QUERY (2:58) Start
 * Advanced Formula: QUERY 2 (3:44) Start
 * Section Recap (1:08) Start
 * Key Formula 2 Quiz Start

  Putting Together the Project
Available in days
days after you enroll
 * Introduction (2:44) Start
 * Mapping Down the Metrics (11:02) Preview
 * Defining the Week Periods and Week References (3:59) Start
 * Connecting the Formulas with INDEX & MATCH (3:28) Start
 * Setting Up Budget Connections and Calculations (8:03) Start
 * Formatting of Week Numbers (1:53) Start
 * Visual Formatting (8:48) Start
 * Project Mapping Quiz Start

  Adding the Forecasts
Available in days
days after you enroll
 * Introduction (0:42) Start
 * Defining Sheet Structure (5:01) Start
 * Setting Up Forecasting Formulas (8:57) Start
 * Advanced: Connecting Stable Metrics to Dataset (11:48) Preview
 * Linking Targets with Actuals (6:51) Start
 * Defining Current Week through TODAY Formula (3:09) Start
 * Target Conversion from Weekly to Monthly (5:28) Start
 * Comparison between Targets and Budgets (6:04) Start
 * Notification for Reconciliation with Budgets (8:40) Start
 * Sections Recap (1:19) Start
 * Forecasting Quiz Start

  Building the Comparison Between Actuals and Forecasts
Available in days
days after you enroll
 * Introduction (0:40) Start
 * Defining Sheet Structure (4:11) Start
 * Connecting the Formulas (2:48) Start
 * Not Showing Data for Unpassed Weeks (2:13) Start
 * Calculating the Variances (2:19) Start
 * Conditional Formatting for Variances (3:02) Start
 * Conditional Color Notifications (7:16) Start
 * Final Touches (1:25) Start
 * Comparison Building Quiz Start

  Designing the Landing Page
Available in days
days after you enroll
 * Introduction (0:27) Start
 * What to Include in the Cover tab? (7:00) Start
 * Table of Contents (3:05) Start
 * Linking Key Information (2:48) Start
 * Use Your Brand Colours (5:15) Preview
 * Section Recap (1:32) Start
 * Landing Page Quiz Start

  Reconciling Weekly Actuals with Monthly Budgets
Available in days
days after you enroll
 * Introduction (1:03) Start
 * Defining Sheet Structure (5:57) Start
 * Connecting the Data to the Tab (5:16) Start
 * Color Coding for Weekly Trends (2:53) Start
 * Color Coding for Monthly Budgets (10:00) Start
 * Final Touches (1:39) Start
 * Actuals vs Budget Quiz Start

  Setting Up Competitor and Market Size Tracking
Available in days
days after you enroll
 * Introduction (0:56) Start
 * Defining Sheet Structure (1:40) Start
 * Creating the Framework for Competitor Tracking (3:08) Start
 * Adding Formulas to Framework (5:35) Start
 * Estimating Competitor and Market Size (10:27) Start
 * Summary of Key Metrics (8:34) Start
 * Final Touches (7:10) Start
 * Connection with Other Tabs (8:23) Start
 * Sections Recap (1:36) Start
 * Market Sizing Quiz Start

  Professional and Effective Data Visualisation
Available in days
days after you enroll
 * Introduction (1:41) Start
 * Intro to the First Graph (1:10) Start
 * Data Visualisation Principles (2:11) Start
 * Graph I: Key Actuals with Targets (17:55) Start
 * Graph II: Monthly Actuals with Budgeted Forecasts (12:16) Start
 * Dynamic Table: Data Layout for Competitor Tracking (10:57) Start
 * Dynamic Table: Ranking for Competitor Tracking (6:03) Start
 * Graph III: Tracking Weekly Performance over Monthly Budget (10:31) Start
 * Final Touches (0:47) Start
 * Section Recap (1:51) Start
 * Data Visualisation Quiz Start

  Creating Dynamic and Reliable Data Connections
Available in days
days after you enroll
 * Introduction (0:41) Start
 * Status for Data Dump (6:08) Start
 * Dynamic Budget Connection with IMPORTRANGE & TRANSPOSE (4:15) Start
 * Dynamic Budget Connection with QUERY (4:13) Start
 * Final Touches (3:45) Start
 * Data Connections Quiz Start

  Wrapping Up the Project
Available in days
days after you enroll
 * Introduction (0:42) Start
 * Adding Instructions (1:40) Start
 * Reviewing Links in Cover tab (1:09) Start
 * Final Touches on Whole File (3:17) Start
 * Protecting the Sheets (3:29) Start
 * Recap of Course Project (1:52) Start
 * Project Wrap-Up Quiz Start

  Further Development Tips and Tricks
Available in days
days after you enroll
 * Introduction (0:49) Start
 * Automating Data Dump through a Script (2:37) Start
 * Creating Multi-Level Reporting System (3:15) Start
 * Optimise Spreadsheet Performance (1:40) Start
 * Workaround for IMPORTRANGE Internal Errors (2:13) Start
 * Manage Reporting Files through Scripts (2:07) Preview
 * Section Recap (1:07) Start
 * Tips and Tricks Quiz Start

  Conclusion
Available in days
days after you enroll
 * Conclusion (2:16) Start
 * Bonus Lecture (3:15) Start

Show All Lectures

CHOOSE A PRICING OPTION

€99


LIFETIME ACCESS

GET SUPPORT ON GOOGLE SHEETS FOREVER - VIA LIFETIME ACCESS

or pay in installments:

3 payments of €33/month


FLEXIBLE PAYMENT

IN CASE YOU PREFER SCHEDULED PAYMENTS. SAME PERKS, DIFFERENT PAYMENT TIMING.

or pay in installments:

More




Enroll now

FEATURED PRODUCTS



Interested in more? Learn skills via online course, get mentoring for career
growth or consultation for projects. Your choice!



MASTER REPORTING AUTOMATION WITH GOOGLE SHEETS



LEARN HOW TO TO BUILD A COMPLETELY AUTOMATED REPORTING TOOL AND SOLVE ANY
BUSINESS MODELING TASK YOU MIGHT EVER EXPERIENCE

Mariel Aim

% COMPLETE

€99


GET 1:1 MENTORING TO BOOST YOUR CAREER OR PROJECT CONSULTING!



Mariel Aim

€120

LET’S KEEP IN TOUCH

Subscribe to the mailing list and receive the latest updates

Email Address
By clicking this checkbox, you consent to receiving emails from this school or
course
Subscribe

We respect your privacy.


Check your inbox to confirm your subscription
 * © Modern Mastery 2024

 * Terms of Use
 * Privacy Policy
 * Teach Online with

Completed Incomplete Incomplete disabled