Data validation stops wrong entries before they reach your analysis. A date column with text in it, or a product name with a typo, can quietly break a pivot table.
How to set it up
- Select the cells you want to control.
- Open Data, then Data Validation.
- Choose a rule: a list, a whole number, a date range or a custom formula.
- Add an input message and an error alert so the next person knows what to enter.
Useful rules for analysts
- A drop-down list of allowed categories, such as North, South, East and West.
- A date rule that accepts only dates after a set start.
- A custom rule that stops duplicate order IDs.
Validation prevents new errors but does not fix old ones. Clean the existing data first, then apply the rules. Read Excel formulas every data analyst should know next, or book a free demo class. Ask a counsellor for the current course schedule.

Conditional Formatting in Excel: Highlight What Matters - ScholarLogic
[…] the data is clean, read data validation in Excel and the formulas every analyst should know. Book a free demo class, and ask a counsellor for the […]