Latest Blog Posts

How to Return YES If 2 Cells Match in Excel (10 Methods)

Below is a dataset that contains the names of the school's tennis and rugby players. Some of them play both games. Method 1 - Use the ...

Compare Two Cells Using Conditional Formatting in Excel (3 Methods)

We have a dataset of 3 columns titled Yearly Revenue Statement. The first column contains different unit names. The second and third column contain ...

How to Hide a Formula but Allow Input in Excel – 2 Methods

This is an overview: Consider the following bank interest calculator: You want to allow users to input data in C4:C7, but you don’t ...

Select All Cells with Data in a Column in Excel (5 Methods+Shortcuts)

In this article we'll discuss 5 methods to select all cells containing data in a column, and 3 related keyboard shortcuts. We'll use the following ...

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 Select Multiple Cells in Excel Without Mouse (9 Easy Methods)

In this article, I will discuss how you can select multiple Excel cells without using a mouse. I will use keyboard shortcuts mostly to select cells. ...

Excel Find Last Occurrence of Character in String (8 Methods)

Our sample dataset has three columns: Company Name, Employee Code, and Last Occurrence. Employee Code contains the name, age, and department of an ...

How to Find the First Value Greater Than in Excel (4 Methods)

Dataset Overview We have a dataset with columns for State Name (Column B), Budget Allocation (Column C), and Region (Column D). We'll identify the ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo