Founding price: lifetime access for $129. Save $120 until November 30.Lifetime $129. Save $120.Join now

The Sheets Bootcamp course

Learn Google Sheets by solving real problems, not watching endless tutorials

Practice in a sheet that checks your work. 70 lessons, 5 real projects, a certificate.

Get started for free

Learn the formulas you'll actually use. Unit 1 is free. No card needed.

or

By continuing, you confirm you're 18 or older, agree to the Terms and Privacy Policy, and agree to get Sheets tips and offers by email. Unsubscribe anytime.

Already have an account? Sign in

You're signed in

Pick up where you left off.

Continue learning

Full access from $8.25/mo, or $129 once for Founding Lifetime. Founding offer ends November 30. See plans

Try one real lesson step first

Try it yourself

In D2, multiply the price (B2) by the quantity (C2).

A
B
C
D
E
F
G
H
I
J
1
2
3
4
5
6
7
8
Item
Price
Qty
Total
Notebook
$4.50
3
Pens
$2.25
4
Folder
$1.75
6
Stapler
$8.00
1
Tape
$3.25
5
D2

What you get

  • 70 lessons

    The Essentials course

    From your first formula to QUERY: the Google Sheets skills you'll actually use, one short lesson at a time.

  • 5 projects

    Real things you build

    A budget, a sales dashboard, a mini-CRM. Each one uses what the units before it taught.

  • 559 exercises

    Every answer checked

    Each one is a real formula in a real grid. Press Check to know right away. Miss, and a hint shows you where to look.

  • Endless practice

    Keep your skills sharp

    Fresh numbers every time for 30 functions, plus a daily challenge and a certificate you can share.

How a lesson works

Every lesson is a few short steps on a real sheet. Each step works the same way, so you always know what comes next.

  1. Watch a short video

    Each lesson opens with a short video that shows one idea on a real sheet, step by step.

  2. Type the formula

    In a grid that works like Google Sheets, right in your browser. Nothing to install.

  3. Get it checked

    Press Check and know right away. Miss, and you get a hint and another try.

Start here: the foundation

The Essentials course

70 lessons and 5 projects, from your first formula to QUERY, plus an optional unit on getting around the sheet. Every other course builds on it.

More courses on the way, all included in full access

Launching December 15

Financial Functions

Loans, investments, depreciation and small business models.

Coming soon

Advanced Formulas

LET, LAMBDA, whole-table formulas and lookups with several criteria.

Coming soon

Clean & Combine Data

Fix messy exports, then stack and merge tables into one.

Coming soon

Marketing & Ads Reporting

Campaign reports, ROAS, clean UTMs and a weekly ads dashboard.

What's in Essentials

Every lesson, in order. Open a unit to see what each lesson lets you do.

Unit 1: First Formulas 6 lessons Free
  1. 1.1 Your first formula You'll write formulas that add, subtract, multiply and divide, like line totals and price with tax.
  2. 1.2 SUM, AVERAGE, MIN, MAX You'll total a column of sales and find the average, biggest and smallest sale in seconds.
  3. 1.3 Fill down: relative references You'll write one formula and fill it down a whole column.
  4. 1.4 Lock it with $ You'll lock a cell with $ so commission and percent-of-total formulas fill down correctly.
  5. 1.5 Count what's there You'll count the numbers, filled cells and blanks in a list with COUNT, COUNTA and COUNTBLANK.
  6. 1.6 Round money right Optional You'll round prices and averages to the cent so your totals match what the sheet shows.
  7. P0 Project: My first tracker You'll build your own budget, expense or habit tracker with totals, percentages and an over-limit flag.
Unit 2: Work the Sheet 7 lessons Optional extra
  1. 2.1 Move like a pro You'll jump, select and autofill across a sheet with keyboard shortcuts instead of scrolling.
  2. 2.2 Numbers that read right You'll format numbers as currency, percents and readable dates so a sheet reads at a glance.
  3. 2.3 Freeze and sort You'll freeze the header row and sort a list by one or two columns without scrambling rows.
  4. 2.4 Filter and filter views You'll filter a list down to the rows you need and save a filter view for later.
  5. 2.5 Layout that lasts You'll paste values, find and replace, wrap text and hide columns to keep a sheet tidy.
  6. 2.6 Named ranges and protection You'll name a range so formulas read like =SUM(Revenue), and protect cells from accidental edits.
  7. 2.7 Share, comment, version history You'll share a sheet with the right access, leave comments and restore an earlier version.
Unit 3: Logic 7 lessons
  1. 3.1 Compare: TRUE and FALSE You'll write TRUE or FALSE tests, like whether a score is 70 or more, and compare text.
  2. 3.2 IF You'll use IF to label rows Pass or Fail and add a bonus when a target is hit.
  3. 3.3 AND, OR, NOT You'll combine conditions with AND, OR and NOT to decide who qualifies for a shift or bonus.
  4. 3.4 When formulas break: errors, IFERROR, IFNA You'll read common formula errors and replace them with a clean fallback using IFERROR and IFNA.
  5. 3.5 Many branches with IFS Optional You'll sort scores and orders into tiers like grade bands or shipping fees with one IFS formula.
  6. 3.6 Checkboxes drive formulas Optional You'll turn checked checkboxes into Done or Open labels and flag open high-priority tasks.
  7. 3.7 Nested IF and SWITCH Optional You'll read and write nested IF formulas and map job roles to pay rates with SWITCH.
Unit 4: Conditional Math 6 lessons
  1. 4.1 COUNTIF You'll count how many sales match a store, a word or a number threshold with COUNTIF.
  2. 4.2 SUMIF and AVERAGEIF You'll total and average sales for one store or category with SUMIF and AVERAGEIF.
  3. 4.3 Many conditions: COUNTIFS, SUMIFS, AVERAGEIFS You'll count and total rows that meet several conditions at once, like one store's June revenue.
  4. 4.4 Criteria from cells and wildcards Optional You'll pull criteria from a cell and match partial text like "Supply" with wildcards.
  5. 4.5 MINIFS and MAXIFS Optional You'll find the biggest, smallest or earliest value for one store or customer with MAXIFS and MINIFS.
  6. 4.6 Data that formulas can use Optional You'll lay out data so formulas count it right, with no subtotal rows or merged cells inside.
  7. P1 Project: Budget Tracker You'll build June's budget report with spend by category, variance, over-budget flags and a savings rate.
Unit 5: Lookups 10 lessons
  1. 5.1 VLOOKUP exact match You'll look up a product's price from its ID with VLOOKUP and fill it down a whole list.
  2. 5.2 Reach into another tab You'll pull values, totals and lookups from another tab in the same file.
  3. 5.3 XLOOKUP You'll look up any column, even to the left, and show a message when an ID is missing.
  4. 5.4 Fixing #N/A and other lookup breaks You'll fix lookups that return #N/A or wrong answers because of stray spaces, text numbers or shifted ranges.
  5. 5.5 Approximate match: tiers and brackets Optional You'll look up commission rates, letter grades and tax brackets from a sorted tier table.
  6. 5.6 XLOOKUP match and search modes Optional You'll find the closest tier, match partial text and pull a customer's latest order with XLOOKUP.
  7. 5.7 INDEX and MATCH Optional You'll look up values in any direction with INDEX and MATCH, the way many older sheets do.
  8. 5.8 Two-way lookups Optional You'll pull a value from a grid by row and column, like who leads Riverside on Thursday.
  9. 5.9 Lookups that work with everything else Optional You'll combine lookups with IF and SUMIF to build reorder flags and budget-left checks.
  10. 5.10 IMPORTRANGE: data from another file Optional You'll pull data from another Google Sheets file with IMPORTRANGE and look values up in it.
Unit 6: Text 6 lessons
  1. 6.1 Join text You'll join first and last names and build full addresses that skip blank parts.
  2. 6.2 Clean text You'll clean messy names and emails by trimming spaces, fixing capitals and replacing typos.
  3. 6.3 SPLIT and spills You'll split emails, names and addresses into parts and grab just the piece you need.
  4. 6.4 Numbers stored as text You'll find numbers stored as text and convert them so SUM counts them again.
  5. 6.5 Cut text by position: LEN, FIND, LEFT, RIGHT, MID Optional You'll pull area codes, first names and email usernames out of text by position.
  6. 6.6 Patterns with REGEX Optional You'll check codes against a pattern and pull or strip digits from text with REGEX functions.
