Using Excel: advanced skills

We have collated a number of online videos which we have tried and tested for you.  Please click on the list below for the activity you wish to learn.  If you would like to suggest a useful video that you have found online to include on our training resources section, please share it using the link share a 'how to' video.

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.