Have you ever asked five people to enter a list of your Customers into an Excel Workbook? Were you surprised to find the number of (sometimes creative) ways that a simple customer list was entered? The bigger question is – How many hours did you waste trying to edit and consolidate that Customer List? Are you looking for a better way to control data entry? A way that will save you time and maintain consistency of information? Then watch this short video lesson. I demonstrate three ways to do this: 1) Data Validation using a List from a Named Range 2) Named Constants 3) MS Office’s AutoCorrect Options I invite you to visit my website – www.thecompanyrocks.com/excels – to view all of my lessons, get step-by-step instructions and download Excel Practice files. Danny Rocks www.thecompanyrocks.com