Advanced Excel

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

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

How to Use Text Filter in Excel (5 Methods)

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 Perform Custom Filter in Excel (5 Ways)

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 Filter Horizontal Data in Excel (3 Methods)

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

Filter Multiple Criteria in Excel with VBA: 2 Easy Methods 

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

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

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 Remove Filter in Excel (5 Easy & Quick Ways)

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 Create Drop Down List with Filter in Excel (7 Methods)

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

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

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

How to Use VBA in an Excel Table – 9 Methods

This dataset showcases a table with headers. Method 1 - Creating a Table with VBA in Excel Declare the Table as a ListObject. ...

How to Create Excel Drop Down List from Table (5 Methods)

Method 1 - Creating a Drop-Down List from a Table with Validation To create a drop-down list from a table, we can use the validation option. This is ...

Excel Advanced Filter Not Working (2 Reasons & Solutions)

  What Is the Advanced Filter in Excel? We can use the Advanced filter to perform complex filtering in Excel. For example, you can filter data ...

Create a Dynamic Chart Range in Excel (2 Methods)

Method 1 - Use an Excel Table to Create a Dynamic Chart Range in Excel Select the whole dataset. Press Ctrl + T keys. A dialog box ...

How to Create Excel Drop Down List with Color (2 Ways)

We'll use a sample dataset of dress stores that represents the order, size, and color information of a particular dress. The dataset contains 4 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo