Press Enter to see matching tutorials.
Become the "spreadsheet person" on your team in about two weeks. 193 auto-graded reps inside one Google Sheet that grades you as you type.
You have read about these formulas. This is where you finally write them. Every answer is checked the moment you press Enter, and a wrong one names the concept you missed.
No app to install, nothing to configure. You open a spreadsheet and start writing formulas from the first minute.
Founding price, one payment, lifetime access. Goes to $59 after Monday, August 31st.
Get the Bootcamp30-day money back guarantee. Reply to any email and I refund you, no questions.
Never written a formula? Start with Basic Training, the free course, instead.
You can total a column. You have used VLOOKUP, mostly by copying one that worked last time. When it breaks you google it, paste something in, and hope.
That is not a knowledge problem. It is a reps problem. You have read about these formulas plenty. You have just never had to write forty of them in a row with something checking your work.
This course is 193 of those reps, in order, with instant feedback on every one.
There is nothing wrong with the videos. They are just not where the learning happens, and everybody who has finished one and then frozen on a blank grid already knows it.
The course is the Sheet. You learn by doing, not watching.
Type a formula in the answer cell. The check fires the moment you press Enter. No submit button, no waiting, no watching someone else do it.
It reads your formula
Type the answer by hand and the check says so. You have to write the formula.
Wrong gets a reason
Not a red X. A line that names what you missed, like a range that needs locking.
Hints on demand
Every exercise has one behind a checkbox. Struggle first, peek when you choose to.
There are 37. For a lot of the formulas there is a short reference video linked right next to the exercise, inside the Sheet. If you get stuck, click it, watch me do it once, then come back and type it yourself.
The goal is 193 reps, not 193 video views.
Not "understand VLOOKUP". These are the four things you build yourself during the course, and every one of them is a job somebody at work will hand you.
Totals, a category breakdown, and a verdict cell that says whether the month came in under. You build this one in Capstone 1.
Strip the stray spaces, fix the inconsistent names, work out how late each delivery ran, price it against the catalog, and catch the purchase order somebody used twice.
KPI tiles, a store and category breakdown, a trend line, and a top 5 that reranks itself when the numbers change. Off 300 real rows, read in five seconds.
De-duped, validated so bad entries cannot get in, history you can look up, and follow-up flags that set themselves.
Three parts of three modules, each closed by its own capstone, then a final project that uses everything. 193 graded exercises in all, and every module ends with the skill working on real data.
Stop fighting the grid. Write formulas that hold up.
Move like a pro · Make numbers readable · Freeze, sort, filter · Layout that lasts
The starter five · Count what is really there · Conditional math · Many conditions and clean money · Lock it down
IF, properly · AND, OR, NOT · Many branches · When formulas break
Build a working monthly budget from a raw expense log. Totals, category breakdown, and a verdict cell that tells you if you are under.
The skills people actually get hired for. Lookups, messy text, dirty inputs.
VLOOKUP exact match · Approximate match · XLOOKUP · INDEX + MATCH · Fixing #N/A
Join text · Pull text apart · Clean text · Dates that behave · Date math
Dropdowns and validation · Checkboxes, date and custom rules · Dependent dropdowns · Kill the duplicates
A supplier delivery file lands in your inbox, messy. Clean the stray spaces and lowercase names, work out how slow each delivery was, price it all against the catalog, and catch the purchase order somebody used twice.
Turn a pile of rows into something a manager can read in five seconds.
Conditional formatting · Trends in one cell · Style the spark
Your first pivot table · Slice it finer · Which chart tells the story · Build your first charts · Chart the trend
Pull just the rows you need · Rank and top 10 · Every value, once · One formula, whole column · QUERY, SELECT and WHERE · QUERY GROUP and a live external feed
A real dashboard off 300 rows of transactions. KPI tiles, a store and category breakdown, a trend line, a chart built off your own pivot, and a live top-5 list that reranks itself when the data changes.
One build that uses every module. Nothing new, everything at once.
Build a contact system end to end. De-dupe the list, validate the inputs, look up the history, then automate the follow-up flags. It unlocks when all nine modules are done.
You are not buying content to watch. You are buying 193 graded reps, a safety net for the moments you get stuck, and proof you can cash in at work.
The product itself. Every answer is checked the moment you press Enter, green check or a nudge that names the concept. The Sheet even catches a hand-typed number and asks for a real formula. This is the practice nobody ever made you do.
Kills "I will never use this at work." You leave with a budget tracker, a supplier intake cleaner, a sales dashboard and a mini CRM that you built yourself. Adapt any of them for your own job the same week.
Kills "what if I hit a wall alone." Every exercise has a hint behind a checkbox and a wrong answer gets a nudge that names the missed concept. Optional short reference videos for many of the formulas, 37 of them, linked from inside the Sheet. Still stuck? Reply to any email and I answer.
Kills "I will forget it all in a month." A cheat-sheet tab with every function, its syntax and a worked example, plus 7 bonus workbooks with 204 extra self-checking exercises. Re-drill any skill the week your job actually needs it.
Kills "how do I show this." Finish all 193 checks and a personalized certificate unlocks with your name on it. Between the certificate and the four builds, "advanced spreadsheet skills" stops being a stretch.
Kills "another subscription." The course is a Google Sheet in your own Drive. No login, no expiry, no renewal. New lessons land in the master and you re-copy it any time, free.
It is deliberately not all of Google Sheets. That is the whole point. A course you finish beats a course that covers everything.
The last 10% of jobs needs the other 90% of Sheets. That is what the deeper courses are for, and finishing this one is how you find out which you actually want.
One payment. You get a link that drops your own private copy into your Google Drive. No app, no login, no platform to learn.
Type a formula, press Enter. Right moves your progress bar. Wrong gets a reason that names the concept you missed, not a red X. A hint sits behind a checkbox whenever you want one.
Pass all 193 and your certificate unlocks with your name on it. The Sheet stays in your Drive forever, and you can re-copy the master any time you want a refresh or a new lesson lands.
Hey, I'm Ryan 👋
I create every tutorial on this site. I built the Bootcamp because I kept watching people finish a video course, open a blank spreadsheet, and freeze. Watching is not practice. Typing a formula and getting told immediately whether it worked is.
So the whole course lives in a spreadsheet. Every exercise is graded by formulas inside the Sheet itself, which took a while to build and is the reason the feedback is instant instead of a quiz at the end of a module.
If you get stuck anywhere, reply to any email I send. I read every one.
If it is not for you, reply to any email I send, say so, and I refund you. No form. No quiz. No "what did you not like about it".
One Google Sheet with 17 tabs: 9 teaching modules, 4 capstone projects, a progress dashboard, a certificate tab and a cheat sheet. Plus 7 bonus practice workbooks with 204 extra exercises. You get force-copy links, so every file lands in your own Google Drive.
Basic Training, the free course, is 19 exercises and about 40 minutes. It teaches you to write a formula. The Bootcamp is 193 exercises across 9 modules and 4 projects, and it teaches you to do a job with a spreadsheet. If Basic Training felt too easy, this is the one you want.
Most people finish in 10 to 15 hours spread over two or three weeks. There is no schedule and no drip. Your copy saves as you go, so you can do one module a night or the whole thing on a Saturday.
No. You need a free Google account and a browser. There is no app, no Apps Script and no extension. The course is a normal Google Sheet.
Formulas built into the Sheet read your answer cell and compare it to a known correct value. Some checks read the formula text itself, so writing =VLOOKUP correctly is what passes, not pasting the answer. Every check shows either a green check mark or a specific nudge.
No. This is a Google Sheets course and the grading engine uses Sheets formulas. Most of the concepts transfer, but the exercises will not run in Excel.
It starts at navigation and number formatting, so a nervous beginner can start here. But it moves fast. If you have never typed a formula, do the free Basic Training course first and come back.
Yes, 37 of them, linked right next to the exercises they belong to. They are optional reference for when you are stuck, not the main event. Every exercise is you typing in the grid, and the whole course works without pressing play once.
Forever. The course is a Google Sheet that lives in your own Google Drive, so there is nothing to expire and no subscription to cancel. When I add lessons to the master, you can re-copy it free, any time.
No, and that is deliberate. This is formulas and spreadsheet craft: lookups, logic, text and dates, clean inputs, pivots, charts and QUERY. There is no code in it anywhere, and you never need to open the script editor.
You email me and I answer. Every exercise also has a hint behind a checkbox and a nudge that names the concept you missed, so most sticking points resolve without needing me at all. There is no community or forum, and there are no live calls.
There is a 30-day money back guarantee. Reply to any email I send, say it was not for you, and I refund you. No forms, no questions.
Every exercise has a hint behind a checkbox, and the nudge text tells you which concept you missed. If you are still stuck, reply to any email and I will answer.
One payment of $39. Lifetime access, 7 bonus workbooks, and every update from here on.
Get the Bootcamp