Excel Formulas

How to Find ZIP Code from Address in Excel (2 Easy Ways)

Finding the ZIP Code or Postal Code can be a troublesome job to do in Excel if you don’t know the correct procedure. But it’s rather quite an easy ...

How to Add Prefix Without Formula in Excel (2 Easy Ways)

Sometimes, we have a dataset in Excel and we may want to add a common prefix to all the data. We can do that quite simply in Excel without even using ...

Ageing Formula with Current Date in Excel (4 Examples)

While working in Microsoft Excel sometimes we need to calculate age from the current date. This is mostly needed when we are determining the ages of ...

[Fixed] Zip Codes in Excel Starting with 0

If you are looking for Zip codes in Excel starting with 0, then you are in the right place. During statistical analysis or research activities, we ...

How to Create Rental Property Depreciation Calculator in Excel

Depreciation is the term used to describe the decline in an asset's value over a period of years. In other words, depreciation is the process by ...

How to Get Exchange Rate by Date in Excel (2 Suitable Methods)

Exchange rate is very crucial to businessmen, especially those who are dealing with foreign currencies. The rate of exchange varies with time. So, it ...

How to Create Monthly Depreciation Schedule in Excel

If you want to create a monthly depreciation schedule in Excel, you have come to the right place. Here, we will walk you through some easy methods to ...

How to Calculate Working Capital Days in Excel (with Easy Steps)

Working Capital and Working Capital Days are very frequently used terms in any business model. A proper illustration of these two terms is ...

How to Convert Hex Numbers to Binary in Excel (2 Easy Ways)

Fortunately, there are a number of functions in Excel to perform various operations easily and swiftly. Sometimes, we need to use hexadecimal numbers ...

How to Create Fixed Asset Depreciation Calculator in Excel

Depreciation is described as the continual lowering of a fixed asset's reported cost until the asset's value is zero or insignificant. We can easily ...

Excel Formula to Change Zip Code to State (5 Examples)

In Excel, you may need to do a lot of work while working on a worksheet. One of the important works that can be done by Excel is to change a zip code ...

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 Convert Hex to Decimal in Excel (2 Practical Examples)

When working with numbering systems, Hexadecimal and Decimal both systems are significant from their own perspectives. So, it is a frequent need for ...

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 ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo