Data Validation in Excel
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:
Data Validation in Excel 2007 and Excel 2010
For more handy tips for working with Microsoft Office on either the Windows or the Mac platforms sign up for our weekly newsletter at:
http://www.thetrainingsurgery.co.uk/tips/default.aspx click the Register Now button and you will receive a weekly email with that week's tip.
Drop me a line if you would like me to write a tip especially for you. Email shelley.fishel@thetrainingsurgery.co.uk with the subject line TIPS.
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.
Call 0800 088 7346 for more information.
Have a brilliant week.
Shelley
follow me on twitter @shelleyfishel
