Latest Blog Posts

How to Replace Text in Excel Formula (7 Methods)

Scenario We have two formulas in the Discounted Price column and >2000 or not column, and we want to demonstrate how to change the text string or ...

How to Calculate Running Balance Using Excel Formula (4 Ways)

Consider the following dataset of cash flow inside some bank accounts. The deposits and withdrawals are listed in columns C and D. We’ll calculate ...

How to Use Calculated Field in Excel Pivot Table (8 Ways)

We'll use a sample dataset that represents the sales information of a particular salesperson. The dataset has 3 columns: SalesPerson, Region, and ...

How to Refresh Pivot Table with VBA in Excel (5 Examples)

Implementing VBA macro is the most effective, quickest, and safest method to run any operation in Excel. In this article, we will show you how to ...

How to Use Sheet Name Code in Excel (4 Applications)

In this article, we will learn how to use and get sheet name code in Excel. In Microsoft Excel, we can use the sheet name directly in a formula as a ...

Relative and Absolute Cell Address in the Spreadsheet

We can use the cell addresses of other workbooks and applications as a reference. In Excel, there are two types of cell addresses one is a relative ...

Transfer Specific Data from One Worksheet to Another for Reports

While working in Excel we frequently need the necessity to transfer specific data from one worksheet to another for reports in corporate or research ...

How to Find Unique Values in an Excel Column (6 Methods)

Method 1 - Using Advanced Filter for Unique Values We'll use the below dataset: Steps Open your Excel workbook. Navigate to ...

Pivot Table Not Refreshing (5 Issues & Solutions)

We have a dataset where the Product Category, Quantity, and Sales are given based on states. You can visit the How to create a Pivot Table ...

What Is a Circular Reference in Excel?

In this article, we will explore the concept of Circular Reference in Excel. We'll understand why it's important to avoid them and learn how to find ...

How to Find Multiple Values in Excel (8 Quick Methods)

We have a dataset containing the hobbies of several people. However, one person (Emily) has more than one hobby. We will show how you can extract ...

How to Refresh All Pivot Tables with VBA (4 Ways)

This code will refresh all the Pivot Tables of the active workbook. Dim Table As PivotTable For Each Table In ActiveWorkbook.PivotTables     ...

COUNTIF vs COUNTIFS in Excel: 4 Methods

Method 1 - Basics of COUNTIF and COUNTIFS Functions COUNTIF Function The COUNTIF function operates with a single range and criterion. ⏩ Apply ...

How to Perform Greater than and Less than in Excel (5 Methods)

We have an Excel worksheet that contains information on various outlets of a chain restaurant all across the United States. The Excel worksheet ...

How to Resolve “Pivot Table Field Name Is Not Valid” Error: 9 Causes and Corrections

Dataset Overview We'll be using the following table (some alterations may occur later for different sections) to demonstrate the causes of this ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo