Excel Formulas

Conditional Formatting Based On Another Cell Range in Excel

If you are looking for some of the easiest ways to do Conditional Formatting based on another cell range in Excel, then you are in the right place. ...

Excel Conditional Formatting Formula with IF

Method 1 - Simple Conditional Formatting Formula with IF in Excel Consider a sample dataset of Products with their purchase and sold amounts. You ...

How to Change Row Color Based on Text Value in Cell in Excel

While dealing with a huge database you may need to change the row color of some specific cells based on a text value to identify them quickly. Excel ...

Conditional Formatting on Multiple Rows Independently in Excel

Conditional Formatting is one of the essential tools in Microsoft Excel. Analyzing data, creating insights, and other things that we can do using ...

How to Compare Two Excel Sheets for Differences in Values

When we have two versions of the same workbook, the first thing that crosses our mind is to compare them and find the differences in values between ...

How to Check If a Value is in List in Excel (10 Ways)

If you are looking for some of the easiest ways to check if a value is in a list in Excel, then you are in the right place. To check out your desired ...

Conditional Formatting Based on Multiple Values of Another Cell

In this article, I’ll show you how you can apply Conditional Formatting in Excel based on multiple values of another cell. You’ll learn to apply ...

How to Calculate Average in Excel (Including All Criteria)

In Microsoft Excel, there are several ways to calculate an average of a range of data. In this article, we’ve tried to include all possible criteria ...

How to Remove Carriage Returns in Excel: 3 Easy Ways

In this article, we will discuss some methods to remove carriage returns in Excel; including VBA. Often, we copy data from web pages or other ...

How to Remove the Page Break Lines in Excel (3 Ways)

In Excel, the page break lines are dividers that split a worksheet into multiple pages for the sake of printing. These page breaks are automatic that ...

Excel Find Duplicate Rows Based on Multiple Columns

Sometimes we need to find and highlight duplicate rows based on multiple columns in Excel. It makes the huge dataset attractive and easy to ...

How to Split Excel Sheet into Multiple Sheets Based on Column Value

If you are looking for some of the easiest ways to split an Excel sheet into multiple sheets based on column value, then you will find this article ...

How to Delete Empty Cells in Excel (8 Easy Methods)

Certainly, to delete empty cells is quite a common and basic task that we might need to do frequently in Excel. Luckily, there are multiple ways ...

How to Count Duplicate Rows in Excel (6 Ideal Examples)

While dealing with a large amount of raw data in Microsoft Excel, we often find duplicate cells, rows, or columns. Sometimes we face the necessity to ...

How to Compare Two Columns Using Conditional Formatting in Excel

One of the essential tools of Excel is Conditional Formatting.  Conditional formatting highlights interesting cells or ranges of cells, indicates ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo