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
This Site uses cookies to store information on your device. Some are essential to make our Site work properly; others help us improve the visitor and user experience. By using the Site, you consent to the placement of these cookies. Read our privacy policy to learn more.