Excel Data Validation For beginners

Eliminate bad data by controlling the inputted data on your workbook!
Free tutorial
Rating: 4.7 out of 5 (1,296 ratings)
29,854 students
1hr 23min of on-demand video
English [Auto]

Build data validation rules for numbers, dates and times, texts
Build Cascading data validation lists.
Use custom formulas for data validation


  • Users should be familiar with Microsoft Excel.
  • Users should be familiar with basic functions in Excel such Sum and Count.


This course teaches students how to use the Data Validation feature in Excel to create rules that can control the inputs to Excel Workbooks.

This helps users eliminate bad data inputted by other people.

Students will learn how to controls numbers such as Integers and Decimals inputted by other users.

Students will learn techniques for creating data validation lists to restrict inputs to a list of values.

Students will learn how to apply date and time controls to restrict date and time inputs on their workbooks.

Students will learn how to apply text controls to control text inputs on their workbooks.

Who this course is for:

  • Excel users who want to learn how to control inputs on their workbooks using data validation


Founder|ExcelBonanza.com|40000+ Students|164 Countries
Abdelrahman Abdou
  • 4.7 Instructor Rating
  • 1,296 Reviews
  • 50,015 Students
  • 1 Course

Abdelrahman Abdou is a Microsoft Certified Trainer (MCT) with over 8 years of Experience in Data Analytics, Reporting, and Business Intelligence in the largest Telecom companies in Egypt & Canada.

Abdelrahman is passionate about learning & teaching Excel & Power BI and loves simplifying information for his students and audience.

Abdelrahman loves watching football, playing video games, traveling, and going to the gym.

Top companies trust Udemy

Get your team access to Udemy's top 26,000+ courses