Excel: Dynamic Formulas and Clean Data
Upgrade from basic cell coordinates to resilient, modern spreadsheet techniques. Learn to build dynamic lookups, multi-criteria summaries, and self-expanding formulas that never break when data changes.
Like Duolingo, but for Excel: Dynamic Formulas and Clean Data. Tomo turns the whole topic into a game you play five minutes a day, until it actually sticks.
A short one: 12 levels across 2 sections, about 24 minutes end to end, roughly 5 days at five minutes a day. It moves through Building Resilient Formulas and Lookups and Automating Structure with Tables and Arrays. It assumes you already know the basics.
Free forever · No credit card · iPhone & Android
Key ideas in Excel: Dynamic Formulas and Clean Data
- XLOOKUP binds to explicit range references that shift automatically when columns are inserted
- VLOOKUP uses a static column index number that points to the wrong column after an insertion
- IFERROR catches all worksheet errors indiscriminately, masking broken formula syntax and typos
- XLOOKUP's built-in [if_not_found] argument returns a fallback only when a lookup match is absent
- The inner XLOOKUP searches horizontal headers to return an entire vertical column dynamically
- The outer XLOOKUP searches vertical row labels and extracts the target cell from that returned column
- XLOOKUP defaults strictly to exact match mode when the match_mode parameter is left blank
- VLOOKUP defaults to approximate matching when its range_lookup argument is omitted
- Unsorted data paired with VLOOKUP's default approximate match returns incorrect results silently
- A search_mode argument of -1 instructs XLOOKUP to scan from last item to first item
- Searching bottom-to-top retrieves the latest entry in chronological ledgers without re-sorting data
- COUNTIFS tests multiple column criteria simultaneously without modifying the source table structure
- Concatenated helper columns bloat workbook file size and break if delimiter collisions occur
- Multi-condition IFS functions run optimized internal C++ routines that outpace custom helper logic
- In Excel array math, multiplying logical arrays acts as an AND gate converting TRUE/FALSE to 1 and 0
- Adding logical arrays acts as an OR gate where any non-zero result evaluates as TRUE
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 Excel: Dynamic Formulas and Clean Data 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.
Why does an existing VLOOKUP often return the wrong value after you insert a new column into your table?
Get it right to open this lesson and 11 more in the app.
Where Excel: Dynamic Formulas and Clean Data takes you
- 1
Building Resilient Formulas and Lookups
- Modern Dynamic Lookups
- Expressive Multi-Condition Logic
- 2
Automating Structure with Tables and Arrays
- Structured Tables as Reliable Engines
- Spill-Powered Workflows with Dynamic Arrays
2 sections · 4 units · 12 levels. Built to play, not to enroll.
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
Excel: Dynamic Formulas and Clean Data 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 Business on Tomo
Excel for Project Coordinators
Learn the essential spreadsheet skills needed to track timelines, control budgets, and deliver clean status reports to stakeholders.
Profiting with AI Workflows
Move beyond basic prompting to build repeatable, high-value AI services and products. Learn to identify market gaps and automate the delivery of quality results.
Excel for Accounting
Build audit-ready spreadsheets, track cash flow, and automate financial calculations. Learn essential Excel formulas and ledger management tailored for accounting workflows.
Building an ILAAP in Excel
Construct a production-grade Internal Liquidity Adequacy Assessment Process model from scratch. Master contractual gap schedules, behavioral deposit overlays, dynamic stress testing engines, and regulatory counterbalancing capacity in Excel.
Trading with the CCI
Learn to use the Commodity Channel Index to spot market trends, identify overbought conditions, and find high-probability trade entries.
Privacy Program Management
Learn how to build, run, and protect an operational data privacy program. Master data mapping, privacy impact assessments, vendor risks, and breach response through the lens of the CIPM framework.
Start Excel: Dynamic Formulas and Clean Data today.
Download Tomo, search Excel: Dynamic Formulas and Clean Data, and play your first lesson in under a minute.