Excel Data Validation For Beginners

About Course

  • 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.
Requirements  
  1. Users should be familiar with Microsoft Excel.
  2. Users should be familiar with basic functions in Excel such Sum and Count.

What I will learn?

  • Introduction Data
  • Validation
  • Creating Data Validation Lists
  • Data and Time Controls
  • Text Controls
  • More Custom formula Tricks
  • More about Data Validation
Free

Material Includes

  • Self-paced learning
  • Video tutorials
  • Unlimited access
  • Recognised certification

Course Detail

  • Videos : 25
  • Exercise : 04
  • Hours : 1 Hours 22 Minutes
  • Level : Intermediate
  • Certification : Free

Platform : Edx