Excel Data Validation For beginners

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Data Validation for Integers and Decimals

Chapter 2: Creating Data Validation lists

Lecture 1: Lists Intro

Lecture 2: Changing the position of an Item in a list and adding new items

Lecture 3: Creating Hierarchies 1

Lecture 4: Creating Hierarchies 2 – Adding tables to the mix

Lecture 5: Creating an Input Message

Lecture 6: Creating a custom error alert

Lecture 7: Data Validation Lists-Exercise

Chapter 3: Date and Time Controls

Lecture 1: Simple Date Controls

Lecture 2: Custom Formula Date controls 1

Lecture 3: Custom Formula Date Controls 2

Lecture 4: Simple Time Controls

Lecture 5: Custom Formula Time Controls

Lecture 6: Date and Time Controls – Exercise

Chapter 4: Text Controls

Lecture 1: Simple Text Controls

Lecture 2: Custom Text Controls – Preventing Extra Spaces in entries

Lecture 3: Custom Text controls -Making sure entries have a certain prefix

Lecture 4: Exercise – Text Controls

Chapter 5: More Custom Formula Tricks

Lecture 1: Preventing Duplicates

Lecture 2: Limiting the Total

Lecture 3: Custom formula tricks – Exercise

Chapter 6: More about Data Validation

Lecture 1: Locating Data validation rules

Lecture 2: Data Validation Shortcomings

Lecture 3: Locating Violations

Lecture 4: More from Abdelrahman!