Excel Formulas

Pull Same Cell from Multiple Sheets into Master Column in Excel

In this article, I will show you how to pull the same cell from multiple sheets into a master column in Excel. Pull Same Cell from Multiple ...

How to Subtract Dates in Excel to Get Years (7 Simple Methods)

Microsoft Excel is undoubtedly a highly efficient program. Excel's tools and functions allow us to execute endless actions on a dataset. This article ...

How to Find Number of Weeks Between Two Dates in Excel

Suppose you are in a situation where you have to calculate weeks from some given date range. And you need to calculate cost estimation by using those ...

Format Hex Numbers in Excel with Leading Zero (with Quick Steps)

In this article, we will see how to format hex numbers with leading zero in Excel. In many cases, we require numbers that start with single or ...

How to Add 3 Months to a Date in Excel (4 Easy Methods)

Microsoft Excel provides time management services in a very efficient way. In addition, You can manage your daily, monthly, or yearly schedule easily ...

How to Calculate Tenure in Years and Months in Excel

We will use the following dataset to demonstrate 5 easy methods to calculate tenure in years and months in Excel. In the dataset below, you see the ...

How to Convert Decimal to Binary in Excel (3 Quick Methods)

Unquestionably, Microsoft Excel excels at crunching numbers! Now, this means that you can perform tedious calculations in the blink of an eye. In ...

How to Calculate 90 Days from a Specific Date in Excel

While working in Excel, we often face a situation when we need to calculate a date that is exactly 90 days away from a specific date. If you are ...

How to Add 2 Years to a Date in Excel (3 Easy Methods)

Sometimes, it’s essential to include dates in an Excel dataset for ease of use. You may need to add certain years to the date. There are several ...

How to Calculate Days Outstanding in Excel (With Easy Steps)

This tutorial will demonstrate how to calculate days outstanding in Excel. When you are in the business field, it requires lots of effort to reclaim ...

How to Lookup County from Zip Code in Excel (3 Suitable Ways)

Sometimes users need to look up a county based on zip codes in Excel. This task can be easily performed by utilizing some Excel functions and ...

How to Remove Last 4 Digits of Zip Code in Excel (10 Easy Ways)

Zip codes are essential for delivering parcels through postal services to reach a correct destination. Zip codes contain 9 digits, among which the ...

How to Convert USD to CAD in Excel (4 Quick Tricks)

Converting currency is an essential operation. We can do that in Excel very efficiently. USD (US Dollar) and CAD (Canadian Dollar) are widely used ...

How to Change Comma Separator in Excel (7 Easy Methods)

This tutorial will demonstrate how to change the comma separator in Excel. In our day-to-day life, we have to deal with lots of data. When we are ...

How to Convert European Number Format to US in Excel (4 Ways)

A Number format is a standard to present a number that is understandable to mass people. In different regions of the world, different types of number ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo