Objectives of the course:

  • Using the MATCH function to find the position of a value in a table
  • Using the VLOOKUP and HLOOKUP functions to find a particular value from a table

Objectives of the course:

  • Creating & Modifying a Pivot Table
  • Analysing Pivot Tables
  • Creating a Pivot Chart from an existing Pivot table
  • Creating a Pivot Chart at the same time as a table
  • Modifying Pivot Charts