Excel Data Validation For beginners – Free Udemy Courses
Eliminate bad data by controlling the inputted data in your workbook!
What you’ll learn
Excel Data Validation For beginners – Free Udemy Courses
- Build data validation rules for numbers, dates and times, texts
- Build Cascading data validation lists.
- Use custom formulas for data validation
Requirements
-
Users should be familiar with Microsoft Excel.
-
Users should be familiar with basic functions in Excel such as Sum and Count.
Description
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 control 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 in their workbooks.
Who this course is for:
- Excel users who want to learn how to control inputs on their workbooks using data validation
Add Comment