Resilient Excel Spreadsheets
Upgrade from fragile, manual spreadsheets to modern, dynamic workbooks. Learn to replace nested IFs, retire brittle lookups with XLOOKUP, and build self-updating models using dynamic arrays and structured tables.
Like Duolingo, but for Resilient Excel Spreadsheets. Tomo turns the whole topic into a game you play five minutes a day, until it actually sticks.
A short one: 10 levels across 2 sections, about 20 minutes end to end, roughly 4 days at five minutes a day. It moves through Formulas That Don't Break and Dynamic and Self-Updating Layouts. It assumes you already know the basics.
Free forever · No credit card · iPhone & Android
Key ideas in Resilient Excel Spreadsheets
- VLOOKUP relies on a hardcoded column index number that does not shift when columns are inserted.
- XLOOKUP uses a direct cell range reference for its return vector that adjusts automatically when columns move.
- XLOOKUP decouples lookup and return ranges so the return column can sit anywhere, even to the left.
- XLOOKUP includes a dedicated fourth argument specifically for missing value fallback text.
- Using the built-in not-found argument avoids masking unexpected calculation errors that IFERROR hides.
- XLOOKUP defaults to an exact match of 0, so unsorted data tables will not produce silent wrong answers.
- VLOOKUP defaults to approximate matching, which returns false near-matches if the table is unsorted.
- XLOOKUP only performs approximate or wildcard searches when explicitly told via the match_mode parameter.
- The inner XLOOKUP evaluates a horizontal header row and returns an entire vertical column vector.
- The outer XLOOKUP searches vertically within that returned dynamic column vector for the target row item.
- Nesting lookup vectors replaces the static coordinates of traditional INDEX-MATCH two-way grids.
- IFS tests condition-result pairs in a single list without closing parenthesis stacks
- IFS stops and returns the value for the first true condition encountered
- A final TRUE argument serves as an explicit fallback catch-all in IFS
- SWITCH evaluates a single expression once against multiple exact values
- SWITCH eliminates repeating cell references in equality checks
You've tried the other tabs
Thirty open tabs. Four facts you actually kept.
You watched. You nodded. By Sunday it was gone.
One answer, then back to scrolling.
Eight weeks. You meant to finish. You didn't.
Tomo gives Resilient Excel Spreadsheets the Duolingo treatment: levels, streaks, and quick quizzes that test what you just learned. That game loop is what the tabs above never had, so it's the one you actually finish.
Here's what playing it feels like
A real question from this course. Take your best guess.
You insert a new column into your data table. Why does XLOOKUP continue returning the correct values?
Get it right to open this lesson and 9 more in the app.
How to learn Resilient Excel Spreadsheets, step by step
Go in order. 10 short levels across 2 sections, about 20 minutes in all, five minutes a day.
- 1
Formulas That Don't Break
- Modern Lookups with XLOOKUP
- Clean Multi-Condition Logic
- 2
Dynamic and Self-Updating Layouts
- Dynamic Arrays and Spill Ranges
- Structured Tables as Reliable Foundations
2 sections · 4 units · 10 levels. Built to play, not to enroll.
Questions about Resilient Excel Spreadsheets
How do I learn Resilient Excel Spreadsheets?
Go in order: start with Formulas That Don't Break, then Dynamic and Self-Updating Layouts. On Tomo that's 10 short levels, about 20 minutes in all, played five minutes a day. Start free and play the first level in under a minute.
Is there a Duolingo-style app for Resilient Excel Spreadsheets?
Yes. Tomo works like Duolingo: short daily lessons, streaks and quick quizzes. Resilient Excel Spreadsheets is one of its free courses, and you can type any other topic to get a course of your own.
Is the Resilient Excel Spreadsheets course free?
Yes. Resilient Excel Spreadsheets is playable on Tomo's free plan, which doesn't expire. No credit card, no waitlist. Download the app and start your first lesson.
How long does it take to learn Resilient Excel Spreadsheets?
10 levels across 2 sections, about 20 minutes of play in total. It's built for five minutes a day, so you finish it a little at a time instead of all at once.
Do I need any background to start Resilient Excel Spreadsheets?
No. It's pitched at an intermediate level, so it starts where you are and builds up. If you can tap a phone, you can start.
Tomo is in ChatGPT
Tomo is also a ChatGPT plugin: the same playable courses, built and played inside your chat.
Add Tomo to ChatGPT- What to ask
- “Make me a Tomo course on black holes.” “Turn this chat into a Tomo course.”
- What you get
- Quick questions with instant feedback, hearts and stars, ready to play in about a minute.
- Where it goes
- No sign-up to start. Connect your Tomo account and your streak carries on in the app.
You pick the voice
Resilient Excel Spreadsheets is taught in the Professor style: clear, structured, thorough. Want a different feel? In the app you can spin up the same topic in any of Tomo's teaching styles. Same facts, totally different vibe.
More Technology on Tomo
Modern Excel Workflows
Transform brittle, static spreadsheets into resilient, self-updating data models. Master dynamic arrays, structured table logic, and bulletproof lookups to build workbooks that never break when data changes.
Dynamic Excel Workflows
Upgrade from fragile cell formulas to resilient, modern spreadsheet design. Learn how to leverage dynamic arrays, flexible lookups, and structured tables to build spreadsheets that never break when data updates.
Working with Excel Data
Move beyond basic cell entries and static sums to build reliable, adaptable spreadsheets. Learn how to combine dynamic lookup formulas, clean irregular inputs, summarize multi-dimensional tables, and troubleshoot complex calculation models.
Excel for Everyday Work
Build confidence in Excel by learning how spreadsheets actually think and operate. From basic data entry and rock-solid formulas to lookups and pivot tables, you'll gain the practical skills needed to organize, calculate, and present data with clarity.
Excel for Everyday Work
Turn raw numbers into clear, automated answers using modern spreadsheet essentials. Learn to write dynamic formulas, clean up messy tables, and connect separate data lists with confidence.
Data Analysis from Excel to SQL
Transform messy raw spreadsheets into automated models, interactive dashboards, and robust database queries. Learn to clean data in Power Query, calculate metrics in DAX, and extract answers with SQL.
Start Resilient Excel Spreadsheets today.
Download Tomo, search Resilient Excel Spreadsheets, and play your first lesson in under a minute.