Learn Excel Episode 463: Checking Data Entry

Posted in Companies, Podcasts on July 07, 2008


Learn Excel Episode 463: Checking Data Entry

The first entries in the NCAA office pool are starting to come in and the commissioner of the NCAA pool will have to key your entries from the faxed USA Today bracket into the spreadsheet. In the MrExcel spreadsheet, concatenation formulas help to make sure that the teams keyed for each player are correct. Episode 463 shows you how to use FIND, ISERR, and IF functions to check to make sure your data entries are in a list of valid values.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel