Pro Sheets Accelerator

Build expert-level Google Sheets skills for data analysis and automation

5-week, live online course

What is Pro Sheets Accelerator?

Pro Sheets Accelerator is a 5-week, live online training program that teaches you how to turn your spreadsheet skills into a superpower.

In Pro Sheets Accelerator, you will learn a step-by-step framework that will turn your business data into actionable insights, which will lead to growth opportunities for your business and for you. 

You’ll learn how to create automations that save you time by doing the boring tasks for you, freeing you up to focus on more meaningful work.

You’ll leave with both a deep understanding of Google Sheets and a broad overview of the business analysis landscape.

If you feel like this, we can help

  • You feel like you start from scratch with every dataset and you know a framework would make your life easier
  • Data is abundant but you can’t figure out what’s important or what story it’s telling.
  • You have so many tedious tasks to do but don’t know how to automate them.
  • Macros and code are intimidating
  • You’ve tried to learn on your own but it’s time-consuming and frustrating. It’s hard to find good resources and even when you do, you have no-one to ask when you get stuck
  • You’ve looked but can’t find the answers to your specific questions...if only there was a Google Sheets expert you could talk to


Pro Sheets Accelerator is designed to help you overcome these blockers.


Join Pro Sheets Accelerator if you want to…

Become an
indispensable team member

Become the go-to expert on the team for data and spreadsheet problems, and dramatically improve your worth to your boss and clients.

Develop a framework and skill set to approach any data problem

We’ll teach you a systematic approach to solve problems with data, learn how to collect the correct data, clean it, analyze it and report it.

Build beautiful dashboard reports that wow your clients and colleagues

You’ll learn by doing! Master best practices for dashboard and data visualization, in Google Sheets and Data Studio.

Learn Apps Script to automatically connect to third-party sites and bring data into your Google Sheets

You don’t need to be an Apps Script expert but you do need to know the right steps. We’ll teach you enough Apps Script to connect to Application Programming Interfaces (APIs), so you can import data directly into your Google Sheets.

Automate your Sheets workflows so that you can save time and spend it on higher value tasks or claim it back as personal time

We’ll teach you best practices so you maximize your efficiency working with data in Google Sheets.

Explore
your curiosity

You’re not the only one interested in spreadsheets! During Pro Sheets Accelerator you will dive deep on concepts and techniques in the company of other experts and spreadsheet aficionados.

5-weeks | Live | Online


Who is Pro Sheets Accelerator course for?

You already use Google Sheets regularly. 

You’re a regular user of Google Sheets and already know your way around the platform. You’re familiar with the basic functionality and common intermediate functions like VLOOKUP.

In 5 weeks, you’ll go from an intermediate to an advanced level Google Sheets user.

You’ll build a personal data toolbox and know the best approach to solve problems. You’ll leave with enough coding skills to build useful tools that save you time at work.


Business Analysts

You spend all day wrangling data in spreadsheets and want to be as efficient and productive as possible.

And yet, as a data practitioner in the workforce, you’re often left to your own devices when it comes to learning data analysis. It’s time to change that.

These skills are more important than ever before. Data that is increasing in size and complexity every day. Data literacy is a core competency for ANY job in the 21st century.

In 5 weeks, you’ll build your own framework for approaching data analysis problems, so that you can consistently deliver results that drive the business forward and elevate your status within your team.


Small Business Owners & Entrepreneurs

Data is the key to unlocking opportunities in your business.

Too often that data is left gathering dust in Google Sheets, in forgotten corners of your Google Drive folders. Or, worse, locked away in vendors' platforms and never sees the light of day.

In just 5 weeks, you’ll feel confident and no longer fly blind. You’ll have the toolset to unlock the insights hidden in your data. 

And you’ll know how to automate processes that save you time that you can spend scaling your business.


Freelancers

Freelancing is all about leveraging your time to the fullest. You can’t duplicate yourself so you have to use every hour to its fullest extent.

After 5 weeks, you’ll have the confidence to go after projects because you’ll have a deep reservoir of spreadsheet skills. 

You’ll be an expert at efficient spreadsheet practices which save you time so you can move quickly on projects. 

You’ll take away a broad overview of the wider spreadsheet ecosystem so you can provide extra value to your clients. In addition, you’ll learn valuable automation techniques to streamline your processes.

Learn with peers & benefit from rapid feedback loops



Pro Sheets Accelerator Overview & B.A.R.

Pro Sheets Accelerator is a 5-week, 10 session, live online course during which time you will develop your Google Sheets superpowers. It’s your shortcut to the skills and experience that took me years to acquire.

