List: Data Validation in Excel | Curated by Dr. Alvin Ang

Sep 20, 2023

10 stories

1 save

Data Validation in ExcelData Validation = Prevent users from entering wrong values / Limit the inputs of users / Ensure that users ONLY enter certain values into a cell.

https://www.alvinang.sg/publications
Dr. Alvin Ang
Step by Step: Creating a Dependent Drop Down List in ExcelPart 9 of Data Validation in Excel by Dr. Alvin Ang
Sep 20, 2023
Sep 20, 2023
Part 8
Dr. Alvin Ang
Step by Step: Creating a Dynamic Drop Down List in ExcelPart 8 of Data Validation in Excel by Dr. Alvin Ang
Sep 20, 2023
Sep 20, 2023
Part 7
Dr. Alvin Ang
Step by Step: Creating a Drop Down List in ExcelPart 7 of Data Validation in Excel by Dr. Alvin Ang
Sep 20, 2023
Sep 20, 2023
Part 6
Dr. Alvin Ang
Step by Step: Preventing User from Keying in Wrong Product Code FormatsPart 6 of Data Validation in Excel by Dr. Alvin Ang
Sep 20, 2023
Sep 20, 2023
Part 5
Dr. Alvin Ang
Step by Step: Preventing User from Keying in Duplicate Entries in ExcelPart 5 of Data Validation in Excel by Dr. Alvin Ang
Sep 20, 2023
Sep 20, 2023
Part 4
Dr. Alvin Ang
Step by Step: Preventing User from Keying In a Disallowed Budget in ExcelPart 4 of Data Validation in Excel by Dr. Alvin Ang
Sep 20, 2023
Sep 20, 2023
Part 3
Dr. Alvin Ang
Step by Step: Preventing User from Keying In Disallowed Dates in ExcelPart 3 of Data Validation in Excel by Dr. Alvin Ang
Sep 20, 2023
Sep 20, 2023
Dr. Alvin Ang
Step by Step: Rejecting Invalid Dates in ExcelPart 2 of Data Validation in Excel by Dr. Alvin Ang
Sep 20, 2023
Sep 20, 2023
Part 1
Dr. Alvin Ang
Step by Step: Setting Up and Deleting Data Validation in ExcelPart 1 of Data Validation in Excel by Dr. Alvin Ang
Sep 20, 2023
Sep 20, 2023
Dr. Alvin Ang
Data ValidationData Wrangling with Excel — Part 4 by Dr. Alvin Ang
May 12, 2023
May 12, 2023

Data Validation in Excel

Data Validation = Prevent users from entering wrong values / Limit the inputs of users / Ensure that users ONLY enter certain values into a cell. https://www.alvinang.sg/publications

Step by Step: Creating a Dependent Drop Down List in Excel

Part 9 of Data Validation in Excel by Dr. Alvin Ang

Step by Step: Creating a Dynamic Drop Down List in Excel

Part 8 of Data Validation in Excel by Dr. Alvin Ang

Step by Step: Creating a Drop Down List in Excel

Part 7 of Data Validation in Excel by Dr. Alvin Ang

Step by Step: Preventing User from Keying in Wrong Product Code Formats

Part 6 of Data Validation in Excel by Dr. Alvin Ang

Step by Step: Preventing User from Keying in Duplicate Entries in Excel

Part 5 of Data Validation in Excel by Dr. Alvin Ang

Step by Step: Preventing User from Keying In a Disallowed Budget in Excel

Part 4 of Data Validation in Excel by Dr. Alvin Ang

Step by Step: Preventing User from Keying In Disallowed Dates in Excel

Part 3 of Data Validation in Excel by Dr. Alvin Ang

Step by Step: Rejecting Invalid Dates in Excel

Part 2 of Data Validation in Excel by Dr. Alvin Ang

Step by Step: Setting Up and Deleting Data Validation in Excel

Part 1 of Data Validation in Excel by Dr. Alvin Ang

Data Validation

Data Wrangling with Excel — Part 4 by Dr. Alvin Ang

Dr. Alvin Ang