Excel Formulas Archives - Page 13 of 112

How to Calculate Sigma Level in Excel (2 Suitable Ways)

Jul 12, 2024

What Is the Sigma Level? The Sigma level is a parameter to indicate the number of defects in 1 million opportunities. The sigma level indicates that ...

How to Calculate Sigma Level in Excel (2 Suitable Ways)

How to Make a Payroll System with Payslip in Microsoft Excel – 4 Steps

Aug 8, 2024

In the sample dataset, cells with monetary values are in Accounting format. Step 1 - Creating a Dataset Enter the Employee names in the first ...

How to Make a Payroll System with Payslip in Microsoft Excel – 4 Steps

How to Add Prefix to Entire Column in Excel (4 Simple Methods)

Jul 6, 2024

Method 1 - Apply CONCATENATE Function to Add Prefix in Excel Concatenate is defined as joining or combining. The CONCATENATE function connects text ...

How to Add Prefix to Entire Column in Excel (4 Simple Methods)

How to Apply All Combinations of 3 Columns in Excel

Jul 2, 2024

Method 1 - Use Power Query Steps: Create 3 separate tables for 3 columns. Select the first column and press Ctrl+T. Create Table ...

How to Apply All Combinations of 3 Columns in Excel

How to Convert Decimal Number to Hexadecimal (Hex) in Excel

Jun 13, 2024

In the dataset below, we have some positive and negative decimal numbers. Let's convert them to hexadecimal using 2 different methods. ...

How to Convert Decimal Number to Hexadecimal (Hex) in Excel

How to Do Payroll Reconciliation in Excel (with Easy Steps)

Jul 4, 2024

We have a sample dataset with salary sheets of a company called SOFTEKO. Let's assume the current month is October. Step 1 - Open Salary Sheet ...

How to Do Payroll Reconciliation in Excel (with Easy Steps)

How to Add Suffix in Excel (4 Easy Ways)

May 26, 2024

How to Add Suffix in Excel: 4 Easy Ways Our sample dataset has three columns labeled Name, Suffix, and Email. Method 1 - Utilize CONCATENATE ...

How to Create a Vehicle Depreciation Calculator in Excel (3 Methods)

Jul 12, 2024

What is Depreciation? Depreciation refers to the gradual reduction in the value of an asset over several years. When a business organization ...

How to Create a Vehicle Depreciation Calculator in Excel (3 Methods)

How to Add a Text Suffix with a Custom Format in Excel – 5 Examples

Aug 12, 2024

Example 1 - Adding a Text Suffix (e.g. Kg) for Mass The dataset below showcases multiple weight values. There is no unit. To add “Kg” as suffix ...

How to Add a Text Suffix with a Custom Format in Excel – 5 Examples

How to Remove Prefix 91 in Excel (4 Easy Ways)

Jul 1, 2024

Column B has a list of phone numbers that begin with 91. We'll remove the prefix. Method 1 - Using the REPLACE Function to Remove Prefix ...

How to Remove Prefix 91 in Excel (4 Easy Ways)

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

Jul 3, 2024

Our dataset includes the Addresses of ABC Company employees. Our goal is to find the ZIP Codes from the given addresses. Method 1 - ...

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

Ageing Formula with Current Date in Excel (4 Examples)

Jun 11, 2024

We will use the sample dataset below to illustrate how to calculate the Age from the current date. Method 1 - TODAY and INT Functions to ...

Ageing Formula with Current Date in Excel (4 Examples)

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

Jul 13, 2024

Method 1 - Using the STOCKHISTORY Function The STOCKHISTORY function is a powerful tool in Excel that retrieves historical data for stocks or ...

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

How to Create Monthly Depreciation Schedule in Excel

Jul 4, 2024

What Is a Depreciation Schedule? The reduction in the value of an asset over multiple years is called Depreciation. A Depreciation Schedule ...

How to Create Monthly Depreciation Schedule in Excel

How to Convert Zip Codes to States Using Excel Formulas (5 Methods)

Jul 18, 2024

Dataset Overview In this tutorial, we’ll work with a dataset containing the maximum and minimum zip codes for each state in the United States. The ...