Skip to content

X

Microsoft Excel guides

Formulas, tables, charts and tidying up messy data.

Microsoft Excel

VLOOKUP and XLOOKUP explained simply

Pull a price, name or code from one sheet into another automatically, and understand why it sometimes says #N/A.

Intermediate · 10 min read Microsoft Excel

Build your first pivot table in Excel

Turn thousands of rows of sales, hours or invoices into a one-page summary in about two minutes.

Intermediate · 9 min read Microsoft Excel

Recovering an Excel or Word file you did not save

Three places to look before you accept that a morning of work has gone.

Beginner · 6 min read

Other sections

Microsoft Word 2 Microsoft Outlook 3 Microsoft PowerPoint 1 Microsoft Teams 1 OneDrive & SharePoint 1 Sage 3 QuickBooks & Xero 1 Windows & PC Basics 3 Security & Scams 2