Excel 2: Bigger lists and lookups
Tables, dropdowns, highlights, SUMIFS and XLOOKUP.
GH₵ 110 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.
Match two lists with XLOOKUP and see it checked straight away.
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 finished Excel 1 and now have long, messy lists.
What you will be able to do
- Remove repeats and tidy names in a raw sales list
- Make late invoices and low stock stand out in colour
- Total by branch and fetch prices from another list
By the end you will turn a messy sales list from three branches into a clean tracker with tables, dropdowns, colour rules, branch totals and lookups.
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: Tables and repeats
Excel tables, the total row, and removing repeated rows.
- 1.1Turn a list into a tableFree, try it: Turn a list into a table
- 1.2The total row and table styles
- 1.3Remove repeated rows
Module 2: Clean data, and keep it clean
TRIM and PROPER, Text to Columns, and dropdown lists.
- 2.1Tidy messy names with TRIM and PROPER
- 2.2Split one column into many with Text to Columns
- 2.3Dropdown lists that stop mistakes
Module 3: Make problems stand out
Late invoices, low stock, colour scales, data bars and sorting in layers.
- 3.1Highlight late invoices and low stock
- 3.2Colour scales and data bars
- 3.3Sort by more than one column
Module 4: Totals with conditions
SUMIFS, COUNTIFS and a branch summary table.
- 4.1SUMIFS: adding up with two conditions
- 4.2COUNTIFS and number conditions
- 4.3Build a branch summary table
Module 5: Lookups and the final project
XLOOKUP, VLOOKUP, IFERROR and your branch sales tracker.
- 5.1XLOOKUP: fetch a value from another list
- 5.2Read older files: VLOOKUP and IFERROR
- 5.3Final project: the branch sales tracker
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 2 for?
People who finished Excel 1 and now have long, messy lists. It follows Excel 1. If you already know that material, you can start here.
Can I try it before I pay?
Yes. Lesson 1, "Turn a list into a table", is free. You do not need to pay to start.
How long does it take?
There are 15 lessons and about 5 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₵ 110, paid once. That opens every lesson for 12 months.