Description
This module follows on from the Excel Intermediate 1 and covers Absolute Values, Sub Totals, Pivot Tables, working with Dates and Times, VLOOKUP, SmartArt and Themes. You should ideally have done the two Foundation Level modules and the Intermediate 1 module before attempting this one.
➢ Absolute Values
➢ Subtotals
➢ Pivot Tables
➢ Named Ranges
➢ VLOOKUP.