How to Calculate Hours between two Times in Excel?
Calculating the number of hours between two given times might be required for a number of situations. You might need to calculate the number of hours needed to complete a …
Formulas
How to Convert Decimal to Binary in Excel
If you’re working with computers or machines, you might need to convert a set of decimal numbers into their binary equivalents. In this tutorial we will go over how you …
How to Separate Address in Excel?
When you work with addresses, it can be convenient sometimes to have different parts of the address split out into Street address, city, state, and zip code (or postal code). …
How to Calculate Confidence Interval in Excel
If you want to find out how to calculate a confidence interval in Excel, you’re in the right place! Here, you can see how a confidence interval is calculated based …
Convert Military Time to Standard Time in Excel (Formulas)
A lot of organizations prefer to use the 24-hour ‘military time’. These include the airline industry, public transport, and of course the armed forces. Besides organizations, there are a lot …
How to Convert Days to Years in Excel (Simple Formulas)
There might be a number of reasons for wanting to convert days to years in Excel. For example, you might have a count of days that have passed and you …
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 …
How to Find Slope in Excel (Easy Formula)
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 …
How to Autofill Dates in Excel (Autofill Months/Years)
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 …
How to Calculate NPV in Excel (Net Present Value)
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 …
How to Change Uppercase to Lowercase in Excel (3 Easy Ways)
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 …
How to Extract Number from Text in Excel (Beginning, End, or Middle)
Extracting numbers from a list of cells with mixed text is a common data cleaning task. Unfortunately, there is no direct menu or function created in Excel to help us …