Pro Sheets Accelerator
Build expert-level Google Sheets skills for data analysis and automation
5-week, live online course
Join Pro Sheets Accelerator if you want to…
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.
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.
Must take if you want to work for K. Capital (I need folks who understand Sheets at this level) - Jim K.
I would describe the class as an excellent way to take your Sheets skills to a higher level with an instructor who has an expert-level base of knowledge and a gift for teaching. Attendees will be surrounded by other Sheets enthusiasts who are willing to share their knowledge and ideas freely with the group. - Jen B.
A really great way to meet and work with fellow sheet lovers. You'll come out of this course learning something new guaranteed. - Isaac D.
Maybe a little dramatic, but 'Mind Blowing'. Just seeing the possibilities was amazing. - Jim L.
It's like being at a Sheets amusement park. There's so much to see and do, and everything is so exciting! - Kristin P.
This course provides a venue to constructively challenge your current google practices via expert instruction and access to a cohort of highly skilled practitioners. - Tim L.
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:
- Automate repetitive tasks using Apps Script
- Ingest data automatically via APIs, using Apps Script or no-code automation tools
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
- Google Workspace workflow automation
Pro Sheets Accelerator Modules
Meet me and your fellow students during an informal welcome session. You’ll learn all about the program and what’s coming up.
Data Framework & Data Cleaning
- Introduction to the Data Analysis Pipeline
- Data cleaning deep dive, including advanced formulas
- Data Cleaning exercise
- 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
- Data visualization & dashboard best practices
- Advanced charts in Google Sheets
- Dashboards in Google Sheets
- Introduction to Google Data Studio
- Dashboard exercise
- 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
- More Automation
- Project workshops
- Dedicated Q & A time
- Project presentations
- 10 live training sessions
- 5 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
Monthly Payment Plans Available At Checkout
Sales Tax may apply based on location
Cohort 2 starts 1 November 2021
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.