Erthiox course audio
← Back to text lessons
Excel & Google Sheets
Listen to the audio to unlock the exam – or finish the lessons instead. Either path opens the same exam, and passing it earns the certificate. Prefer reading? Use the button above to go back to the 50 text lessons.
HOOK
Hook
Spreadsheets run the world quietly.
No memorized menus.
It is a calculator, a database, and a report, all in one place.
✓✓✓
WHY SPREADSHEETS AND
Why spreadsheets, and formula basics
Cell references point to data, so when the data changes, the answer updates.
✓
AGGREGATION CONDITIONAL FUNCTIONS
Aggregation, conditional functions, and lookups
SUMIF adds only those rows.
✓
TEXT CLEANING SPLITTING
Text cleaning, splitting, and combining
Real data is messy, and the course text functions are the cleanup crew.
Splitting and combining data follow naturally.
✓✓
PIVOT TABLES FORMATTING
Pivot tables, formatting, and validation
Together they protect the data your formulas and pivot tables depend on.
✓
FILTERING SORTING CLEANUP
Filtering, sorting, cleanup, and charts
Filtering and sorting are how you explore large datasets without deleting anything.
If a chart needs a paragraph of explanation, the chart is not finished yet.
✓✓
MACROS COLLABORATION AND
Macros, collaboration, and real tools
It is combining a solid core into tools that solve real problems.
✓
MISTAKES AND YOUR
Mistakes and your seven day plan
Day two, practise SUM, AVERAGE, COUNTIF, and SUMIF on a real dataset.
Pass the exam and you earn the certificate.
✓✓
CLOSE
Close
Spreadsheet mastery is a sequence: reference, do not retype.
And build tools others can audit and reuse.
The next spreadsheet you open is already your practice ground.
✓✓✓
0:00 / 11:33
Watched 0:00
Listen to the audio to unlock the exam.
Audio complete – you can now take the exam. Continue to exam.
That's the audio.
Listen again, read the lessons, or take the exam when you are ready.
Captions are on by default. Keyboard: Space play/pause, arrows seek 5s, M mute, F fullscreen player.