Apply Data Validation in Excel Resources

Save time by avoiding repetition and errors Excel is great for lists; sales figures, staff rota’s, stock control, to name a few. But an easy trap to fall into is repetitive error prone data-entry that leads to inaccurate business reporting and lost time in troubleshooting. If you create a drop-down list in Excel, you can avoid […]

Anything that can cut down the time it takes to add data and improve accuracy is good in my book. Creating a drop down list isn’t as tough as I thought, so here is how to set up a drop down list using Data Validation. I have a set of customers, that come under four […]