Microsoft Excel Lookup Functions
Join us in this webinar and discover how Lookup Functions can save you time and increase your productivity.
Stream this recording multiple times at your convenience.
- $200.00 incl. GST
- PD hours: 1.25
Learn how to apply Lookup Functions to return values from a table or array using VLOOKUP, HLOOKUP, INDEX and MATCH. These versatile functions are powerful tools to have in your Excel arsenal.
At the end of this webinar you will be familiar with:
• What are Lookup Functions?
• Lookup Formula Criteria Matrix
• VLOOKUP Function
• HLOOKUP Function
• LOOKUP Error Messages
• The IFERROR function
• MATCH Function
• VLOOKUP MATCH
• Matrix Lookups
• Lookup Function
• INDEX MATCH
• INDEX MATCH MATCH
• Validating data
This webinar is designed for Business professionals, Business owners, Financial Controllers, Accountants, Accounts Administration staff and anyone who requires to understand Excel LookUp functions to increase their productivity.
Attendees should be comfortable within the Windows environment and have intermediate level Knowledge of Excel.
Note: We will be demonstrating in Excel 2016 however this webinar will also be relevant for users of earlier versions.
|Data Analytics and Dashboards (1 of 5)||Webinar Recording|
|Microsoft Excel PivotTables 2016||Webinar Recording|
|Power BI with Excel: Overview||Webinar Recording|
|The Best of Microsoft Visio 2016||Webinar Recording|