Latest Blog Posts

How to Remove Numbers from a Cell in Excel (7 Effective Ways)

We have placed some Product Names and their IDs in the dataset. We want to remove the numbers from the Product IDs. Method 1 - Using Find ...

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

Null vs Blank in Excel

While working with data in Microsoft Excel, you may encounter Null values or Blank cells. What Is Null in Excel? A null value in a cell ...

How to Do Conditional Formatting Based on Another Cell in Excel (6 Easy Ways)

Below is a database containing the ID, Name, Section, and Total Sales of some Sales Representatives. We will format some cells using conditional ...

How to Check If Cell Is Empty Using Excel VBA: 5 Easy Methods

Method 1 - Using the VBA IsEmpty Function to Check If Cell Is Empty  Steps: Press Alt + F11 on your keyboard or go to the tab Developer -> ...

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 Split a String into an Array in VBA (3 Effective Ways)

In this article, I’ll show you how you can split a string into an array in VBA. Split is one of the most important and widely used functions that we ...

Highlight Duplicates in Excel

In this article, we will learn how to highlight duplicates in Excel, find duplicates, and remove the duplicates in Excel. This option is quite basic ...

How to Use Left Trim Function in Excel: 7 Easy Ways

Some spreadsheets like the following sample dataset require us to trim data from the left. Here, we need to trim the Color from the given Product ...

Using a Macro to Compare Two Columns and Highlight the Differences in Excel – 2 Methods

Method 1 - Using a VBA Macro to Compare Two Columns and Highlight the Differences in Excel This is the sample dataset. Steps: Press Alt ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo