Text, Tables and Clean-up
Take a messy export and make it usable: rebuild text from one worked example, turn ranges into Tables that grow themselves, summarise in thirty seconds, and set the whole clean-up to repeat next month.
What this course assumes and what it gives you
Assumes: Excel I, or you are already comfortable writing a formula and locking a reference.
You will be able to: You can turn a fortnightly export into a report without redoing the work each time.
The spreadsheet is in the page. You type your answers here and the engine works them out against real data, cell by cell, so an answer that gets there a different way is still right.
Syllabus
0 of 5 lessons done
- 1Flash Fill: patterns without formulasSplit and rebuild text by showing Excel one worked example, and recognise when Flash Fill is the wrong tool.6 teaching steps · 6-question quizNot startedStart lesson →
- 2Tables: ranges that grow themselvesConvert a range to an Excel Table, address it by name with structured references, and explain why a fixed range is the most common cause of a wrong total.6 teaching steps · 6-question quizNot startedStart lesson →
- 3PivotTables: a summary in thirty secondsBuild a PivotTable from a Table, arrange rows, columns and values, group dates, and know when a refresh is required.6 teaching steps · 6-question quizNot startedStart lesson →
- 4Power Query: clean it once, reuse it foreverImport a raw export, shape it in the query editor, and refresh next month's file without repeating any of the work.6 teaching steps · 6-question quizNot startedStart lesson →
- 5Connecting the fourCombine query, Table, PivotTable and Flash Fill into one refreshable summary, and choose the right tool for a given job.6 teaching steps · 6-question quizNot startedStart lesson →
Final exam
Text, Tables and Clean-up: Final ExamLocked
Every question is new. Nothing here appeared in the lessons or the quizzes.
15 minutes, timed · 10 questions
Finish the lessons first. The exam opens once all 5 lessons are done.