Microsoft Excel Data Validation Tools - Keep out Bad Data from the Start, Simplify Data Entry and Ensure Accuracy with this Powerful Feature

Duration: 90 Minutes
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. Using Excel's data validation tools you can also 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.
Microsoft Excel Data Validation Tools
Instructor: Dennis Taylor
Product ID: 503086
Objectives of the Presentation
  • 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
Why Should you Attend
Excel users who need these capabilities will benefit: control the accuracy of data being entered into Excel worksheets; reduce data entry time and ensure consistency via pick lists; identify the location of Data Validation rules in existing data; insure the uniqueness of data within specified ranges.

Areas Covered
  • 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, and related fields, marketing, sales, Investments, Pharmacy, Accounts, Audit, Credit Unions and Mortgage.
$300
Recorded Session for one participant
Get life time access with download option!
Book this course
Pay Now
  $450.00 Training CD
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
  $550.00 Training USB Flash Drive
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
For multiple location please contact our customer care team +1-510-857-5896.
How it works
Live Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • The webinar joining link, username and password for joining the webinar will be updated on your OCP Account 24 hours prior to the webinar
  • Presentation handouts in Downloadable PDF format will be updated on your OCP Account 24 hours prior to the live session
  • Login to the audio conference on the scheduled date and time
  • Get answers to your queries through interactive Q&A sessions via chat at the end of the session
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account 24 hours after the completion of the session
  • Please let us know your thoughts and views at the end of the webinar, your valuable feedback will help us improve
Recorded Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • Upon purchase of the recorded session a link will be updated on your OCP Account within 24 hours
  • Please click on the link to access the Recorded Session
  • Presentation handouts in downloadable PDF format will be updated on your OCP Account within 24 hours of the purchase of the product
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account after 48 hours of the product Purchase
  • Please share your valuable Feedback at the end of the session
Instructor Profile:
Dennis Taylor has over 25 years of experience working with spreadsheet programs as an author, speaker, seminar leader, and facilitator. Since the mid-90's, he has been the author/presenter of numerous Excel video and online courses and has travelled throughout the US and Canada presenting hundreds of seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented nearly 600 Excel webinars to diverse audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado.
View More