You can set Excel up to allow you or someone else to enter data that meets criteria that you set.
For example, on an order form, the quantity to be ordered may be in a particular range. Say between 10 and 20 units. You can set this up so that if the person entering the data puts a number in that is below 10 or above 20 Excel will do any of several things:
Display an ErrorMessage and allow you to continue
Display an Error Message and stop you from entering invalid data
Remember, we can supply all of your IT Training needs - we run Training Surgeries, where your staff can get targeted one to one support or we can run full day training courses for your business or organisation.
Shelley Fishel is the Founder and Managing Director of The Training Surgery, an IT training company that focuses on the needs of the clients. Training in your office, with your documents focussed on your...