Excel PivotTables

Creating pivot tables (watch time: 13:18)
Using pivot tables can revolutionise your spreadsheets. Get started here.
Excel Conditional Formating

Conditional formatting (watch time: 4:25)
Automate formatting in your spreadsheet to save yourself time.
Excel If Statements

IF statements and formulas (watch time: 9:00)
Learn how IF statements can save you time.
Excel XLookup

XLookup (watch time: 20:48)
When you need to find data in your spreadsheets, XLookup can do it for you.
Excel Hacks for Writing Formula

Creating formulas easily (watch time: 10:48)
Learn some basic formulas in ten minutes.
Data Validation

Data validation (watch time: 15:42)
Learn how to put smart drop-down lists into your spreadsheets.