Making the Most of Excel – Data Validation
Last week I discussed using Excel effectively, in order to ensure it best serves your small business. I’m going to expand on that today, giving you some ideas about how you can use Excel features to validate the data that is being entered into your Excel sheet. Are you capturing data in Excel, but finding that the quality of that data isn’t great? Maybe someone types in their name in the phone number field, or they type a date in a field where you’re expecting a dollar amount