We use our methodology B.A.R. – Build, Automate, Reuse – throughout this course.

Build (weeks 1 - 3)

Build your data analysis infrastructure

  • Your data framework (best practices to approach any data problem)
  • Data cleaning toolkit
  • Data analysis toolkit
  • Reporting (Dataviz best practices, advanced charts, dashboards)

Automate (week 4)

Automate your infrastructure:

  • Ingest data automatically via APIs, using Apps Script or no-code automation tools
  • Automate repetitive tasks using Apps Script

Reuse (week 5)

Reuse what you’ve learnt in the Capstone project e.g.:

  • Solve a specific problem from your work
  • End-to-end data pipeline in Google Sheets
  • Interactive dashboard report
  • Specific API connector
  • Google Workspace workflow automation

Pro Sheets Accelerator Modules

Week 0

Welcome Week

Meet me and your fellow students during an informal welcome session. You’ll learn all about the program and what’s coming up.

Week 1

Data Framework & Data Cleaning

  • Introduction to the Data Analysis Pipeline
  • Data cleaning deep dive, including advanced formulas
  • Data Cleaning exercise

Week 2

Data Analysis

  • Data best practices
  • Data analysis deep dive, including:
    • Advanced formulas like QUERY, FILTER, INDEX, MATCH
    • Pivot tables
  • Big data / slow Sheet considerations
  • Data Analysis exercise

Week 3

Data Reporting

  • Data visualization & dashboard best practices
  • Advanced charts in Google Sheets
  • Dashboards in Google Sheets
  • Introduction to Google Data Studio
  • Dashboard exercise

Week 4

Automation

  • Introduction to automation
  • Automation with Apps Script
  • Automation with no-code tools for Google Sheets
  • Best practices for automation projects
  • Connecting to Application Programming Interfaces (APIs) with Apps Script

Week 5

Project

  • More Automation
  • Project workshops
  • Dedicated Q & A time
  • Project presentations

What you will learn during Pro Sheets Accelerator?

As a student, you will:

  • Build expert level Google Sheets skills
  • Develop a playbook for approaching data problems
  • Learn best practices for working with data in Google Sheets
  • Understand where Google Sheets fits into the wider business analytics landscape and what other tools are available
  • Learn enough Apps Script so you can build useful tools
  • Plan and build automation programs
  • Learn how to document your work so it serves as reference material for you and your team
  • Have the opportunity to solve a specific problem from your work 
  • Get feedback on specific problems during our live breakout groups
  • Have dedicated time to focus your technical skills.
  • Grow your professional network by connecting with fellow students who aree smart, motivated, data-driven folks… like you!

Course Schedule

Friday 23rd April 2021, 12 - 1.00pm

Session 1: Tuesday 27th April, 12 - 1.30pm

Session 2: Thursday 29th April, 12 - 1.30pm

Office hours: Friday 30th April, 12 - 1.30pm


Sessions 3: Tuesday 4th May, 12 - 1.30pm

Session 4: Thursday 6th May, 12 - 1.30pm

Office hours: Friday 7th May, 12 - 1.30pm

Sessions 5: Tuesday 11th May, 12 - 1.30pm

Session 6: Thursday 13th May, 12 - 1.30pm

Office hours: Friday 14th May, 12 - 1.30pm

Sessions 7: Tuesday 18th May, 12 - 1.30pm 

Session 8: Thursday 20th May, 12 - 1.30pm

Office hours: Friday 21st May, 12 - 1.30pm

Sessions 9: Tuesday 25th May, 12 - 1.30pm 

Session 10: Thursday 27th May, 12 - 1.30pm

* All times shown in Eastern Daylight Time

Pricing

What’s included:

  • 10 live training sessions
  • 4 Friday office hours, which are live, online Q&A sessions
  • Guided Capstone Project
  • Weekly supporting materials
  • Access to private cohort community & mentor sessions
  • Lifetime access to recordings of live sessions + templates

$1,495

Monthly Payment Plans Available At Checkout

Sales Tax may apply based on location


Cohort 1 starts 23 April 2021

Who is the course not for?

Pro Sheets Accelerator is NOT for you if…

  • You’re a beginner with Google Sheets. For example, you’ve not used or are just learning the VLOOKUP for the first time.
  • You use Microsoft Excel, or Tableau, or some other data stack that is not Google based. This course is focussed on Google Sheets and other relevant Google tools or partner tools.
  • You’re looking for professional level developer training. Pro Sheets Accelerator course teaches you enough coding to build useful work tools but it does not prepare you for a job as a professional developer.
  • You’re not willing to put in the time and effort to attend sessions each week and are just looking for a magic bullet. I’m afraid, like everything in life, effort is required to reap the rewards.
  • You don’t believe in the value of data and would rather trust your gut, or do things the way they’ve always been done. You’ll get the most out of this course if you enter with a growth mindset, and open yourself to new ideas and methodologies. You can apply the ones that work for you in your work.

