Excel Tutorials
Go beyond basics — pivot tables, VLOOKUP, macros, data analysis, and automation techniques.
Introduction to Excel
Get started with Microsoft Excel — the interface, workbooks, worksheets, cells, navigation, and essential keyboard shortcuts.
Data Entry & Formatting
Enter data efficiently, format numbers, dates, and text, apply cell styles, and build professional-looking spreadsheets.
Formulas & Functions Basics
Master Excel formulas — cell references, arithmetic, SUM, AVERAGE, COUNT, IF, and building reusable calculation logic.
Text Functions
Manipulate, extract, clean, and combine text — LEFT, RIGHT, MID, TRIM, UPPER, LOWER, FIND, SUBSTITUTE, CONCAT, and more.
Lookup Functions — VLOOKUP, INDEX, MATCH & XLOOKUP
Find data across tables with VLOOKUP, HLOOKUP, INDEX, MATCH, and the modern XLOOKUP — the most important Excel skill for data work.
Date & Time Functions
Work with dates and times in Excel — TODAY, NOW, DATE, DATEDIF, NETWORKDAYS, and formatting dates for reports and calculations.
Logical Functions — AND, OR, NOT, SWITCH
Build decision logic in Excel — AND, OR, NOT, SWITCH, nested IF patterns, and combining logical tests for real-world rules.
Statistical Functions
Analyse data with SUMIF, AVERAGEIF, COUNTIF, PERCENTILE, STDEV, RANK, and other statistical functions for business reporting.
Sorting & Filtering
Organise and slice your data — single and multi-level sort, AutoFilter, Advanced Filter, SORT and FILTER functions in Excel 365.
Pivot Tables
Summarise thousands of rows instantly — create pivot tables, add slicers, group dates, build calculated fields, and refresh data.
Charts & Visualisations
Create and customise Excel charts — column, line, pie, bar, scatter, and combo charts — with formatting, sparklines, and dynamic titles.
Data Validation & Protection
Control data entry with dropdown lists, validation rules, and input messages — then lock sheets and workbooks to prevent unwanted changes.
Named Ranges & Excel Tables
Replace cryptic cell addresses with readable names — create Named Ranges, define Table structured references, and use the Name Manager.
Conditional Formatting
Automatically colour and highlight cells based on rules — highlight rules, data bars, colour scales, icon sets, and formula-based formatting.
Macros & VBA
Automate Excel with macros — record tasks, edit VBA code, write Sub procedures, interact with worksheets, and create basic user interfaces.