Excel Formulas

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

INDEX-MATCH with Duplicate Values in Excel (3 Quick Methods)

  Method 1 - Finding Duplicate Values in Excel with INDEX, MATCH, IF, and COUNTIF We have input some salespersons’ states and sales in the ...

How to Remove Print Lines in Excel (4 Ways)

We have a dataset with some dotted-lined borders. These page break lines show how much of the worksheet will be printed on a single paper. We need to ...

How to use the SUMIF function with Multiple Criteria in Different Sheets in Excel – 3 Methods

This is an overview: The sample dataset showcases records of quarterly sales in three different sheets: Quarter 1, Quarter 2, and Quarter ...

How to Remove Strikethrough in Excel (3 Ways)

To demonstrate our methods for removing strikethroughs from text in Excel, we'll use the following dataset: Method 1 - Using Keyboard ...

How to Remove Extra Spaces in Excel (5 Easy Ways)

This article describes 5 ways to remove extra spaces in Excel. Here is an animated overview: We'll use the dataset below, and remove ...

How to Remove Parentheses in Excel?

In this article, we will demonstrate 4 easy methods to remove parentheses in Excel. What Are Parentheses in Excel? In general, ...

How to Insert a Total Row in Excel (4 Easy Methods)

We have a sample dataset below of different items, their prices, quantities purchased, and total prices. We will insert a total row in this dataset ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo