Excel Formulas

How to Sum All Matches with VLOOKUP in Excel (3 Easy Ways)

Consider the following dataset which contains a bookstore's stock. We'll use the VLOOKUP function to sum all matches for a particular criteria. ...

How to Remove White Space in Excel (6 Easy Ways)

In the sample dataset, we have placed some random employee names and their office IDs. There are many unnecessary spaces in the employee names. Let's ...

How to VLOOKUP and AVERAGE Specific Values in Excel – 6 Methods

The sample dataset contains sales information on different regions. Method 1 - Merge the VLOOKUP and AVERAGE Functions in Excel Select a ...

How to Count Occurrences Per Day in Excel (4 Quick Ways)

To demonstrate our methods, we'll use the following dataset, containing columns for Product Name and Order Date. We used Excel 365 here, but the same ...

How to Remove Non-Printable Characters in Excel?

The sample dataset contains some non-printable characters in the Student Name column. We will try to remove these characters using the following ...

Editor choice How to Remove Non-Printable Characters in Excel?

How to Remove Specific Text from Cell in Excel (Easiest 11 Ways)

The following image shows an overview of removing specific text from cells in Excel. We have a dataset with 3 columns. We will remove specific ...

How to Remove the Last 3 Characters in Excel (4 Easy Ways)

We will show you four distinct formulas to remove the last 3 characters in Excel with ease. We'll use a simple dataset that contains employee ...

How to Remove Leading Spaces in Excel (4 Easy Methods)

Method 1 – Using the TRIM Function to Remove Leading Spaces Steps: Select the cell where you want to place your resultant value. (Cell E4.) ...

How to Calculate Years from Today in Excel (4 Easy Ways)

There is no built-in function to calculate the years between a past or future date and today’s date in Excel. However, you can do it by applying a ...

How to Remove Special Characters in Excel

This article describes various ways to remove special characters in Excel. Here's an overview of the methods and formulas we'll be applying. ...

How to Find Last Cell with Value in Column in Excel (3 Ways)

We have a simple dataset where we'll find the last cell with a value in a column. Method 1 - Inserting the LOOKUP Function to Find Last ...

How to Remove Text from a Cell in Excel (9 Easy Ways)

In the following dataset, you can see the Product Name and Product ID columns. Let's use it to demonstrate how you can remove text from the IDs. ...

How to Remove Non-numeric Characters from Cells in Excel?

Here is the overview of removing non-numeric characters in Excel. How to Remove Non-numeric Characters from Cells in Excel: 2 Easy Ways ...

How to Compare Two Columns in Excel for Match (8 Easy Ways)

Consider the following dataset with 10 days of sales data from two different salesmen. Each of them sold one car per day which is given in columns B ...

How to Compare 4 Columns in Excel VLOOKUP (7 Methods)

Dataset Overview In this scenario, we have data from two companies, and we want to compare whether their product names and item colors match. We ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo