Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Checking Data Entry - 463 - Learn Excel from MrExcel Podcast

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
1,103
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on May 18, 2009

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.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Category:

People & Blogs

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (2)

Sign In or Sign Up now to post a comment!
  • Is there no contest for 2010?

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more