Unit 7: Dates 7 lessons
  1. 7.1 How dates work You'll build real dates with DATE, show today's date and see how Sheets stores dates as numbers.
  2. 7.2 Take a date apart You'll pull the month, year and weekday from a date and turn it into labels like "March 2026".
  3. 7.3 Date math You'll count days between dates, add days to a date and work out tenure in years and months.
  4. 7.4 Months and month-ends: EDATE, EOMONTH Optional You'll move dates by whole months and find month-end dates for invoices and reorders.
  5. 7.5 Workdays Optional You'll count working days between dates and set due dates that skip weekends and holidays.
  6. 7.6 Text that should be dates Optional You'll spot dates stored as text and safely convert them into real dates.
  7. 7.7 Totals by date Optional You'll total and count sales by month or date range and compare one month to the last.
Unit 8: Clean Data 4 lessons
  1. 8.1 Dropdowns You'll add dropdown lists that only accept valid entries, like a status or a store location.
  2. 8.2 Find and remove duplicates You'll flag duplicate entries, count distinct values and remove duplicates from a list.
  3. 8.3 Checkboxes, date and custom rules Optional You'll add checkboxes and rules that only allow valid dates or positive whole numbers.
  4. 8.4 Dependent dropdowns Optional You'll build a second dropdown whose choices change based on what was picked in the first.
  5. P2 Project: Supplier Intake You'll clean a broken supplier file, price each order by SKU and add a delivery status dropdown.
Unit 9: Visualize 6 lessons
  1. 9.1 Conditional formatting basics You'll color cells automatically, like high revenue in green and overdue dates in red.
  2. 9.2 Column and bar charts You'll build column and bar charts that compare a few things, and flip a chart with Switch rows / columns.
  3. 9.3 Line and pie charts You'll chart change over time with a line, and shares of a whole with a pie.
  4. 9.4 Custom-formula rules Optional You'll highlight whole rows and duplicate entries with your own formula-based formatting rules.
  5. 9.5 Scatter charts and titles Optional You'll pick the right chart for a question, plot two numbers with a scatter chart, and title any chart.
  6. 9.6 SPARKLINE options Optional You'll add bar, win/loss and colored sparklines that compare rows fairly inside single cells.
Unit 10: Arrays & FILTER 4 lessons
  1. 10.1 FILTER You'll pull every row that matches one or more conditions into a live list with FILTER.
  2. 10.2 SORT and UNIQUE You'll sort a list with a formula and list distinct values with a total beside each.
  3. 10.3 ARRAYFORMULA Optional You'll fill an entire column with one formula that labels, cleans or calculates every row.
  4. 10.4 Combine the power tools Optional You'll look up with two criteria, return several columns at once and list the top orders.
Unit 11: Pivot Tables 9 lessons
  1. 11.1 Your first pivot table: Rows and Values You'll turn a sales table into a pivot table that totals revenue for each store, with no formulas.
  2. 11.2 Rows and Columns: a two-way grid You'll build a grid with stores down the side and categories across the top, and check one cell by formula.
  3. 11.3 Summarize by: count, average, max You'll count orders, average a sale and find the biggest one per store by changing one pivot setting.
  4. 11.4 Group dates by month You'll total a year of daily sales by month in a pivot, and keep two years apart.
  5. 11.5 Filter and sort a pivot You'll show only one category in a pivot and sort it to read the top five.
  6. 11.6 Calculated fields You'll add a profit column and an average order column to a pivot with a formula on field names.
  7. 11.7 When the data grows You'll make a pivot pick up new rows of data, so next week's sales show up without rebuilding it.
  8. 11.8 Show values as % of total Optional You'll show each store's share of total revenue as a percent in a pivot.
  9. 11.9 Chart a pivot Optional You'll turn a monthly pivot into a line chart and read the peak month.
  10. P3 Project: Sales Dashboard You'll build a one-tab sales dashboard with revenue tiles, a trend sparkline, a pivot and a pie chart.
