Excel Formulas

Conditional Formatting Based On Another Cell Range in Excel

Here's an overview of using Conditional Formatting based on another cell range. We have two data tables. The first table has Sales values for ...

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

We'll use the following simple dataset to showcase how to change row colors based on text values inside cells. Change the Row Color Based ...

Conditional Formatting on Multiple Rows Independently in Excel

Method 1 - Use of the Conditional Formatting Command for Multiple Rows Steps ① Select the range of cells D5:F10. ② From the Home tab, go ...

How to Compare Two Excel Sheets for Differences in Values

Here, we have used the view side-by-side command to compare two Excel sheets to find the differences in values. How to Compare Two Excel ...

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

Consider a dataset about some products of a company. We will check whether specific values in the Product column exist. Method 1 - Using ...

Conditional Formatting Based on Multiple Values of Another Cell

Method 1 - Conditional Formatting on a Single Column Based on Multiple Values of Another Cell Step 1: Select Column and Open Conditional Formatting ...

How to Calculate the Average in Excel – 11 Methods

Download Practice Workbook Download the Excel workbook. Calculate Average.xlsx Method 1 - Calculating the Simple Arithmetic Average of ...

How to Remove Carriage Returns in Excel: 3 Easy Ways

Method 1 - Delete Carriage Returns Using Find and Replace Steps: Select the cells containing line breaks. Press Ctrl+H from the ...

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

What Are the Page Break Lines? Page break lines divide an Excel worksheet into separate pages for printing. There are two types of page break lines: ...

How to Find Duplicate Rows Based on Multiple Columns in Excel

Method 1 - Using the COUNTIFS Function We will use the following dataset for this method. STEPS: Select the cell range. Go to the ...

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

Here's an overview of using slicers to filter a table by specific value. Read on to learn more. Split Excel Sheet into Multiple Sheets ...

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

In this tutorial, we'll be covering some easy ways to delete empty cells in Excel. We'll use the following dataset (a sample student mark sheet) and ...

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

Eaxample 1 - Use COUNTIF Function to Count Duplicate Rows for Single Condition 1.1 Count Duplicate Rows Considering First Occurrence We have a ...

How to Use Conditional Formatting to Compare Two Columns in Excel

Conditional formatting allows you to change the appearance of cells based on specific criteria that you define. When the conditions are met, the cell ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo