Overview
-
Applying VLOOKUP function to a dataset
2 mins
-
Usage of IFERROR function in VLOOKUP function
11 mins
-
Usage of HLOOKUP function in a dataset
16 mins
-
How to use INDEX function in Excel
23 mins
-
How to use MATCH function in Excel
26 mins
-
How to apply more than one function to a dataset
33 mins
Course Description
Excel is one of the most widely used spreadsheet programs in the world. People have been using it for the last 30 years and throughout these years, it has been upgraded with more and more features.
The LOOKUP Function is categorized under Excel Lookup and Reference functions. The function performs a rough match lookup either in a one-row or one-column range and returns the corresponding value from another one-row or one-column range.
While doing financial analysis, if we wish to compare two rows or columns, we can use the LOOKUP function. It is designed to handle the simplest cases of vertical and horizontal lookup.
The more advanced versions of the LOOKUP function are HLOOKUP and VLOOKUP.
VLOOKUP and HLOOKUP are some of the most well-known and most useful formulas in Excel. Used properly, they will help you to improve the accuracy and integrity of your Excel workbooks, save a ton of time and minimize data entry errors.
Join this excel CPE webinar to learn how to use Lookup Functions to the best of your advantage.
It doesn’t matter what version of the PC or Mac operating system you’re using. The techniques we will cover in this CPE course will work similarly in Excel for PC and Mac
Learning Objectives
- To identify how to construct and use the VLOOKUP functions
- To analyze how to Summarize Tables for future-proofing VLOOKUP
- To identify how to construct and use the HLOOKUP function
- To discuss how to use MATCH and INDEX functions
Recommended For
- This CPE webinar is recommended for CPAs, CVAs, CMAs, and other individuals who want to understand the most powerful spreadsheet program Microsoft Excel its Lookup functions to better assist their clients.
Who Should Attend?
- Accountant
- Accounting Firm
- Accounting Managers
- Bookkeepers & Accountants & Tax Preparers
- Certified Management Accountant (CMA)
- Certified Public Accountant (CPA)
- Chartered Accountant
- Chartered Professional Accountant
- Chief Accounting Officer
- Cloud Accountants
- CPA (Industry)
- CPA - Mid Size Firm
- CPA - Small Firm
- CPA in Business
- Entrepreneurial CPA
- Senior Accountant
- Staff of Accounting Firm
- Young CPA