Excel 101: Lookup Functions

Authored by David Ringstrom
About this Course
Topics covered include: Improving the integrity of spreadsheets with Excel's VLOOKUP function; Simplifying multiple-field lookups with concatenation (combining fields into a single cell); Understanding situations that cause Excel's VLOOKUP function to return #REF! instead of a value; Future-proofing VLOOKUP by using Excel's Table feature versus referencing static ranges; Improving the integrity of spreadsheets with Excel's VLOOKUP function; Utilizing Excel's IFERROR function to display alternate values when VLOOKUP returns an error; Learning what types of user actions can trigger #REF! errors; Improving the integrity of spreadsheets with Excel's VLOOKUP function; Viewing two worksheets at the same time within the same workbook; Implementing Data Validation to ensure users make choices that VLOOKUP will recognize as valid; Improving the integrity of spreadsheets with Excel's VLOOKUP function; Reconstructing spreadsheet data to use VLOOKUP as a better alternative to nesting IF functions. Upon completing this course, you should be able to: Identify the location of Excel's Arrange All command; Define the purpose of Excel's IFERROR worksheet function; Identify the number of criteria pairs that you can specify in the MAXIFS function.
$ 36.00
Course is unavailable for purchase.
NASBA Field of Study
Computer Software & Applications
Level
Basic
CPE Credits
2.0
Prerequisites
None
Last Updated
07/30/2018
14302