Latest Blog Posts

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

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 Calculate Variance in Excel (3 Handy Approaches)

In statistics, Variance gives the measurement of how the numbers of data are distributed around the mean/expected value, and measures the ...

How to Use a Compound Interest Formula in Excel – 4 Methods

The Simple Interest Formula Use this interest formula to calculate the amount of interest: I = Pnr I = calculated simple interest P = ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo