Call us today: 0800 028 3045
NEW! Microsoft Excel – Data Validation Online Course
Find out more about our Online Training Courses
Is it right for me?
Ever come across drop down lists in spreadsheets? Ever wondered how you can control what people enter into worksheets you send out so that you get consistency of data? Then this 1 hour online trainer-led session is for you.
What will I get out of it?
By the end of the course you will know:
- How to apply rules directly to cells to control data input
- How to create drop down lists in cells to restrict data entry options
- How set up rules making cell values dependent on values in other cells
- How to display user tips
- How to warn or prevent users from entering invalid data
- How to create lists that change according to data in another cell
Related courses in our range
What does it cover?
Creating Drop Down Lists
- Creating lists manually
- Creating lists from existing data in the same worksheet
- Creating lists from data in other worksheets
Creating Rules to Control Data Entry
- Whole numbers
- Decimals
- Dates
- Time
- Text length
- Custom rules
Creating User Prompts and Messages
- Automatically display user tips and prompts
- Automatically warn or prevent users from entering invalid data
Creating Linked Drop Down Lists
- Using the INDIRECT function to create linked drop down lists
Course Summary
Send to a colleague
Please enter details below and click 'submit'
Tailor this course
If you are interested in this course but would like it tailored to your specific needs, contact Karen Osborn on 0800 028 3045.
Alternatively, enter your details below and one of our team will contact you.
Thales Training & Consultancy is a highly successful training services company based in Crawley. We help companies to develop advantage through learning and development. Highly trusted by leading enterprises, we deliver a full range of dedicated training solutions that enable organisations to achieve key business goals. The 4 core services we offer are Training Courses, Supply Management, Bespoke Services and Managed Services. Our successful partnerships with clients prove that the delivery and management of the right training and development can significantly enhance the pursuit of business excellence.
