Uploaded January 2026 | Updated September 2026, 2 weeks ago

---

Welcome to dptutorials, where Excel analytics is explained clearly and practically.

In this video, you’ll learn how to calculate percentiles in Excel using the PERCENTILE.INC function. Percentiles are widely used to understand data distribution, performance benchmarking, and ranking analysis.

This tutorial explains what percentiles mean in simple terms and shows how to calculate common percentiles like the 25th, 50th, 75th, and 90th percentile. You’ll also learn the important difference between PERCENTILE.INC and PERCENTILE.EXC, which is a frequent interview question.

A real-world dataset with 50 values is included so you can practice immediately. If you want to strengthen your Excel analytics skills and confidently handle percentile-based questions, this is a must-know Excel concept.

Subscribe to dptutorials for more Excel formulas, analytics tricks, and real-world productivity tutorials.

Percentile Calculation in Excel | Simple Explanation

#ExcelShorts #ExcelTips #ExcelAnalytics