Events

Loading Courses

« All Courses

  • This course has passed.

Microsoft® Excel Advanced Formulas: Lookup Functions

October 24, 2023 @ 9:00 am - 11:00 am

$99.00

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available

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.

Details

Date:
October 24, 2023
Time:
9:00 am - 11:00 am
Cost:
$99.00
Courses Category:

Locations

Virtual Live

Leave a Comment

Your email address will not be published. Required fields are marked *