Excel Data Validation For beginners

Eliminate bad data by controlling the inputted data on your workbook!
Rating: 4.3 out of 5 (910 ratings)
19,757 students
Excel Data Validation For beginners
Rating: 4.3 out of 5 (910 ratings)
19,757 students
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 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 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
Course content
6 sections • 26 lectures • 1h 22m total length
  • Introduction
    01:48
  • Data Validation for Integers and Decimals
    04:36
  • Lists Intro
    03:41
  • Changing the position of an Item in a list and adding new items
    03:32
  • Creating Hierarchies 1
    06:17
  • Creating Hierarchies 2 - Adding tables to the mix
    04:56
  • Creating an Input Message
    02:22
  • Creating a custom error alert
    03:35
  • Data Validation Lists-Exercise
    00:51
  • Simple Date Controls
    02:05
  • Custom Formula Date controls 1
    04:05
  • Custom Formula Date Controls 2
    05:39
  • Simple Time Controls
    03:39
  • Custom Formula Time Controls
    07:16
  • Date and Time Controls - Exercise
    01:19
  • Simple Text Controls
    00:53
  • Custom Text Controls - Preventing Extra Spaces in entries
    03:56
  • Custom Text controls -Making sure entries have a certain prefix
    06:14
  • Exercise - Text Controls
    00:40
  • Preventing Duplicates
    05:46
  • Limiting the Total
    01:44
  • Custom formula tricks - Exercise
    00:40
  • Locating Data validation rules
    01:34
  • Data Validation Shortcomings
    02:23
  • Locating Violations
    03:06
  • More from Abdelrahman!
    00:21

Instructor
Founder|ExcelBonanza.com|20000+ Students|164 Countries
Abdelrahman Abdou
  • 4.3 Instructor Rating
  • 1,524 Reviews
  • 39,579 Students
  • 4 Courses

Hi, I'm Abdelrahman and I'm an Excel Lover :)

I have a Bachelor's Degree in Chemical Engineering.

I Worked as MIS and Reporting Analyst in Vodafone International Services In Egypt for 3.5 years.

I have more than 5 Years of Experience in Excel including building Dashboards and VBA.

I have created numerous dashboards in my company and automated tens of reports.

I love learning new things and my main learning method is through self-learning by watching video tutorials.

I love Excel and I'm trying to share the love with everyone else !