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.
Like Duolingo, but for Modern Excel Workflows. Tomo turns the whole topic into a game you play five minutes a day, until it actually sticks.
A short one: 11 levels across 2 sections, about 22 minutes end to end, roughly 4 days at five minutes a day. It moves through Building Resilient Formulas and Structuring for Integrity and Automation. It assumes you already know the basics.
Free forever · No credit card · iPhone & Android
Key ideas in Modern Excel Workflows
- VLOOKUP uses a hardcoded integer index that stays fixed even when table columns shift.
- Excel shifts explicit range references like C2:C100 automatically when columns are inserted.
- XLOOKUP keeps your intended return target because it points to an actual cell range.
- XLOOKUP defaults to searching from first to last (top to bottom) with a search_mode of 1.
- Passing -1 as search_mode forces XLOOKUP to scan from bottom to top.
- Searching bottom-to-top grabs the latest chronological entry without touching sort order.
- An inner XLOOKUP can return an entire row or column range instead of a single value.
- An outer XLOOKUP can take that dynamic returned range as its own return array argument.
- Nesting horizontal and vertical XLOOKUPs queries a 2D matrix directly without helper keys.
- IFERROR blindly suppresses all errors, including typos, circular references, and broken ranges.
- XLOOKUP's if_not_found argument triggers strictly when a lookup value cannot be matched.
- Handling missing values natively inside XLOOKUP keeps formula syntax errors visible.
- Excel's dynamic array engine outputs multi-cell results into neighboring cells automatically
- A formula entered once in the top-left cell spills downward or across without manual dragging
- Formulas in spilled cells appear grayed out in the formula bar and cannot be edited individually
- Placing the hash symbol (#) after a cell reference binds the formula to its entire spilled range
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 Modern Excel Workflows 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.
What happens to a formula reference like C2:C100 when you insert a brand-new column to the left of column C?
Get it right to open this lesson and 10 more in the app.
How to learn Modern Excel Workflows, step by step
Go in order. 11 short levels across 2 sections, about 22 minutes in all, five minutes a day.
- 1
Building Resilient Formulas
- Modern Lookups Beyond VLOOKUP
- Dynamic Arrays and Spill Logic
- 2
Structuring for Integrity and Automation
- Structured Tables for Expanding Datasets
- Defensive Auditing and Input Controls
2 sections · 4 units · 11 levels. Built to play, not to enroll.
Questions about Modern Excel Workflows
How do I learn Modern Excel Workflows?
Go in order: start with Building Resilient Formulas, then Structuring for Integrity and Automation. On Tomo that's 11 short levels, about 22 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 Modern Excel Workflows?
Yes. Tomo works like Duolingo: short daily lessons, streaks and quick quizzes. Modern Excel Workflows is one of its free courses, and you can type any other topic to get a course of your own.
Is the Modern Excel Workflows course free?
Yes. Modern Excel Workflows 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 Modern Excel Workflows?
11 levels across 2 sections, about 22 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 Modern Excel Workflows?
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
Modern Excel Workflows is taught in the Bestie style: your friend who just gets it. 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
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.
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.
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.
Modern JavaScript in Practice
Move beyond basic syntax to build high-performance, interactive web components. Learn the professional patterns used to manage state, handle asynchronous data, and manipulate the DOM with precision.
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.
Start Modern Excel Workflows today.
Download Tomo, search Modern Excel Workflows, and play your first lesson in under a minute.