Data Validation a back door to Master Excel

Chapter One- The Basics of Data Validation
	01- Types of Data Validation
	02- Input Message
	03- Error Message
	04- Allow Typing in a Data Validation Range
Chapter Two- Custom Data Validation
	01- Prevent Duplicates
	02- Unique Values with Exception
	03- Allow Unique Records Only
	04- Allow Only Specific Values
	05- Prevent Some Characters in A Data Validation Range
	06- Allow Only Multiples
	07- Allow Only Percentages
	08- Preset Sum Value for a Data Validation Range
	09- Must Begin With
	10- Must Contain - Cannot Contain
	11- Case Sensitive Data Validation
	12- Weekdays or Weekends Validation
	13- Date in The Past Validation
	14- Allow a Date in the Next 30 Days
	15- Allow a Date in a Date Range
	16- Only Numbers are Accepted in a Range
	17- Allow Only Text in a Data Validation Range
	18- Prevent Extra Spaces in a Data Validation Range
	19- Conditional Postal Code in a Data Validation Range
	20- Cell Dependency with Data Validation
Chapter Three- List Data Validation
	01- Creating a Basic Drop List
	02- Create Multiple Drop Lists
	03- Prepare for Data Validation by Creating a Unique List
	04- Adding Items to a List
	05- Removing Blanks
	06- Changing Functions with a Drop List
	07- Conditional Drop List
	08- Indenting Items in a Drop List
Chapter Four - Advanced Drop-Down List
	01- Create a Searchable Drop list
	02- Creating a Diminishing Drop list
	03- Creating Dependent Drop list
	04- Randomizing Items in a Drop List with every use
	05- Data Validation with Wild Cards
	06- Conditional Formatting On/Off with a Drop List
Chapter Five- Data Validation with Useful Codes
	01- Resetting Values for Dependent Drop Lists
	02- Prevent Overwriting Your Drop Lists
	03- Select Multiple Options from a Drop List
	04- Improve legibility of Items in a Drop List
	05- Switching Macros with a Drop List
	06- Changing Worksheet name with a Drop List
	07- Data Validation with Advanced Filter
Chapter Six- Power Query and Data Validation
	01- Change Source Data or Switch Criteria
	02- Extract Specific Folder Contents with a Drop List
Chapter Seven- Power Pivot and Data Validation
	01- Data Validation Linked to Data Model (CUBEVALUE)
Chapter Eight- Data Validation Tips and Tricks
	01- Locating Data Validation in the Worksheet.
	02- Copying or Overwriting Data Validation
	03- Clearing and locking Data Validation
	04- Shortcuts, Limit and Similarity to Conditional Formatting
	05- Avoid Excess Data Validation
Chapter Nine- Data Validation with Rich Data Types
	01- Geography Data Type with Data Validation
Chapter Ten- Data Validation for Impressive Charts and Slicers
	01- Slicers vs Data Validation and Advanced Filter
	02- Switching Charts with a Drop List
Last words
Download The Exercise Files