This video illustrates how Data Validation can return an error message when incorrect data is entered. For example, if we enter that an NBA team scored 1000 points, we receive an error message. We also show how to create a drop-down list from which a user selects an input.
There is only one file for this video. The first file necessary is a blank workbook. The included file is the finished file and is for reference.
Excel With Wayne is an online Microsoft Excel Training Course taught by Dr. Wayne Winston. Dr. Winston is the world’s foremost Microsoft Excel Expert that teaches at some of the world’s largest organizations including Microsoft and government organizations such as the Navy and Army.
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.
