VLOOKUP with IF Condition in Excel (6 Examples)

In the following GIF, we display the unit price of the selected products in 2 different stores: Walmart and Kroger. We applied the VLOOKUP function ...

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

How to use a Formula for an Entire Column in Excel – 6 Methods

Consider the Performance of Sales Reps dataset. It showcases Names, the 2022 Sales, and the 2021 Sales of each employee.   Method ...

How to Merge Excel Worksheets Without Copying and Pasting?

In this article, we will demonstrate three ways to merge Excel worksheets without copying and pasting. In the first method, we combine data from ...

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

How to Delete a Pivot Table in Excel – 3 Methods

This is the sample dataset. This is the pivot table. Method 1 - Delete the Pivot Table with the Data Table Steps: Select the ...

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 Make Excel Spreadsheet Bigger When Printing (7 Ways)

You cannot make your Microsoft Excel spreadsheet bigger (unless you want to change the page size). But in this article, we will show some tips and ...

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

Solving Equations in Excel (5 Methods)

Method 1 - Solving Polynomial Equations in Excel A polynomial equation is a combination of variables and coefficients with arithmetic operations. ...

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 Make a Pie Chart in Excel: 5 Suitable Methods

Method 1 - Using Charts Group to Make a Pie Chart in Excel Step 1: Inserting Pie Chart Select the data range with which you want to make the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo