Mastering the Excel Lookup Functions (Live Webinar)
Overview
Course Description
Applicable for
Learning Objectives
- 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
Content
- 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
Course Dates & Registration
.webp?language=en-CA)
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.Improving Your Virtual Learning Experience
Live webinars have varying levels of expected interaction, with some requiring microphone and camera capabilities to support a proper learning experience – please email pdreg@bccpa.ca if you have concerns.
In general, we encourage participants to have their cameras turned on to enhance their virtual learning experience. This practice promotes a stronger connection with the instructor and fellow participants, and fosters improved communication and collaboration.
Live Webinar FAQs can be found here.
Registration terms and conditions, including the cancellation policy can be found here. If you require further assistance, please contact the PD Department.
- 2
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 3
- Credits
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.
Mastering the Excel Lookup Functions (Live Webinar)
- 2
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 3
- Credits
Overview
Course Description
Applicable for
Learning Objectives
- 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
Content
- 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
Course Dates & Registration
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.Improving Your Virtual Learning Experience
Live webinars have varying levels of expected interaction, with some requiring microphone and camera capabilities to support a proper learning experience – please email pdreg@bccpa.ca if you have concerns.
In general, we encourage participants to have their cameras turned on to enhance their virtual learning experience. This practice promotes a stronger connection with the instructor and fellow participants, and fosters improved communication and collaboration.
Live Webinar FAQs can be found here.
Registration terms and conditions, including the cancellation policy can be found here. If you require further assistance, please contact the PD Department.
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.