Handling Blanks & Outliers: IF, MEDIAN and Flags
This lesson is part of the course
In this lesson
You fill two missing days with the median, set an outlier fence with the IQR rule and flag a typo that would wreck every average.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Trimming Spaces & Fixing Case: TRIM, PROPER, UPPER Locked
- Splitting Codes & Names: LEFT, MID, FIND Locked
- Converting Text Numbers & Text Dates into Real Values Locked
- Standardising Categories with a Mapping Table (XLOOKUP) Locked
- Finding Duplicates & First Occurrences with COUNTIFS Locked
- Handling Blanks & Outliers: IF, MEDIAN and Flags Locked
- Validating Rows: Rule Checks with AND, OR and an Error Count Locked
- Capstone: an Analysis-Ready Table and a Region × Month Summary Locked