Member Fees: $289

Non-Member Fees: $389

Microsoft Excel – Pulling Data Using VLOOKUPs & More

Duration: Four hours

Prerequisites: The student must be a current Excel user and have taken at least Excel Levels 1 and 2 or have equivalent experience.

Description

Excel LOOKUPs are powerful and versatile functions that can save time and effort when working with large datasets, they are some of Excel’s most valuable and least understood functions. They are used to search for specific values within a data range and return related information from another location.  In this workshop, we will explore ways to return  data using advanced techniques like VLOOKUP, XLOOKUP, NAMED RANGES,  the MATCH and INDEX functions, and more.

Contents:

*NOTE: Half and Full Day Computer Skills classes are not eligible for AAIM’s All Access Training Pass usage.

*Registration will close TEN business days prior to the event.

For Cancellation/Reschedule and Inclement Weather Policy please click HERE

HRCI 2024 Approved Provider logo

HRCI Accreditation:

N/A|N/A|N/A


SHRM Recertification Provider logo

SHRM Accreditation:

N/A|N/A|N/A


National Registry of CPE Sponsors logo

CPE Accreditation:

Professional Development Credits Awarded: 7 Recommended

AAIM Employers’ Association 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.learningmarket.org.|Professional Development Credits Awarded: 7 Recommended

AAIM Employers’ Association 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.learningmarket.org.|Professional Development Credits Awarded: 7 Recommended

AAIM Employers’ Association 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.learningmarket.org.