In my younger years, I had a number of data entry related jobs. The constant repetition of entering numbers and values were always prone to some mistakes. Thank goodness for programming that targeted and trapped those mistakes during the data entry process.
Excel was created to handle a large amount of data. Beginning with Excel 2007, it has 1,048,576 rows and 16,384 columns. Data entry of large worksheets will be prone to mistakes along the way. Good news, Excel has a means of targeting and trapping those mistakes. This post will showcase the data validation features found in Excel 2010.
The entry …read more