Latest Blog Posts

How to Filter in Excel with Merged Cells (Step-by-Step Procedure)

  We will use a dataset of Product Names in merged cells to demonstrate how you can filter based on them. Steps Select the table ...

How to Remove Text from an Excel Cell but Leave Numbers (8 Ways)

  Method 1 - Using Find and Replace to Remove Text from Excel Cell but Leave Numbers Steps: Create a helper column. Copy the values ...

How to Calculate Year over Year Growth with Formula in Excel (2 Methods)

In this article, we will learn to calculate Year-over-Year (YoY) Growth with a formula in Excel. We need to calculate the year-over-year growth to ...

How to Split Data into Equal Groups in Excel (3 Methods)

  We can split data in different ways, i.e., how many groups you want or how many cells each group needs to contain. To show all the methods, ...

How to Interpolate Between Two Values in Excel (6 Ways)

In the dataset, we have some X Coordinates and Y Coordinates. We'll interpolate the value for given coordinates. Method 1 - Using the ...

How to Find and Replace the Asterisk (*) Character in Excel – 4 Methods

The dataset below showcases employees' details with an ‘*’ in column B. To replace the ‘*’ with ‘,’ in column C: Method 1 - Use the ...

How to Use VBA Code to Find Duplicate Rows in Excel: 3 Methods

Method 1 - Utilizing Range.Offset Property in VBA Code to Find Duplicate Rows in Excel Steps: From the Developer tab >>> select Visual ...

How to Extract Data from Cell in Excel (5 Methods)

Consider the following Student Information List, which shows Serial No, Student ID, and E-mail ID columns. We will use 5 different methods to extract ...

How to Highlight a Column in Excel (3 Methods)

When you work on a large set of data, sometimes it is difficult to track where your cursor is and what kind of data you are looking for. To minimize ...

How to Fill Cell with Color Based on Percentage in Excel (6 Methods)

Here's a dataset that contains the percentage of a company's sales from different months. We'll fill those cells with colors depending on the ...

How to Extract Data from Excel to Word (4 Ways)

The sample dataset represents sales in two consecutive Months and Total Sales. Method 1 - Using Paste Special to Extract Data from Excel ...

How to Change Cell Color Based on a Value in Excel (5 Ways)

Method 1 - Dynamically Change Cell Color Based on a Value Consider the following dataset that shows U.S. state populations. We'll divide the ...

How to Highlight Every 5 Rows in Excel (4 Methods)

In this article, we will demonstrate how to highlight every 5 rows in an Excel workbook using 4 different methods. We'll use the following dataset of ...

Table Column Reference by Header in Excel VBA – 6 Methods

This is the sample dataset: Method 1 - Reference a Table Column by Header in Excel VBA Steps: Press Alt + F11 or go to the Developer ...

How to Format a Number in Thousands K and Millions M in Excel (4 Suitable Ways)

We'll use the following simple dataset to showcase formatting a number in terms of thousands with K and millions with M. Method 1 - Use a ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo