This comprehensive Excel 2022 course takes you from the fundamentals to advanced techniques so you can become truly proficient with one of the world’s most powerful spreadsheet applications. You’ll begin by mastering Excel basics, learning to navigate the ribbon interface, use undo and redo, copy and paste effectively, find and replace data, and work with keyboard navigation and shortcuts to increase your productivity.

You’ll then move on to essential formatting options such as resizing rows and columns, font and number formatting, cell alignment, borders, cell colours and sorting. These lessons teach you how to create clear, professional-looking spreadsheets that communicate information effectively.

The course also covers inputting, viewing and managing data. You’ll learn to work with multiple worksheets, set up printing, use Autofill and Flash Fill, create drop-down lists, transpose rows and columns, import data from the web, and name data ranges for easier formula use. With these skills, you’ll streamline your data entry process and improve accuracy.

Formulas and functions are introduced step by step, starting with SUM, SUMIF, AVERAGE, COUNT and COUNTA. You’ll explore absolute versus relative cell references, error checking and formula calculations. Advanced modules cover the most commonly used functions, including IF, IFERROR, VLOOKUP, AND, OR, NOT and XLOOKUP, giving you the ability to perform complex calculations and lookups with ease.

Additional lessons teach you more Excel functions like TRIM, SUBTOTAL, ROUND, MAX, MIN, TEXT, LARGE, SMALL, TODAY and NOW, as well as text functions UPPER, LOWER, PROPER, LEFT, RIGHT, FIND, SEARCH and MID. You’ll also master dynamic array functions, ranking data, creating custom sorts and advanced drop-down lists to make your spreadsheets more powerful and interactive. By the end of this masterclass, you’ll have a complete skill set for managing, analysing and presenting data in Excel 2022.