Mastering Excel Data Validation Rules

This Excel 2013 training program will discuss the scope and limitations of Data Validation rules. It will also offer guidance on how to use Data Validation to control simple numerical value limits, to control text length limits, and more.

Why Should You Attend:

With Excel's data validation tools, you can control how users input data into workbooks and ensure data is entered consistently and accurately. You can control dates, times, and the length of the data they enter, or simply provide a list of acceptable choices to eliminate any possible mistakes.
This webinar will enumerate how you can control data entry by formulas, provide dropdown lists that eliminate time-consuming and error-prone typing mistakes, control numeric data based on date and time constraints, and identify unwanted data by applying data validation rules on existing data by using Excel’s Data Validation tools.

Learning Objectives:

Understand the scope and limitations of Data Validation rules
Use Data Validation to control simple numerical value limits
Use Data Validation to control text length limits
Use Data Validation for setting limits based on date and time constraints
Use Data Validation on existing data to reveal inappropriate or unwanted data
Use Data Validations to set up pick lists that eliminate typing
Use formulas in Data Validation rules to eliminate data entry errors

Areas Covered in the Webinar:

Testing for whole numbers and decimals
Using the Input Message box and the Error Alert Box
Sequencing and placing lists
Creating two-tier pick lists
Setting date and time limitations
Limiting text length
How to locate Data Validation rules
How to create a Data Validation rule requiring entries to be unique

Who Will Benefit:

This webinar will provide valuable assistance to nearly all Excel users - it is not industry specific, but is perhaps more widely used in:
Banking
Finance
Marketing
Sales
Investments
Pharmacy
Accounts and Audit
Credit Unions, Mortgage, etc.

Instructor Profile:

Dennis Taylor has taught thousands of Excel seminars and classes since the early 90’s, is the author/presenter of over 500 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses both for online and DVD distribution.

For Registration - http://www.complianceonline.com/excel-2013-data-validation-tools-webinar-training-704093-prdw?channel=worldconferencecalendar

Note: Use coupon code NB5SQH8N and get 10% off on registration.