Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses
Confused about percentiles and percentages? 🤔 This enlightening video unravels the mystery, making these concepts crystal clear, especially for those new to Excel or non-native English speakers.
⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/percentile-file
Highlights:
▪️ Understanding Percentiles: Grasp what it means for your salary or test scores to be in a certain percentile.
▪️ Distinguishing Percentile from Percentage: Clear, concise explanations of these often-mixed-up terms.
▪️ Excel Percentile Functions Simplified: A user-friendly walkthrough on PERCENTILE.INC and PERCENTILE.EXC in Excel.
▪️ Real-World Applications: Learn through practical examples - ideal for analyzing salaries and interpreting test results.
▪️ Excel Skills Upgraded: Explore essential Excel functions that are valuable across various professions.
You'll also learn how to use the PERCENTRANK.INC function in Excel to calculate the relative standing or the rank of a value within a data set as a percentage.
00:00 What Does Percentile Mean?
00:52 Percentage vs. Percentile
01:28 How to Use PERCENTILE.INC in Excel
03:06 How to Use PERCENTRANK.INC in Excel
04:48 How to Use PERCENTILE.EXC in Excel
06:15 Wrap Up
My Online Excel Courses ► https://www.xelplus.com/courses/
LINKS to related videos:
Calculate Percentage Change in Excel: https://youtu.be/UN5PckRADyQ
️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
RESOURCES I recommend: https://www.xelplus.com/resources/
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel