Home / Course catalog / Excel level 2 – 1 Reconciling ... (Bus_Excel_02-01)

Business tools

Excel level 2 – 1 Reconciling and matching information (Bus_Excel_02-01)


Description

This module helps learners reconcile and consolidate information across files without manual checking. It directly addresses the need to match session lists, client lists, tariffs and SDN checks by using XLOOKUP and related techniques to bring in the right information from other tables and systems.

Content
  • XLOOKUP with examples
  • Use INDEXMATCH Instead of VLOOKUP
  • Optional : VLOOKUP function
  • Optional : XLOOKUP vs INDEX-MATCH
  • Optional : INDEX and MATCH function
  • Mail Merge with MS Word and Excel
Completion rules
  • All units must be completed