What you’ll learn

• Named Ranges
  • Useful for longer formulas and navigation

• Data Validation
  • Restricting data entry in cells to certain data types

• V-Lookup Tables 
  • The VLOOKUP function can be used to find specific data that is stored in a table of data using existing information as a reference. E.g. looking up a price list based on a product code from another table.

• If Error 
  • Combine If Error with a V-lookup function to remove error messages from cells.

• X-lookups
  • Replace V-Lookups with a bigger, better, more versatile formula!  Only available in Microsoft Excel 365

• Pivot Tables 
  • Get up and running with Pivot Table basics to analyse and summarise data

Who is it for?

Now you have some Excel experience, you are ready to get to the next level with your Excel use. These are essential 'advanced' skills in Excel which you need for working with larger data sets.