Live Webinar on Excel Functions and Lookup Formulas: Using VLOOKUP, HLOOKUP, MATCH, INDEX, IFNA, IFERROR and more..
OVERVIEW Lookup formulas are far superior to manually searching for specific data elements in a spreadsheet. VLOOKUP, HLOOKUP, INDEX and MATCH are some of the most well-known (and most useful) functions in Excel which are used to to return data from other locations in worksheets WHY SHOULD YOU ATTEND If you handle large amounts of data in Excel, this webinar on how to use VLOOKUP, MATCH and INDEX will help you tremendously. The training will be delivered using Excel 2016 for Windows although for users of earlier versions, most of the functionality is available in Excel 2010 and Excel 2013. AREAS COVERED Learning the arguments in the VLOOKUP function Understanding the importance of absolute references within many lookup functions VLOOKUP function in Excel for performing approximate matches Simplifying multiple-field look-ups with concatenation (combining fields into a single cell) Discovering how to use wildcards and multiple criteria within lookup formulas Using V...