data validation
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Validation

Data Validation

resolvedResolved · Low Priority · Version 2007

replyReply Thu 1 May 2008, 20:41Delegate Patricia said...

Patricia has attended:
Excel Advanced course

Data Validation

What is data Validation?

For upcoming training course dates see: Pricing & availability

replyReply Sun 4 May 2008, 16:17Trainer Cress said...

RE: Data Validation

It a way of ensuring only a set series of data (usually from a list box) is enetered into a cell. If the value is always Yes or No then you want them to choose either option rather than typeing Yes rather than putting Y, Yeah or Correct. The following tutorial might help you understand it:
http://www.contextures.com/xlDataVal01.html

 

Please browse our web site to find out more about
excel 2003 visual basic intermediate course and other Microsoft training courses.

Excel tip:

Date and time

CTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard