top of page

Microsoft Excel Advanced Formulas
Half Day

This module is designed for delegates who have attended our “Further Formula” module. Vlookup formula as well as a number of other powerful more advanced formulas will be covered. In addition the use of Charts and colour will be used to emphasise the data.


Course format: Half day, max capacity 6

Wireless Computer Accessories

Session topics


  • V Lookups

  • V Lookup/IF

  • Vlookup/Indirect (looking up values from multiple tables)

  • Combining formulas

  • Other Lookup functions

  • Index & Match

  • X Lookup

  • Error checking

  • Custom Charts

  • Conditional Formatting

bottom of page