Microsoft Excel - Data Validation Techniques
Duration: 60 Minutes
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.
- 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?
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.
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.
- 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
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
By Richard Erschik
Date: Aug. 4, 2026
By David Nettleton
Date: Aug. 4, 2026
By Dr. Susan Strauss
Date: Aug. 4, 2026
By Marcia Zidle
Date: Aug. 4, 2026
By Ms. Michael Redmond
Date: Aug. 5, 2026
By Diane L. Dee
Date: Aug. 5, 2026
By Pete Tosh
Date: Aug. 7, 2026
By William Mack Copeland
Date: Aug. 11, 2026
By William J. Rothwell
Date: Aug. 12, 2026
By John Fetzer
Date: Aug. 12, 2026
By Erica Chisolm
Date: Aug. 12, 2026
By Dr. Susan Strauss
Date: Aug. 12, 2026
By Bruce Lee
Date: Aug. 13, 2026
By Allen Evitts
Date: Aug. 14, 2026
By Mark Schwartz
Date: Aug. 14, 2026
By Lesley Crook
Date: Aug. 17, 2026
By Kathryn E. Strachan
Date: Aug. 17, 2026
By Mark Gorkin
Date: Aug. 18, 2026
By Steven G. Meilleur
Date: Aug. 18, 2026
By Paul Pelletier
Date: Aug. 19, 2026
By Edlyn McGarity
Date: Aug. 19, 2026
By Michael Healey
Date: Aug. 19, 2026
By Ronald L. Adler
Date: Aug. 20, 2026
By Dr. B. Lynn Ware
Date: Aug. 21, 2026
By Beverly Beuermann-King
Date: Aug. 24, 2026
By Marcia Zidle
Recorded Session
By Marcia Zidle
Recorded Session
By Erica Chisolm & Vanessa Hardiman
Recorded Session
By Paul Pelletier
Recorded Session
By Michael Healey
Recorded Session
By Ronald L. Adler
Recorded Session
By David Nettleton
Recorded Session
By Paul J. Cline
Recorded Session
By Audrey Halpern
Recorded Session
By David Nettleton
Recorded Session
By Dev Strischek
Recorded Session
By Carolyn Troiano
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Diane L. Dee
Recorded Session
By Cathy Horwitz
Recorded Session
By Melveen Stevenson
Recorded Session
By Bob Verchota
Recorded Session
By Don Phin
Recorded Session
By Melveen Stevenson
Recorded Session
By Richard E Cascarino
Recorded Session
By Paul J. Cline
Recorded Session
