Latest Blog Posts

How to Use Dynamic Range for Last Row with VBA in Excel (3 Methods)

Why Do You Need a Dynamic Range We have a simple dataset with Quantity, Unit Price, and Sales of some Items. We want to find the average, sum, ...

Create Dynamic Named Range with VBA in Excel (Step-by-Step Guideline)

We can refer to a certain range of cells in the Excel worksheet by using the Define Name feature. But, we constantly need to add new data or update ...

Dynamic Sum Range Based on Cell Value in Excel: 4 Ways to Create

Method 1 - Use INDEX Function to Create Dynamic Sum Range Based on Cell Value in Excel We will use a dataset that contains information about the ...

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

Excel VBA to Find and Replace Text in a Column: 2 Methods

Method 1 - Use the Replace Method of VBA to Find and Replace Text in a Column A. Build the Code Open VBA Editor Press Alt+F11 on your ...

How to Set Due Date Reminder in Excel (3 Quick Methods)

We’ll use the following dataset that represents some buyers’ invoice amounts and due dates. Method 1 - Combine TODAY, AND, and IF ...

Multiple Excel Cells Are Selected with One Click: 4 Causes+Solutions

Method 1 - Disable the Extend Selection Mode If Multiple Cells Are Selected with One Click Look at the following screenshot. Only cell B5 is ...

How to Convert Date to Day in Excel (7 Quick Ways)

The sample dataset contains Festival’s Name and Date. We will convert the Date to Day. Method 1 - Adopting Format Cells Feature to ...

How to Find and Replace Blank Cells in Excel (4 Methods)

The sample dataset contains student's names along with their Student ID and their Marks. Some students did not take the exam and so their mark is ...

Using VBA to Remove Time from a Date in Excel – 3 Methods

  The above image is the sample dataset. Method 1 - Embed VBA to Delete Time from Dates in a Column in Excel Remove time in ...

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 Convert Date to Month in Excel (6 Easy Methods)

We will be working on the following dataset. Convert a Date to Month in Excel: 6 Methods Method 1 - Converting a Date to the Month with ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo