# @udemy on YouTube

- **Type:** Video
- **Original URL:** https://youtube.com/watch?v=H1ZElfjw8Yk
- **Gondola URL:** https://gondola.cc/posts/72078190-udemy-youtube
- **Thumbnail:** https://img.gondola.cc/tr:w-,h-,fo-auto/postThumbnails/cf62465ce5.jpg
- **Posted:** 2019-03-18T22:52:01.000+00:00
- **Account Owner:** Udemy (@udemy) — https://gondola.cc/udemy

## Caption

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:

📘 Excel Pro Tips Course:
https://www.udemy.com/course/microsoft-excel-pro-tips-for-power-users

👨‍🏫 Learn from instructor Chris Dutton (Maven Analytics):
https://www.udemy.com/user/maven-analytics/

📚 Browse more Excel tutorials, from beginner to advanced:
https://www.udemy.com/topic/excel/

👍 Found this helpful? Like, comment below with your favorite Excel trick, and don’t forget to subscribe!

#OutlierDetection #ExcelAnalytics #DataCleaning #ExcelStats #ExcelTips

## Stats

- **Views:** 19,934
- **Likes:** 70
- **Shares:** 0
- **Comments:** 1

## Tags

exceltips, excelanalytics, datacleaning, outlierdetection, excelstats

---
Copyright (c) Gondola