This is a practical example of combining IF, AND, and date functions.

🔟 You receive a messy Excel file. What steps would you take before analyzing it?

Sample Answer:

I would first understand the structure and business meaning of the data.

Then I would check:

1. Duplicate records

2. Missing values

3. Incorrect data types

4. Inconsistent text

5. Invalid dates

6. Extra spaces

7. Outliers or unusual values

8. Incorrect or inconsistent categories

For example, "India", "india" and " INDIA " may need to be standardized.

For repeatable or large-scale cleaning, I would prefer Power Query rather than manually editing thousands of rows.

🎯 Double Tap ❤️ For More