Advanced Excel Archives - Page 55 of 64

How to Add Filter in Excel (4 Simple Methods)

Apr 29, 2024

Consider the following data as a product price list. We have added a filter to the data. The drop-down icons at the right-bottom corners of the ...

How to Add Filter in Excel (4 Simple Methods)

How to Filter Unique Values in Excel (8 Easy Ways)

Apr 29, 2024

Let’s say we have three simple columns in an Excel dataset containing Order Date, Category, and Product information. We want the unique ordered ...

How to Filter Unique Values in Excel (8 Easy Ways)

How to Make a Price List in Excel (Step by Step Guidelines)

Jul 6, 2024

Step 1 - Making an Outline of the Price List Template We'll start with the following dataset that contains various product details, including ...

How to Make a Price List in Excel (Step by Step Guidelines)

How to Highlight Cell Using the If Statement in Excel (7 Ways)

Jun 14, 2024

Let’s say we have the following dataset: Sales Representative's Name, their Sales Area, and the Number of Units Sold in each month of the first ...

How to Highlight Cell Using the If Statement in Excel (7 Ways)

Highlight Cells That Contain Text from a List in Excel (7 Easy Ways)

Jul 6, 2024

Method 1 - Use the COUNTIF Function to Highlight Cells That Have Text from a List We have a list of Fruit 1 (B4:B14) containing several fruit names. ...

Highlight Cells That Contain Text from a List in Excel (7 Easy Ways)

Shortcuts for Filtering Data in Excel (3 Methods with Examples)

May 18, 2024

Method 1 - Use the Filter Shortcut Option Under the Data Tab to Filter Data Suppose you have the following dataset. Steps: Select any ...

Shortcuts for Filtering Data in Excel (3 Methods with Examples)

How to Use Text Filter in Excel (5 Methods)

Jul 27, 2024

Dataset Overview Let’s consider a scenario where we have an Excel worksheet containing information about products sold by a company to customers. ...

How to Use Text Filter in Excel (5 Methods)

How to Perform Custom Filter in Excel (5 Ways)

May 20, 2024

We will use the sample dataset provided below to perform our custom filter. Method 1 - Filter Value Based on Number in Excel Steps: ...

How to Perform Custom Filter in Excel (5 Ways)

How to Filter Horizontal Data in Excel (3 Methods)

May 4, 2024

The sample dataset contains sales data for 8 products that fall into 3 different categories. We will discuss 3 suitable methods to filter this ...

How to Filter Horizontal Data in Excel (3 Methods)

Filter Multiple Criteria in Excel with VBA: 2 Easy Methods

Jun 27, 2024

Method 1 - Filter Multiple Criteria of AND Type in Excel with VBA Develop a Macro to filter multiple criteria of AND type for any data set. ...

Filter Multiple Criteria in Excel with VBA: 2 Easy Methods

How to Compare Two Excel Sheets and Highlight Differences: 7 Methods

Jun 21, 2024

Method 1 - Using the View Side by Side Option to Compare Two Excel Sheets from Different Files and Highlight the Differences Steps: ➤ Open the two ...

How to Compare Two Excel Sheets and Highlight Differences: 7 Methods

How to Remove Filter in Excel (5 Easy & Quick Ways)

May 19, 2024

For the purpose of demonstrating how to remove Filter in Excel, we'll use a sample dataset of a particular salesperson’s sales information, ...

How to Remove Filter in Excel (5 Easy & Quick Ways)

How to Create Drop Down List with Filter in Excel (7 Methods)

Jun 23, 2024

Method 1 - Creating a Drop-Down List in Excel The dataset contains some candidate names in column B. We'll create a drop-down that inputs one of ...

How to Create Drop Down List with Filter in Excel (7 Methods)

What Is a Circular Reference in Excel?

Nov 11, 2025

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 Fix a Circular Reference Error in Excel – A Guideline

Aug 14, 2024

What is A Circular Reference? A circular reference occurs when a formula, either directly or indirectly, refers back to its cell reference, ...