Unit 12: QUERY 5 lessons
  1. 12.1 SELECT and WHERE You'll pull chosen columns and matching rows from a table with a single QUERY formula.
  2. 12.2 ORDER BY and LIMIT Optional You'll sort QUERY results and return just the top sales or the earliest orders.
  3. 12.3 GROUP BY, aggregates and LABEL Optional You'll total, count and average sales by store or category in one QUERY, with clean headers.
  4. 12.4 More QUERY tricks Optional You'll do math on grouped QUERY results and drive a QUERY's filter from a cell.
  5. 12.5 PIVOT, dates and IMPORTRANGE in QUERY Optional You'll build summary grids, filter by date and query data from another file with QUERY.
  6. P4 Project: Mini-CRM You'll build a customer tracker with clean names, lead status, follow-up lists and revenue per customer.

The projects

Lessons teach one idea at a time. Projects put them together into something you'd actually use.

  • P0 My first tracker

    You'll build your own budget, expense or habit tracker with totals, percentages and an over-limit flag.

  • P1 Budget Tracker

    You'll build June's budget report with spend by category, variance, over-budget flags and a savings rate.

  • P2 Supplier Intake

    You'll clean a broken supplier file, price each order by SKU and add a delivery status dropdown.

  • P3 Sales Dashboard

    You'll build a one-tab sales dashboard with revenue tiles, a trend sparkline, a pivot and a pie chart.

  • P4 Mini-CRM

    You'll build a customer tracker with clean names, lead status, follow-up lists and revenue per customer.

What you'll be able to do

Look things up

VLOOKUP, XLOOKUP and INDEX MATCH, and when to use which.

Make decisions in a formula

IF, IFS, AND, OR and the counting and summing functions that take conditions.

Clean messy data

Trim, split, join and fix text and dates someone else typed.

Summarize and report

QUERY, FILTER, pivot tables and charts people can read.

Full access

Every lesson, project and course. Unit 1 stays free either way.

Founding offer ends November 30. Founding members keep a badge on their profile.

Choose a plan
Get full access

Not sure yet? Try the course for free. Unit 1 free. No card needed.

Secure checkout with Stripe.

Questions

How much does it cost?
Unit 1 is free. Full access is $19 a month, $99 a year ($8.25 a month) or $129 once for Founding Lifetime. The founding offer ends November 30, then lifetime access is $249. Every course comes with it. There are no separate courses to buy.
What's free?
All 6 lessons in Unit 1, free forever with an account. No card needed.
Is there a refund?
Yes. Every plan has a 30-day money-back guarantee. Email us within 30 days of your first payment for a full refund.
Can I cancel?
Yes. Monthly and yearly plans cancel any time from Membership, and you keep access to the end of the period you paid for.
Yearly or Founding Lifetime?
Yearly is $99 a year and renews each year. Founding Lifetime is one payment of $129 that never renews, sold until November 30. After that, lifetime access costs $249.
What do I need to start?
A browser. The lessons run in a grid that works like Google Sheets, so there is nothing to install.
Is this a video course?
No. Every lesson has a short video, but you learn by typing real formulas into a grid that checks them.
Does this help with Excel?
Yes. SUM, IF, VLOOKUP and XLOOKUP work the same way in Excel. QUERY is the one big function that only Google Sheets has.
I bought the Google Sheet version of the Bootcamp. Do I pay again?
No. You get lifetime access to the app free. Sign in with the email you bought it with.

Learn the skills you'll actually use

Unit 1 is free: 6 short lessons that check every formula you type. No card needed.

Try the course for free

Full access is $19 a month or $99 a year. Until November 30, Founding Lifetime is $129 once. Save $120. See plans

Full access is $19 a month or $99 a year. Until November 30, Founding Lifetime is $129 once. Save $120.

Get full access

Unit 1 free. No card needed.

Try the course for free
Continue learning

Your privacy choices

We don't use advertising cookies right now.

Cookie policy · Privacy policy