Excel Data Validation For beginners
4.4 (26 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,700 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Data Validation For beginners to your Wishlist.

Add to Wishlist

Excel Data Validation For beginners

Eliminate bad data by controlling the inputted data on your workbook!
4.4 (26 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,700 students enrolled
Created by Abdelrahman Abdou
Last updated 7/2017
English
Price: Free
Includes:
  • 1.5 hours on-demand video
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Build data validation rules for numbers, dates and times, texts
  • Build Cascading data validation lists.
  • Use custom formulas for data validation
View Curriculum
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 is the target audience?
  • Excel users who want to learn how to control inputs on their workbooks using data validation
Students Who Viewed This Course Also Viewed
Curriculum For This Course
25 Lectures
01:22:37
+
Introduction
4 Lectures 12:21
Introduction
01:48

In this lecture,students will learn how to use data validation to validate Integer and decimal inputs.

Data Validation for Integers and Decimals
04:36

In this lecture,students will learn how to create a custom input message for a data validation rule.

Creating an Input Message
02:22

In this lecture, students will learn how to create a custom error alert for a data validation rule.

Creating a custom error alert
03:35
+
Creating Data Validation lists
5 Lectures 19:17

In this lecture, students will have an introduction on creating lists using data validation in Excel.

Lists Intro
03:41

In this lecture, students will learn how to change the position of an item in a data validation list and add new items.

Changing the position of an Item in a list and adding new items
03:32

Students will learn how to create Hierarchies using the INDIRECT function and data validation lists.

Creating Hierarchies 1
06:17

Students will learn how to use tables for creating data validation lists.

Creating Hierarchies 2 - Adding tables to the mix
04:56

Exercise for using Data validation lists. The exercise worksheet in the workbook attached to the first lecture on the data validation section and the answer workbook is attached to this lecture.

Data Validation Lists-Exercise
00:51
+
Date and Time Controls
6 Lectures 24:03

Students will learn how to create simple data controls in using Data Validation. Workbook containing examples and exercises is attached to this video.

Simple Date Controls
02:05

Students will learn how to create custom formula data controls using data validation.

Custom Formula Date controls 1
04:05

Part 2 of learning how to create custom formula date controls.

Custom Formula Date Controls 2
05:39

Students will learn how to create simple time controls using data validation.

Simple Time Controls
03:39

Students will learn how to create custom time controls using data validation.

Custom Formula Time Controls
07:16

Exercise for the date and time controls

Date and Time Controls - Exercise
01:19
+
Text Controls
4 Lectures 11:43

Students will learn how to create simple text controls using data validation.

Simple Text Controls
00:53

Students will learn how to prevent Extra spaces in inputs using custom text controls in Data Validation.

Custom Text Controls - Preventing Extra Spaces in entries
03:56

Custom Text controls -Making sure entries have a certain prefix
06:14

Exercise for using Text controls in Data Validation.

Exercise - Text Controls
00:40
+
More Custom Formula Tricks
3 Lectures 08:10

Students will learn how to prevent duplicate entries using data validation.Workbook containing examples and exercise is attached to this video.

Preventing Duplicates
05:46

Students will learn how to limit entries so that they can't exceed a certain total.

Limiting the Total
01:44

Exercises for the more data valdation tricks section.

Custom formula tricks - Exercise
00:40
+
More about Data Validation
3 Lectures 07:03

Students will learn how to locate data validation rules on their worksheets.Example workbook is attached to this lecture

Locating Data validation rules
01:34

Explaining the shortcomings of data validation in Excel.

Data Validation Shortcomings
02:23

Students will learn how to locate data validation violations on their worksheets.

Locating Violations
03:06
About the Instructor
Abdelrahman Abdou
4.5 Average rating
313 Reviews
15,670 Students
4 Courses
Founder|ExcelBonanza.com|15000+ Students|148 Countries

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 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 !