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
microsoft-excel-seeklogo.com.png

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

Download Course PDF