Excel Formulas

How to Remove Leading Zeros in Excel: 8 Easy Methods

Method 1 - Converting Text to Number to Remove Leading Zeros in Excel Steps: Arrange a dataset like the below image. Select the ...

VLOOKUP Formula to Compare Two Columns in Different Excel Sheets

We have data from two teams that have some common members in two different worksheets named TeamA and TeamB. We'll find the common names and the ...

How to Get Data from Another Sheet Based on Cell Value in Excel

Method 1 - Combining INDEX and MATCH Functions We have a dataset that includes several months and the sales amount of several products. We'll get ...

Excel Formula Symbols Cheat Sheet: 13 Cool Methods

Method 1 - Order and Precedence of Operators in Excel Excel uses many symbols for mathematical operations. These operations follow some precedence. ...

Excel Dynamic Range Based on Cell Value

In this article, we will be discussing the "Excel Dynamic range Based on Cell Value". Here, we will be creating dynamic ranges without selecting them ...

Excel IF Function with 3 Conditions (5 Logical Tests)

We'll use a dataset of a company’s Sales Report. It shows the information for Product Code and Monthly Sales in the cell range B4:C10. We need ...

How to Remove Duplicate Rows in Excel Based on Two Columns

In this tutorial, I am going to show you 4 suitable ways to remove duplicate rows in Excel based on two columns. You can quickly use these methods, ...

How to Find Duplicate Values Using VLOOKUP in Excel: 3 Suitable Examples

Method 1 - Use VLOOKUP to Find Duplicate Values in Two Columns Make two columns that contain different product names. Look for the Product Name-1 ...

How to Reference Cell in Another Sheet Dynamically in Excel (5 Methods)

The two sample datasets show data on 2020 Sales shown in the B4:C14 cells which depict the Names of the sales reps and their Sales in USD ...

How to Compare Two Columns Using VLOOKUP Function in Excel

There are a lot of ways to compare two lists or columns in Excel. In this article, I am going to compare/find matches in two columns in Excel using ...

How to Calculate Mean and Standard Deviation in Excel

What Is Mean Deviation? Mean Deviation is a statistical measure of variability. It is calculated as the average of the absolute deviations of the ...

How to Highlight Every Other Row in Excel (3 Easy Methods)

In this article, we will see how to highlight every other row in Excel. Some available techniques are applying conditional formatting, using ...

How to Delete Blank Rows in Excel (6 Ways)

While working with a big spreadsheet you often insert blank rows intentionally to read and understand it properly. Although inserting blank rows are ...

How to Multiply in Excel (8 Methods)

We have a dataset of product Names, unit prices, and Quantities. We will learn to multiply this information from the dataset to calculate the Total ...

How to Compare Two Columns or Lists in Excel (4 Suitable Ways)

Method 1 - Compare Two Columns Using Equal Operator Steps: Add a new column on the right side to show the matching status. Enter the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo