Spreadsheets in Practice: Real-World Data
Bridge the gap between basic cell entry and functional data management. Learn to clean messy inputs, reconcile records, and build reliable models for school administration and financial tracking.
Like Duolingo, but for Spreadsheets in Practice: Real-World Data. Tomo turns the whole topic into a game you play five minutes a day, until it actually sticks.
24 levels across 4 sections, about 48 minutes end to end, roughly 10 days at five minutes a day. It moves through Reshaping and Slicing Raw Records, Reconciling and Joining Split Datasets, Cleaning and Defending Messy Inputs, and Actionable Summaries and Analytical Models. It assumes you already know the basics.
Free forever · No credit card · iPhone & Android
Key ideas in Spreadsheets in Practice: Real-World Data
- SUMIFS evaluates multiple column ranges simultaneously using an implicit AND condition.
- Unlike legacy SUMIF, SUMIFS places the sum_range argument first, followed by pairs of criteria.
- Native multi-criteria formulas eliminate the need to concatenate lookup keys in auxiliary columns.
- Comparison operators in criteria arguments must be enclosed in quotes as text strings.
- The ampersand (&) operator links the logical operator string to a live cell reference or DATE function.
- Failing to concatenate leaves cell references trapped as literal text that fails matching.
- The asterisk (*) acts as a wildcard representing any sequence of zero or more characters.
- The question mark (?) represents exactly one single variable character in criteria arguments.
- Wildcard patterns allow conditional aggregation across inconsistent naming conventions without cleaning.
- Referencing a cell holding filter criteria makes a summary dashboard update without formula edits.
- Hardcoding criteria text directly into formulas requires tedious manual finds-and-replaces across sheets.
- Dynamic criteria cells enable standard formulas to be dragged down summary tables cleanly.
- SUMIFS automatically ignores text entries in the sum range rather than raising a #VALUE! error.
- Imported numeric values formatted or stored as text strings are silently treated as zeroes by SUMIFS.
- Using VALUE or text-to-columns restores the numeric type needed for conditional aggregations to sum.
- FILTER writes calculated outputs elsewhere leaving the source table completely untouched
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 Spreadsheets in Practice: Real-World 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.
Where does the sum_range column go when you write a SUMIFS formula?
Get it right to open this lesson and 23 more in the app.
Where Spreadsheets in Practice: Real-World Data takes you
- 1
Reshaping and Slicing Raw Records
- Targeted Aggregation with Multi-Condition Math
- Dynamic Filtering and Sorting with Formula Arrays
- 2
Reconciling and Joining Split Datasets
- Modern Lookups Across School and Ledger Tables
- Table Merging and Transaction Reconciliation
- 3
Cleaning and Defending Messy Inputs
- Normalizing Inconsistent Real-World Text and Dates
- Error-Proofing and Input Governance
- 4
Actionable Summaries and Analytical Models
- Multi-Dimensional Pivot Table Analysis
- Variance, Cohort, and Financial Modeling
4 sections · 8 units · 24 levels. Built to play, not to enroll.
You pick the voice
Spreadsheets in Practice: Real-World Data is taught in the Explain Like I'm 5 style: no big words. promise.. 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
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.
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.
Everyday Excel
Stop wrestling with unruly spreadsheets. Learn how to write reliable formulas, fix common calculation blunders, and turn raw lists into clean, actionable summaries.
Everyday Excel
Stop doing repetitive manual data entry and let the spreadsheet work for you. Learn the essential formulas, cleanup tricks, and summary tools to turn messy numbers into clear answers fast.
Python for Excel Users
Stop wrestling with crashing workbooks and fragile formulas. Learn how to use lightweight Python scripts to clean, combine, and automate your everyday spreadsheet workflows in minutes.
Talking to Databases with SQL
Learn how to store, find, and organize information using SQL. This course takes you from your very first query to joining complex tables like a pro.
Start Spreadsheets in Practice: Real-World Data today.
Download Tomo, search Spreadsheets in Practice: Real-World Data, and play your first lesson in under a minute.