By the end of the 5-week course…

You’ll be the go-to team expert on the team for any Google Sheets, data or automation work. You won’t merely be a valuable team member, you’ll be an invaluable team member.

You’ll impress your boss and clients with new analytical skills and data insights.

You’ll have more confidence when creating and delivering data reports and influence the direction of your team or business.

You will unlock new opportunities for business growth, though the information you extract from your datasets.

If you’re a small business owner, you’ll have a deeper understanding of the levers behind your business, based on what the data shows.

You’ll identify what you can automate and know how to do it. Automating workflows will save you time each week, so you’ll feel less stressed and have the chance to do more fun stuff with his friends and family, or work on higher value work projects.

Frequently Asked Questions

This course is designed for Google Sheets users who are already familiar with spreadsheets. It is not intended for beginners.

There are no coding prerequisites however.

If you enroll, we’ll send you resources before the course begins to help you prepare.

The nice thing about a live course with lots of feedback and peer coaching is that we can accommodate a wide range of skills and still provide huge value to you.

This is not a beginner course so you can expect to be working with formulas like QUERY, FILTER, INDEX etc. and using pivot tables frequently. In addition, we’ll spend time working with Apps Script, although it’s not a prerequisite that you have used that before.

There will be opportunities to go as far down the technical rabbit hole as you want!

Other than being familiar with Google Sheets, we don’t make any assumptions about your background.

The course is technical in nature though, so you should expect to geek out with your fellow students on formulas, data, code etc.

The course starts on Friday 23rd April 2021 with the welcome call.

The final session will be on Thursday 27th May 2021.

Pro Sheets Accelerator is a 5-week live course.

We’ll meet twice a week on Tuesday and Thursday at noon EST for a 90 minute live session, conducted via Google Meet.

In addition, we’ll have optional office hours on a Friday lunchtime as well as peer led feedback groups.

Each week, there will be supporting materials and exercises.

All the live sessions will be recorded and available to watch at a later date. However, you should plan on attending as many of the sessions live as possible to get the most from the course.

Yes! All the exercises and datasets will be available.

The two live sessions will take 3 hours per week.

In addition, you should plan on another 3+ hours each week to attend office hours or feedback groups or work through the exercises. These are all optional but you will get more out of the course if you put more time into it.

That’s exactly why I created this course!

You’ll be part of a supportive community with me and your fellow students and will have ample opportunities to ask specific questions.

Each week, we’ll host office hours where you can ask specific questions.

This course is live and completely up-to-date. If Google releases a new feature on a Monday, we can cover it in Tuesday’s lesson.

The material is relevant to you because you’ll have the chance to solve your specific problems.

You will have the ability to interact with the instructor and other students during the live sessions and even get one-on-one time with the instructor during weekly office hours. If you don’t understand a concept simply ask for clarification and get it.

We would never want you to be unhappy!

If you take the course but are unsatisfied with your purchase, contact us within 30-days of your purchase of the course and we will give you a full refund.

You will have unlimited access to the recordings of the live sessions, as well as any templates or exercise files, for as long as you like.

In order to comply with EU regulations, buyers in the EU will be charged VAT at checkout. This money is passed on to the relevant EU tax collection agency.

Yes, of course! You’ll receive an invoice after you purchase, but if you need something additional, just drop us a line.

This course is closed for enrollment.

Leverage the power of data and automation in Google Sheets



Your Instructor

Hi! I'm your instructor, Ben Collins.

I'm an experienced data analytics instructor and spreadsheet developer.

I help individuals and businesses better understand their data through analytical insights and visualizations.

Over 40,000 professionals from 1,000+ companies have enrolled in my online training courses, including employees from PwC, Netflix, Verizon, Google, the UN and other Fortune 500 companies.

My training has helped these professionals advance their careers. I’ve also guided small and large organizations as they migrate from Microsoft Excel to Google Sheets.

Since 2019, Google has recognized me as a Google Developer Expert for G Suite Technology, one of only a handful worldwide.

I have extensive experience with Google Sheets, Google Apps Script, Google Data Studio, Microsoft Excel, SQL, BigQuery and Tableau.

I previously taught data courses and workshops for the education startup General Assembly in Washington, D.C..