Microsoft® Excel Advanced Formulas: Lookup Functions

Microsoft® Excel Advanced Formulas: Lookup Functions will demonstrate to the user how to use formulas that extend across multiple worksheets as well as exploring the deeper function category Lookup and Reference. These will include such lookup functions as HLOOKUP and VLOOKUP, where mixed-cell referencing is featured in formulas as well as using named ranges. This course will also delve into data mining using the INDEX and MATCH functions in conjunction with each other.

Objective: Upon completion of this course the Excel user will be able to work with lookup functions along with mixed-cell referencing and named ranges. Featured functions include HLOOKUP and VLOOKUP, the LOOKUP function, as well as INDEX and MATCH.

• Multi-sheet Formulas
  1. Grouping worksheets
• Lookup Functions
  1. HLOOKUP
     1. Formulas with Mixed Cell Referencing
  2. VLOOKUP
     1. Using Named Ranges in formulas
  3. The LOOKUP Function
     1. Using Table Fields in formulas
  4. INDEX and MATCH

Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.