Excel Data Validation For beginners

Name: Excel Data Validation For beginners
Rating: 4.7 (1607 reviews)

Eliminate bad data by controlling the inputted data on your workbook!

Last updated 8/2023

English

What you'll learn

6 sections • 26 lectures • 1h 22m total length

Introduction1:48
Data Validation for Integers and Decimals4:36
In this lecture,students will learn how to use data validation to validate Integer and decimal inputs.

Lists Intro3:41
In this lecture, students will have an introduction on creating lists using data validation in Excel.
Changing the position of an Item in a list and adding new items3:32
In this lecture, students will learn how to change the position of an item in a data validation list and add new items.
Creating Hierarchies 16:17
Students will learn how to create Hierarchies using the INDIRECT function and data validation lists.
Creating Hierarchies 2 - Adding tables to the mix4:56
Students will learn how to use tables for creating data validation lists.
Creating an Input Message2:22
In this lecture,students will learn how to create a custom input message for a data validation rule.
Creating a custom error alert3:35
In this lecture, students will learn how to create a custom error alert for a data validation rule.
Data Validation Lists-Exercise0:51
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.

Simple Date Controls2:05
Students will learn how to create simple data controls in using Data Validation. Workbook containing examples and exercises is attached to this video.
Custom Formula Date controls 14:05
Students will learn how to create custom formula data controls using data validation.
Custom Formula Date Controls 25:39
Part 2 of learning how to create custom formula date controls.
Simple Time Controls3:39
Students will learn how to create simple time controls using data validation.
Custom Formula Time Controls7:16
Students will learn how to create custom time controls using data validation.
Date and Time Controls - Exercise1:19
Exercise for the date and time controls

Simple Text Controls0:53
Students will learn how to create simple text controls using data validation.
Custom Text Controls - Preventing Extra Spaces in entries3:56
Students will learn how to prevent Extra spaces in inputs using custom text controls in Data Validation.
Custom Text controls -Making sure entries have a certain prefix6:14
Exercise - Text Controls0:40
Exercise for using Text controls in Data Validation.

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.

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