Skip to main content

Mastering the Excel Lookup Functions

-

Add to Calendar

Webinar

2.00 Credits

Member Price $89.00

Non-Member Price $119.00

Overview

In today’s data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel’s lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you’re a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel’s full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Highlights

The major topics that will be covered in this class include:
  • A review of the various lookup functions, beyond VLOOKUP
  • Learn which lookup works best for your situation
  • How to apply the many lookup functions
  • Discover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectively
  • An in-depth review of the following functions:
    • VLOOKUP / HLOOKUP
    • XLOOKUP
    • MATCH / INDEX
    • XMATCH
    • INDIRECT
    • FILTER
    • SORT / SORTBY
    • UNIQUE
  • An overview of some newer functions

Prerequisites

None

Designed For

Any Excel user that wants to learn how to use the LOOKUP functions

Objectives

After attending this presentation you will be able to ...

  • Identify which lookup function works for your needs
  • Distinguish the difference between the many lookup functions
  • Recall how to effectively utilize Excel's lookup functions

Preparation

None

Notice

This course is offered by a 3rd party vendor and will not be accessible in the My CPE Tracker section of the ISCPA website. Course access information will be emailed directly to you by CPA Crossings.

Leader(s):

Leader Bios

Bryan Smith, CPA Crossings LLC

Bryan serves as a trusted adviser to CPAs on all aspects of information technology. Bryan’s expertise includes in-depth knowledge of paperless work flow solutions, the impact of technology on internal controls, strategic IT infrastructure design and information security best practices. As a nationally recognized author and presenter on information technology issues impacting CPAs, Bryan is passionate about the opportunities for CPAs to benefit from safe and secure computing.

Return to Top

Non-Member Price $119.00

Member Price $89.00