Need to flag outliers or data entry mistakes in your spreadsheet? Learn how to detect them scientifically using Excel stats functions and conditional formatting! 📊 In this pro tip, Chris Dutton shows you how to use quartiles, interquartile range (IQR), and custom highlight rules to uncover statistical outliers—no add-ins or complex tools required. ✨ What you’ll learn: How to calculate Q1, Q3, IQR, and outlier fences Set dynamic conditional formats to flag out-of-range values Clean up your data and catch input errors like a pro ⏱️ Timestamps: 00:00 – Intro to Outlier Detection 00:30 – Quartiles, Median & IQR Explained 01:30 – Defining Outlier “Fences” 02:30 – Applying Conditional Formatting Rules 04:00 – Adjusting Sensitivity with Fence Multiplier 05:30 – Practical Use Cases (e.g. Data Entry Mistakes) 07:00 – Recap & Wrap-Up 🔗 Resources & Related Links Want to dive deeper into data cleaning and analytics? Check out the full Excel Pro Tips course for more expert-level tricks: 📘 E...