Episode # 463 - Checking Data Entry
Sponsored by
Check out this book for more tips
similar to this lesson!
Tuesday, March 13, 2007
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.
You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 4 minutes to learn this lesson now with our free video!
Tags/Keywords for this video: Formulas
More Excel Video Lessons
If you like this video, there are hundreds of 2-5 minute videos available here:
- Excel training videos about Charts
- Excel training videos about VBA
- Excel training videos about Pivot Tables
- Excel training videos about Data Analysis
- Excel training videos about Formulas
- Excel training videos about Formatting
- Excel training videos about Printing
- Excel training videos about Excel 2007
- Excel Video Lessons Index
