Excel 4: Automate the boring parts
Power Query, FILTER/SORT/UNIQUE, recorded macros on a button.
GH₵ 150 paid once, 12 months of access
See how it works
Each lesson has a practice computer beside it. You copy each step, and the course tells you when it is right. This is a real lesson, sped up.
Clean a messy file once, then refresh it forever.
A video course: you watch. A SchoolRegistry short course: you do the task yourself on a practice computer, and the course checks it as you go.
Who it is for
People who repeat the same Excel tidy-up every month.
What you will be able to do
- Bring in a CSV file with Power Query and clean it once
- Combine a whole folder of monthly files with one refresh
- Record a macro and put it on a button
By the end, your monthly sales pack takes one file move and one click: Power Query cleans and combines the files, live formulas keep the summary up to date, and a macro on a button does the rest.
How it works
Each lesson starts with a short video. Tolu, your guide, shows you what to do and says it in plain words. You practise on a real-looking Excel, with Tolu guiding each step.
You work on a practice computer inside the course, so you cannot break anything. More than 75% of your time is hands-on practice, not watching.
Every lesson is split into steps, and a row of step bars shows where you are. If a step is too hard, press Skip and come back to it later.
All 15 lessons5 modules. The free lessons are marked.
Module 1: Power Query, first steps
Bring a CSV file in and clean it with steps you never repeat by hand.
- 1.1Bring a CSV file in with Power QueryFree, try it: Bring a CSV file in with Power Query
- 1.2Remove junk columns and rows
- 1.3Fix types, split a column, replace values
Module 2: Cleaning that repeats itself
Fill down, remove duplicates, add a total column, and refresh.
- 2.1Fill down and remove duplicates
- 2.2A column that does the maths
- 2.3Refresh, and next month takes one click
Module 3: Put data together
Stack monthly files, bring in names and prices, and unpivot wide reports.
- 3.1Stack monthly files with Append
- 3.2Bring in names and prices with Merge
- 3.3Unpivot: turn a wide report into a list
Module 4: Whole folders and live lists
Combine a folder of files, and keep lists live with FILTER, SORT and UNIQUE.
- 4.1Combine a whole folder of files
- 4.2A live list with FILTER and SORT
- 4.3UNIQUE lists that keep up
Module 5: Macros and the one-click pack
Record a macro, put it on a button, save it safely, and build the final pack.
- 5.1Record a macro that formats a report
- 5.2A button, a safe save, and the security bar
- 5.3Final project: the one-click monthly sales pack
What you need
A laptop or desktop computer with a web browser and an internet connection. You practise inside the course, so you do not need to install anything.
Part of the Excel series
Excel 1 to Excel 4. Start at step 1, or jump ahead if you already know the basics.
- Excel 1: Excel for WorkBeginner, 4 hours
- Excel 2: Bigger lists and lookupsIntermediate, 5 hours
- Excel 3: Reports and dashboardsAdvanced, 6 hours
- Excel 4: Automate the boring partsExpert, 6 hours
Questions people ask
Who is Excel 4 for?
People who repeat the same Excel tidy-up every month. It follows Excel 3. If you already know that material, you can start here.
Can I try it before I pay?
Yes. Lesson 1, "Bring a CSV file in with Power Query", is free. You do not need to pay to start.
How long does it take?
There are 15 lessons and about 6 hours of learning. You go at your own pace, and you have 12 months of access.
What do I need?
A laptop or desktop computer with a web browser and an internet connection. You practise inside the course, so you do not need to install anything.
How much does it cost?
GH₵ 150, paid once. That opens every lesson for 12 months.