ExcelDemy - Page 114 of 240 - Free Excel Tutorial & Online Courses

How to Add Filter in Excel (4 Methods)

May 23, 2022 Advanced Excel

A Filter is a useful tool that helps us display only the specified values in Excel. Based on the filtered result, we can later edit, copy, chart, or ...

Fix: Excel Remove Duplicates Not Working (3 Solutions)

Mar 30, 2022 Excel Basics

Trying to remove duplicates and it’s not working in your Excel worksheet? This article will explain the possible reasons behind the issue and will ...

IF with AND in an Excel Formula (7 Examples)

Feb 11, 2022 Excel Formulas

In Microsoft Excel, combining multiple functions to get output is everyday work. We use various operators to extract a particular result from a ...

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

May 23, 2022 Advanced Excel

Filter Unique is an effective way to get around with numerous entries in a dataset. Excel offers multiple features to filter unique data or remove ...

Combine Texts from Two Columns in Excel (6 Easy Tips)

May 23, 2022 Excel Basics

Sometimes while using Excel we feel the need to combine columns containing text. There are some quick and easy methods to combine texts from two ...

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

May 23, 2022 Excel Basics

Sometimes we need to merge multiple cells into one for getting the desired output. Undoubtedly, Excel provides some quickest features to do that. In ...

VBA to Sort Table in Excel (4 Methods)

Mar 7, 2022 Macros & Excel VBA

Implementing VBA macro is the most effective, quickest, and safest method to run any operation in Excel. In this article, we will show you how to ...

VBA to Sort Column in Excel (4 Methods)

Mar 2, 2022 Macros & Excel VBA 1

To sort in Excel with VBA, you need to apply the Range.Sort method. In this article, we will show you how to sort the column in Excel with the ...

How to Insert Column with Excel VBA (4 Ways)

Feb 28, 2022 Macros & Excel VBA

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)

Apr 21, 2022 Excel Formulas

Excel Table helps us to represent our data easily. Sometimes, we need to Link Tables in Excel. We can do this in the same worksheet as well as from ...

How to Merge Text Cells in Excel (9 Simple Methods)

May 23, 2022 Excel Basics

Sometimes we need to combine Excel text cells to make it more sense or to analyze data correctly. In this article, we’ll show you the effective ways ...

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

May 11, 2022 Excel Basics

Header and Footer contains different information of a document such as chapter name, author name, page number, publisher logo etc. in the top and ...

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

Apr 13, 2022 Macros & Excel VBA

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

How to Add Two Columns in Excel (2 Easy Methods)

May 10, 2022 Excel Basics

Sometimes we need to combine two columns in excel to make our data more organized. This article shows 2 quick and easy ways to add two columns in ...

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

May 23, 2022 Macros & Excel VBA

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

Latest Posts