Mastering the Excel Lookup Functions (Rebroadcast with Live Q&A - CPA Crossings)
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.
This event will be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. |
Applicable for
Learning 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
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
Presenter
Bryan L. Smith, CPA.CITP, CISAWhat is CPA Crossings?
CPA Crossings is a global leader in online professional education for CPAs and other financial professionals. Established in 2001, CPA Crossings offers scheduled webinars on a range of topics including ethics, fraud, business, personal development, technology, and other fields of study. All of these courses are developed and presented by a team of 60 instructors, recognized as experts in their respective fields of study. Note that the titles from CPA Crossings comprise both live webinars and archived recordings.Webinar FAQs
What training platform will be used?
Webinars are conducted using an online conferencing and training software application called WebEx. The client software downloads automatically after you log in to your WebEx meeting and requires no additional installation. For your first webinar, please allow a few minutes for it to load.How do I get the login information?
Once you are registered online, you will receive an email confirmation listing the WebEx instructions, link and password. This email will come from sender CPA Crossings. If you do not receive this email immediately after your registration has been processed, first check your spam folder. If the link is not in this folder, call the CPA Crossings Webinar Hotline at 877.370.2220 ext. 1 for assistance.How do I hear the audio portion of my online training?
Once you click on the link to join the webinar, you will see a pop-up window to "Join teleconference”. Your first option is to use the telephone. Dial the number provided, enter the training session number and your attendee ID by phone, as provided in the pop-up window when prompted, then click OK. The second option is to join using the computer to listen to the audio through your computer speakers. Once you click that option, it will ask you to do an audio test, then prompt you to join the audio conference.How early may I login to my online training session?
Participants can join webinars up to 30 minutes before the webinar start time. If you are a first-time WebEx user, please join the session at least 15 minutes prior to start time to allow for WebEx configuration.Will I receive a certificate of completion?
A polling question will be asked approximately every 15 minutes to confirm that all participants are still in attendance. A participant must answer 70% of the polling questions in order to receive full credit for the webinar. You will receive your record of attendance via e-mail within 24 hours of completion of the webinar.
For more webinar FAQs, please visit their website here.
Disclosure Notice
In order to register you to the webinars hosted by CPA Crossings, it is necessary for CPABC to provide your name and email address to CPA Crossings. This information will be used solely for the purposes of providing you with CPA Crossings webinar(s)’ confirmations and reminders.
Please be advised that this course is hosted by a third-party education provider whose server may be located outside of Canada, so information such as the registrant's name and email address (where needed) may be stored there.
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. 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. 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.- 2
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- N/A
- 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 (Rebroadcast with Live Q&A - CPA Crossings)
- 2
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- N/A
- Credits
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.
This event will be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. |
Applicable for
Learning 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
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
Presenter
Bryan L. Smith, CPA.CITP, CISAWhat is CPA Crossings?
CPA Crossings is a global leader in online professional education for CPAs and other financial professionals. Established in 2001, CPA Crossings offers scheduled webinars on a range of topics including ethics, fraud, business, personal development, technology, and other fields of study. All of these courses are developed and presented by a team of 60 instructors, recognized as experts in their respective fields of study. Note that the titles from CPA Crossings comprise both live webinars and archived recordings.Webinar FAQs
What training platform will be used?
Webinars are conducted using an online conferencing and training software application called WebEx. The client software downloads automatically after you log in to your WebEx meeting and requires no additional installation. For your first webinar, please allow a few minutes for it to load.How do I get the login information?
Once you are registered online, you will receive an email confirmation listing the WebEx instructions, link and password. This email will come from sender CPA Crossings. If you do not receive this email immediately after your registration has been processed, first check your spam folder. If the link is not in this folder, call the CPA Crossings Webinar Hotline at 877.370.2220 ext. 1 for assistance.How do I hear the audio portion of my online training?
Once you click on the link to join the webinar, you will see a pop-up window to "Join teleconference”. Your first option is to use the telephone. Dial the number provided, enter the training session number and your attendee ID by phone, as provided in the pop-up window when prompted, then click OK. The second option is to join using the computer to listen to the audio through your computer speakers. Once you click that option, it will ask you to do an audio test, then prompt you to join the audio conference.How early may I login to my online training session?
Participants can join webinars up to 30 minutes before the webinar start time. If you are a first-time WebEx user, please join the session at least 15 minutes prior to start time to allow for WebEx configuration.Will I receive a certificate of completion?
A polling question will be asked approximately every 15 minutes to confirm that all participants are still in attendance. A participant must answer 70% of the polling questions in order to receive full credit for the webinar. You will receive your record of attendance via e-mail within 24 hours of completion of the webinar.
For more webinar FAQs, please visit their website here.
Disclosure Notice
In order to register you to the webinars hosted by CPA Crossings, it is necessary for CPABC to provide your name and email address to CPA Crossings. This information will be used solely for the purposes of providing you with CPA Crossings webinar(s)’ confirmations and reminders.
Please be advised that this course is hosted by a third-party education provider whose server may be located outside of Canada, so information such as the registrant's name and email address (where needed) may be stored there.
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. 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. 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.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.