Excel Formulas

How to Remove Blank Spaces in Excel -7 Methods

This sample dataset contains cells with multiple blank spaces. Method 1 - Using the TRIM Function to Remove Blank Spaces Enter the ...

How to Remove Characters After a Specific Character in Excel

We may want to trim some characters after a particular character to make our dataset neat and clean in Excel. There are many reasons to remove ...

How to Count the Occurrences of a Character in a String in Excel – 4 Examples

The image below showcases the number of occurrences of characters in a string in some book names.   Example 1 - Count the ...

How to Split Cells in Excel (6 Easy Tricks)

Method 1 - Split Cells in Excel with the Text to Column Feature In the following table, we have some random names lying in the Text column. We'll ...

If Value Exists in Column Then TRUE in Excel

Here's an example of how you can implement a function to check if a value from one column exists in another. Download the Practice ...

How to Vlookup and Pull the Last Match in Excel – 4 Methods

This is a sample dataset with a list of products and their quantity.   Method 1- Applying the LOOKUP Function to Pull the Last ...

How to Remove Apostrophe in Excel?

Unwanted apostrophes can creep into Excel worksheets when copying data from Word or a website, or even from a simple typo. These apostrophes are ...

How to Count Text in Excel (7 Easy Tricks)

In this article, we will explain how to count text in Excel in 7 different ways. Here's an overview of the dataset we'll use to demonstrate our ...

Applying Conditional Formatting for Multiple Conditions in Excel

Here's an overview of using Conditional Formatting for multiple conditions. We have the two data tables, which we'll format. The first table ...

Find Last Value in Column Greater than Zero in Excel

We may need to find the last entry, last purchase, or last order greater than zero while using MS Excel for different purposes. There are many ways ...

How to Apply Conditional Formatting with INDEX-MATCH in Excel: 4 Methods

Method 1 - Using Conditional Formatting with INDEX-MATCH with a Fixed Lookup Value in Excel (Over a Single Column) Steps: Select the column on ...

How to Apply Conditional Formatting to Multiple Columns in Excel – 10 Easy Methods

The sample dataset (B4:F9) contains names of employees, their projects and their working hours on different days. Method 1 - Use the ...

Highlighting Row with Conditional Formatting Based on Date in Excel

Here's the overview of the functions we'll use today and how they highlight cells or rows based on dates or ranges. We have a data table with ...

How to Find Links in Excel ( 8 Suitable Approaches)

In this article, we will discuss 8 suitable approaches to find links in Excel. Excel has tremendous available options to link your working workbook ...

How to Highlight Cells Based on Text in Excel (2 Methods)

Highlighting cells with specific text in MS Excel is useful for easily finding matching text in datasets. Our sample dataset contains a list of ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo