Excel Formulas

How to Split Cells in Excel (6 Easy Tricks)

In Microsoft Excel, there are several techniques available to split cells into multiple parts. We can use formulas, tools, or even Power Query to ...

If Value Exists in Column Then TRUE in Excel

In this article, we will discuss receiving ‘TRUE’ as output if one cell value in Excel exists in another column. Basically, when we work with ...

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

How to Remove Apostrophe in Excel?

There may be unwanted apostrophes when we copy tables or data from Microsoft Word or collect data from a website to an Excel worksheet, or maybe for ...

How to Count Text in Excel (7 Easy Tricks)

Sometimes we need to count text in Excel for many purposes. Different excel functions and formulas make this easy for us. In the article, we are ...

Applying Conditional Formatting for Multiple Conditions in Excel

If you are looking for some of the easiest ways to do Conditional Formatting for multiple conditions in Excel, then you will find this article ...

How to Apply Conditional Formatting with INDEX-MATCH in Excel

In this article, I’ll show you how you can apply Conditional Formatting over a data set with the INDEX-MATCH functions in Excel. You’ll learn to use ...

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

Conditional Formatting can be applied on Multiple Columns for quick calculation. The sample dataset (B4:F9) contains names of employees, their ...

Highlighting Row with Conditional Formatting Based on Date in Excel

In this article, I am going to show you how to highlight rows with Conditional Formatting Based on Date in Excel. If you are looking for some of the ...

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

If we highlight cells with specific text while working in MS Excel, it can be very useful for us to find it out easily or will help for many other ...

How to Conditional Format for Dates Within 30 Days in Excel (3 Methods)

The below dataset has 3 columns displaying Order ID, Date, and Amount. Method 1 – Conditional Formatting for Dates within 30 Days for Dates in a ...

How to Compare 4 Columns in Excel (6 Methods)

Method 1 – Using Conditional Formatting  Steps: Select the cells of 4 Columns from the dataset. Go to the Home tab. Select the ...

How to Apply Conditional Formatting for Blank Cells in Excel

While working with a large number of data, numerous blank cells in your dataset is a common scenario. As a result, it can misinterpret your dataset ...

How to Apply Conditional Formatting to the Selected Cells in Excel

Conditional Formatting is a versatile and flexible tool embedded in Excel that enables us to modify and format cells based on various conditions. ...

Conditional Formatting Multiple Text Values in Excel (4 Easy Ways)

Consider a dataset of Product Sales, where we have text value columns named Region, City, Category, and Product. We want to conditionally format the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo