How to Find Percentile in Excel (PERCENTILE Function)
I am sure you have heard the word percentile when people talk about numbers and rankings. I remember it being one of the ways we used to get our ranking …
I am sure you have heard the word percentile when people talk about numbers and rankings. I remember it being one of the ways we used to get our ranking …
If you have been working with Microsoft apps (such as Excel, PowerPoint, or Word), I am sure you have encountered files that are read-only. What a read-only file means is …
The slope is commonly used in statistics, where it tells us how two variables are related in a dataset. While I remember using a pen and a paper and some …
Sometimes, when you create a chart in Excel, you may want to switch the axis in the chart (i.e, interchange the X and the Y-axis) It’s really easy and in …
When you have to enter a sequence of dates in a column in Excel, you don’t need to do it manually. Excel has some amazing features using which you can …
Barcode allows you to show data in a visual format that can easily be read by machines. I am sure you have seen barcodes hundreds of times on products, including …
When you are working with large amounts of data in spreadsheets, you need all the tips and tricks you can get to quickly access your required data. Oftentimes you might …
When working with data related to investments and project assessments, you may sometime have to calculate the NPV (Net Present Values) of projects/investments. In this tutorial, I will show you …
Often when working with text data such as names or address, you will get the data in uppercase, and you may need to convert it into lowercase or propercase. With …
IRR is a frequently visited topic when talking about investments and returns. Trying to calculate the IRR (which stands for the Internal Rate of Return), given a series of cash …
Word documents are for word processing while Excel files are for data processing. But what if you need to combine the two? What if you need to display a part …
When working with data in Excel, you will often format data (such as color the cells or make them bold or give a border), to make these stand out. And …