Course description

Most people learn Excel in bits and pieces: a formula from a colleague, a shortcut from a video, a lot of guessing. This course takes you from opening Excel for the first time to building reports you'd be happy to show your boss, in a clear order where each lesson builds on the one before.

It's a full course, not a quick taster. There are 10 sections and over 50 short lessons, and every section comes with a practice workbook so you learn by doing, not just watching.

What you'll learn

• Excel basics: the ribbon, workbooks, sheets, cells and the shortcuts that save you time every day.
• Clean, readable data: formatting, number formats, borders, freezing panes and getting a sheet ready to print.
• Formulas and functions: SUM, AVERAGE, MIN, MAX, IF, COUNTIF, SUMIF and more, plus how relative and absolute references really work.
• Managing lots of data: sorting, filtering and Excel tables.
• Lookups: pull information from one list into another with XLOOKUP and VLOOKUP.
• Charts: choose the right chart and make it clear at a glance.
• Pivot tables: turn thousands of rows into a tidy summary in seconds.
• Fixing errors: what #DIV/0!, #N/A and #VALUE! mean and how to fix them.

Two real projects

The course finishes with two projects you build from a blank sheet: a personal monthly budget and a sales report with a pivot table and chart. By the end you'll have used every skill from the course on something practical.

Who this course is for

• Complete beginners who have never really used Excel.
• People who use Excel at work but feel they're muddling through.
• Job seekers who want to list Excel skills on their CV with confidence.
• Small business owners who want to keep track of money, stock or customers.

How the course works

Watch each lesson at your own pace, then open that section's practice workbook and try it yourself. You keep lifetime access, so you can come back whenever you need a refresher.

What will i learn?

• Find your way around Excel confidently and set up well-organised workbooks
• Enter, format and tidy data so it’s easy to read and print
• Write formulas and use key functions like SUM, IF, COUNTIF, SUMIF and XLOOKUP
• Sort, filter and use Excel tables to manage large lists quickly
• Create clear charts that show trends at a glance
• Summarise large amounts of data in seconds with pivot tables
• Understand and fix common errors like #DIV/0! and #N/A
• Build a personal budget and a sales report from a blank sheet

Frequently asked question