Latest Blog Posts

How to Remove Panes in Excel (4 Methods)

Panes allow you to freeze one portion of your Excel datasheet and scroll the other portion separately. Though it is a useful feature, you may need to ...

How to Sort Merged Cells in Excel: 2 Easy Methods

Method 1 - Unmerge First to Sort Merged Cells in Excel 1.1 Single Column Steps: Part-1 Select the cells that we need to sort. Click on the ...

How to Add Blank Space in Excel Formula: 6 Suitable Methods

The image below shows the worksheet that we are going to work with. Method 1 - Add Blank Spaces Trailing Text Values in Excel We'll use ...

Pivot Table Custom Grouping: With 3 Criteria

We will use the following dataset to explain Custom Grouping in a Pivot Table. What Is the Pivot Table in Excel? A pivot table is one of ...

How to Add Filter in Excel (4 Simple Methods)

Consider the following data as a product price list. We have added a filter to the data. The drop-down icons at the right-bottom corners of the ...

Fix: Excel Remove Duplicates Not Working (3 Solutions)

Reasons Why Excel Is Not Recognizing Duplicates Digits After Decimal: For example, 5 and 5.00 are the same. But MS Excel counts them as two ...

How to Filter Unique Values in Excel (8 Easy Ways)

Let’s say we have three simple columns in an Excel dataset containing Order Date, Category, and Product information. We want the unique ordered ...

How to Merge Text from Two Cells in Excel (7 Methods)

We’ll use the following dataset, with a list of first and last names. We'll merge those into full names in column D. Method 1 - Merging ...

How to Sort a Table in Excel using VBA (4 Methods)

Things to Know Before Implementing VBA to Sort a Table in Excel Before implementing VBA to sort a table in Excel, there are some parameters you need ...

How to Sort a Column Using VBA in Excel (4 Methods)

Range.Sort Method in Excel VBA The Range.Sort method in Excel VBA allows you to sort a range of values. The Range object variable specifies the ...

How to Insert Column with Excel VBA (4 Ways)

In this article, I’ll show you how you can insert a single column or multiple columns within a data set using VBA in Excel. I’ll give all the VBA ...

How to Link Tables in Excel (3 Easy Methods)

Method 1 - Link Tables Using Pivot Tables in Excel In our dataset, we will use two different tables from two different sheets. Sheet1 contains the ...

How to Remove Header and Footer in Excel (6 Methods)

Consider you have the following dataset with a Header. The dataset also has a Footer. Let's remove the Header and Footer from this ...

How to Use VBA StrComp Function in Excel (5 Common Examples)

In our daily life, we need to compare different things. In Excel, we have some built-in functions to perform this kind of comparison. The StrComp is ...

How to Use IsNull Function in Excel VBA (5 Examples)

Identifying the errors isn't the simplest thing in the world, and spotting them in the middle of a large spreadsheet is nearly burdensome. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo