Excel Formulas Archives - Page 69 of 149

How to Calculate Basic Salary in Excel (3 Methods)

Jul 9, 2024

Useful Common Terms for Salary Calculations Basic Salary Basic Salary is the base part of the total salary that doesn’t include any other ...

How to Calculate Basic Salary in Excel (3 Methods)

How to Use the Grouping and Consolidation Tools in Excel – 5 Examples

Aug 15, 2024

Example 1 - Consolidating Data from Multiple Rows There are repeated names in the dataset: To consolidate repeated Sales Reps accounts in a ...

How to Use the Grouping and Consolidation Tools in Excel – 5 Examples

How to Use the Consolidate Function for Text Data in Excel – 3 Examples

Aug 11, 2024

Example 1 - Use the Consolidate Function for Text Data from Multiple Worksheets with the Power Query Tool Make sure all worksheets have the same ...

How to Use the Consolidate Function for Text Data in Excel – 3 Examples

How to Remove Consolidation in Excel (2 Handy Methods)

Aug 1, 2024

Method 1 - Applying the FILTERXML and SUBSTITUTE Functions in Excel We have a dataset where there is a list of Countries and their respective cities ...

How to Remove Consolidation in Excel (2 Handy Methods)

How to Create a Monthly Salary Sheet Format in Excel

Apr 26, 2024

Here's the dataset we'll build on. We have some employees and their basic salary. We will calculate their net salary and deductions. Step ...

How to Create a Monthly Salary Sheet Format in Excel

How to Calculate Discount in Excel (2 Easy Methods)

May 9, 2024

Method 1 - Creating an Excel Formula to Calculate a Discount Price Suppose we have a dataset of a Mobile selling shop with their product ...

How to Calculate Discount in Excel (2 Easy Methods)

How to Consolidate Data in Excel from Multiple Workbooks (2 Ways)

Nov 11, 2025

Sometimes, we have datasets containing the same data headings but different values according to their different categories in multiple workbooks. For ...

How to Consolidate Data in Excel from Multiple Workbooks (2 Ways)

How to Convert Inches to Feet in Excel (2 Handy Ways)

Nov 11, 2025

When we work with measurement data, the conversion from one measurement length unit to another is a common phenomenon. In daily life, conversion from ...

How to Convert Inches to Feet in Excel (2 Handy Ways)

How to Create Salary Slip Format with Formula in Excel Sheet

Apr 26, 2024

Let’s assume we have a large worksheet that contains the information about several Employee salary statements. The data for the Employee name, the ...

How to Create Salary Slip Format with Formula in Excel Sheet

How to Automate Consolidation in Excel?

Nov 11, 2025

This article illustrates how to automate consolidation in Excel. You can consolidate data from different worksheets or files in Excel. Data ...

Calculate Hours Between Two Times After Midnight – 3 Methods

Aug 3, 2024

In the dataset below, the start time is on the current day and the end time is on the next day. Method 1 - Use a Simple Excel Formula to ...

Calculate Hours Between Two Times After Midnight – 3 Methods

Search for Question Mark in Excel (4 Suitable Methods)

Nov 11, 2025

Microsoft Excel has several options to search for a specific text or character. In this article, we will show how to search for Question Mark in ...

Search for Question Mark in Excel (4 Suitable Methods)

How to Calculate Area of Irregular Shape in Excel (3 Easy Methods)

Jul 4, 2024

To illustrate the calculations, we will use the sample dataset below. Method 1 - Determine Area of Irregular Shape by Simple Calculation ...

How to Calculate Area of Irregular Shape in Excel (3 Easy Methods)

How to Consolidate Data from Multiple Rows in Excel (4 Methods)

Nov 11, 2025

In many cases, you may need to consolidate, merge, or combine data. In Microsoft Excel, you can do such types of tasks in bulk and within seconds. ...

How to Consolidate Data from Multiple Rows in Excel (4 Methods)

How to Calculate 10 Percent Discount in Excel (With Easy Steps)

May 15, 2024

Step 1 - Create the Dataset List down some items in column B. We put the price for each item in column C. The 10% discount for ...