دانلود کتاب 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