Microsoft Excel - Data Validation Techniques

Learn valuable insights and strategies from industry experts.

  • Expert-led Training
  • Industry Best Practices
  • Practical Implementation
  • Real-world Scenarios
Tom Chandler

Speaker: Tom Chandler

Download Brochure Set Reminder
HR Compliance Webinar Image
Date
26 August, 2026 (Wednesday)
Time
10:00 AM PDT | 01:00 PM EDT
Duration
60 Minutes

Overview


Have you ever received a spreadsheet where users entered a date in a phone number column? Or maybe they entered an employee's birthdate with the current year? Or did then misspell a state abbreviation? Did you know you can prevent these errors using Excel's Data Validation feature. That is what this course is all about.

Whether you are a new Excel user, a data analyst, spreadsheet guru, business professional, or simply someone looking to create more user-friendly Excel files, this course will provide you with the knowledge and tools you need to validate the data and make the spreadsheet more user friendly.

Area Covered

  • What is Data Validation?
  • What are the benefits of using Data Validation?
  • How can I insist that a user enter a whole numbers, decimals, dates, times?
  • How can I set up rules such as no negative numbers, or no future dates?
  • How can I display and restrict inputs to values in a dropdown menu?
  • How can I create a dependent drop down (e.g. Category ? Subcategory)
  • How can I reject malformed phone numbers, SSN, and zip codes?
  • How can I set up a rule based on a formula?
  • How can I display an input prompt so users know what to enter?
  • How can I display a friendly message when a user enters invalid data?
  • How can I mark data that is invalid?

Why Should You Attend

Have you ever received a spreadsheet where users entered a date in a phone number column? Or maybe they entered an employee's birthdate with the current year? Or did then misspell a state abbreviation? Did you know you can prevent these errors using Excel's Data Validation feature. That is what this course is all about.

Whether you are a new Excel user, a data analyst, spreadsheet guru, business professional, or simply someone looking to create more user-friendly Excel files, this course will provide you with the knowledge and tools you need to validate the data and make the spreadsheet more user friendly.

Who Will Benefit?

  • Office Workers
  • Administrators
  • Data Analysts
  • Managers of All Levels
  • Business Owners
  • CEO's
  • CFO's
  • CTO's
  • Salespeople
  • Trainers
  • Bankers
  • Anybody who needs to enhance their spreadsheets to collect more accurate data

Speaker

Tom Chandler started teaching Excel and other Microsoft Office (now Microsoft 365) applications in Silicon Valley in 1996. In 2010 he started a computer training and consulting company named TechMentors. He has had the pleasure of teaching and consulting with many small and large companies including Stanford Medical Center, Visa, Seagate, and the City of San Jose.
Tom received his Bachelors of Science in Finance and Accounting from Brigham Young University. He also received a MBA with a concentration on Computer/Information Technology Administration and Management from Western Governors University.
Tom and his wife, Madeline, are very family oriented. They have seven (7) children and currently thirteen (13) grandchildren with two more on the way. Consequently in 2020 Tom and Madeline moved to northern Utah so they could be near many of their children and grandchildren.

Upcoming Webinars

View All Webinars