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.
✓✓✓
Press play to begin.
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.