Advanced Excel

How to fix a non-working CTRL+F in Excel: 5 Solutions

Below is a dataset representing the 5 best-nominated movies in the Best Picture category for the 2022 Oscar Awards. Solution 1 –  Set ...

How to Keep Unique Values in a Drop Down List with Excel VBA – 3 Methods

Quick View: Sub Drop_Down_List_Unique_Values_At_Least_Once() List_Location = "B3" Data = Range(List_Location).Validation.Formula1 Data = ...

How to Copy Filter a Drop-Down List in Excel (5 Methods)

Method 1 - Using an Advanced Filter Option to Copy a Filter Drop-Down List  We have the products listed in the Product column, but the products are ...

How to Filter Date Range in Excel (5 Easy Methods)

We'll consider the sample dataset that contains the sales quantity of some electronic products in a shop in January, February, and March. We'll ...

How to Combine Two Scatter Plots in Excel (Step by Step Analysis)

In Excel, the combination of scatter plots allows you to show and analyze two separate data sets that are connected to each other. A standard chart ...

How to Remove Duplicates from a Drop Down List in Excel (4 Methods)

Dataset Overview Let’s assume you have a large Excel worksheet containing information about various fruits and vegetables imported by a country into ...

How to Remove Used Items from Drop Down List in Excel (2 Methods)

While working with data validation in Excel, you might need to remove used items from the drop-down list to avoid assigning an item in the list ...

How to Apply Multiple Data Validation in One Cell in Excel: 3 Methods

Method 1 - Apply Multiple Data Validation in One Cell in Excel with Specific Criteria STEPS: Combine the criteria formulas in a nested formula ...

How to Create a Data Validation Drop-Down List with VBA in Excel (7 Methods)

Method 1 – Embedding VBA to Create a Data Validation Drop-Down List  Steps: Press Alt + F11 or go to the tab Developer -> Visual Basic to ...

How to Select from Drop Down and Pull Data from Different Sheet in Excel

Method 1 - Use the VLOOKUP Function to Select from a Drop-Down and Pull Data from a Different Sheet in Excel We will use a dataset that contains ...

How to Hide and Unhide Columns Based on a Drop-Down List Selection in Excel

How to Create a Drop-Down List in Excel STEPS: Select a cell (E3, in this example) on which we’ll create the drop-down list. Go to ...

How to Create a Form with Drop Down List in Excel

Method 1 - Create Form Area Select an area on your Worksheet where you will create your custom form. Select your background color. We chose ...

Creating a Drop-Down Filter to Extract Data Based on a Selection in Excel – 4 Methods

This is the sample dataset: Method 1 - Create a Drop-Down Filter to Extract Data Based on Selection with Helper Columns in Excel Insert 3 ...

How to Remove Blanks from a Data Validation List in Excel (5 Methods)

Method 1 – Using the OFFSET Function Steps: Enter the following formula in cell C5: =FILTER(B5:B14,B5:B14<>"") Here, the ...

How to Create a Drop-Down List with Unique Values in Excel – 4 Methods

The sample dataset showcases Product name, Category, and Country to which the product is exported. Method 1 - Insert a Pivot Table to ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo