Excel Formulas

How to Lookup ZIP Code in Excel (4 Suitable Methods)

If you are searching for how to look up a ZIP code for the name of a country or city in Excel, then you have come to the right place. Today, in this ...

How to Format Hex Numbers with a Leading Zero in Excel – 2 Steps

Step 1 - Convert Decimal Numbers to Hex Format Using the DEC2HEX Function in Excel Enter the following formula: =DEC2HEX(B5) ...

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

To demonstrate how to add months to  a date in Excel, we'll use the following dataset representing a subscription, where column B shows the ...

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 Decimals to Binary in Excel – 3 Methods

Consider the dataset containing a List of Decimal Numbers. To convert these decimal numbers into binary numbers:   Method 1 - ...

How to Calculate 90 Days from a Date in Excel: 2 Useful Methods

Method 1 - Application of SUM Function to Calculate 90 days from a Specific Date in Excel Steps: Write down the following formula in cell D5 ...

How to Add 3 Years to a Date in Excel (3 Effective Ways)

When we work with dates in Excel, sometimes we may want to add specific years to a date. It’s quite easy to do in Excel. At the same time, Excel ...

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

The dataset showcases Students' Admission Dates.   Method 1 - Utilizing an Arithmetic Formula Steps: Go to D5 and enter the ...

How to Format Zip Code to 5 Digits in Excel (5 Easy Methods)

While working in Microsoft Excel sometimes we need to format zip code to 5 digits so that we can work more productively. If we change zip codes one ...

How to Convert Binary to Decimal in Excel (2 Easy Methods)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. In this ...

How to Calculate Days Outstanding in Excel: Step-by-Step Procedures

Method 1 - Arranging Dataset In this case, our first step is calculating days outstanding in Excel using the existing dataset. We have Particulars ...

How to Auto Populate Zip Codes in Excel (3 Simple Ways)

Managing data can be very easy if we can populate Excel cells automatically. This article will show you how we can auto populate Zip Codes in Excel. ...

How to Convert Zip Code to State with VLOOKUP in Excel (3 Quick Methods)

Zip codes are defined as the postal code of certain cities or states of a country. It is used as a part of the address. Every country has its ...

How to Concatenate ZIP Codes in Excel (3 Easy Methods)

ZIP Code is one kind of Postal Code that is used to identify and locate an address. To keep location data, we have to store ZIP code data frequently ...

How to Extract Zip Code from Addresses Using Excel Formula?

In today's data-driven world, extracting specific information from large datasets is a crucial skill, particularly when dealing with addresses. "How ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo