ExcelDemy - Page 2 of 82 - Free Excel Tutorial & Online Courses

How to Remove Empty Rows in Excel (11 Methods)

Dec 1, 2021 Excel Formulas

In a large worksheet, there remains a possibility of having empty rows. From this article, you will get to know how to remove empty rows in excel. ...

Convert Text to Date and Time in Excel (5 Methods)

Dec 1, 2021 Excel Basics

In Excel, we mainly work with data. We organize and manipulate data as per our requirements. We find out the required information from our managed ...

Excel VBA Code to Delete Rows Based on Multiple Cell Value (3 Criteria)

Nov 30, 2021 Macros & Excel VBA

In this article, I’ll show you the VBA code to delete rows in Excel based on multiple cell value. You’ll learn to delete rows when multiple cells ...

Excel Formula to Split One Column into Multiple Columns (4 Examples)

Nov 30, 2021 Uncategorized

Excel formulas help us to find value from a long column by splitting one column into multiple columns. These make the dataset more readable and ...

How to Create and Use ColorFunction in Excel

Nov 30, 2021 Excel Formulas

In Excel, there is no function to make calculations based on the color of the cells. But by using Microsoft Visual Basic for Applications (VBA) it is ...

Excel SUMIF with a Date Range in Month & Year (4 Examples)

Nov 30, 2021 Uncategorized

Working with date-based data is one of the most common uses of Microsoft Excel. We perform various calculations based on dates. We use various ...

How to Use SUMIFS with Date Range and Multiple Criteria (7 Quick Ways)

Dec 2, 2021 Uncategorized

Working on Excel, you may often need to sum numbers within specific dates. This article will provide you with 7 quick methods to apply the SUMIFS ...

How to Calculate Years Between Two Dates in Excel (2 Methods)

Nov 30, 2021 Uncategorized

It is quite a common incident to work with dates while working in Excel. Very often we may need to calculate dates or years between two given dates. ...

Excel Create Dynamic List from Table (3 Easy Ways)

Nov 30, 2021 Excel Basics

In general, lists are made by extracting entries from a dataset. If the lists update automatically then the lists are dynamic lists. In this article, ...

How to Split String by Length in Excel (8 Ways)

Nov 30, 2021 Uncategorized

If you are looking for some of the easiest ways to split string by length in Excel, then you are in the right place. So, let’s get started with this ...

How to Split String by Length in Excel (8 Ways)

Excel Formula to Get First 3 Characters from a Cell(6 Ways)

Nov 30, 2021 Excel Formulas

Sometimes when data is copied from another source then there is a possibility of having a couple of information compact together. For this type of ...

VBA to Transpose Array in Excel (3 Methods)

Nov 30, 2021 Macros & Excel VBA

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

How to Delete Blank Rows in Excel (10 Methods)

Nov 30, 2021 Excel Basics

Imagine a case when you have a set of data in an Excel worksheet, and you see some unnecessary blank rows. No doubt, such unexpected empty rows annoy ...

How to Delete Blank Rows in Excel (10 Methods)

How to Rotate Text in Excel ( 3 Easy Techniques)

Nov 30, 2021 Uncategorized

By default, Excel cells store horizontally aligned text. But for our purposes, very often we need to change the orientation of the text in cells from ...

How to Wrap Text in Excel (4 Easy Techniques)

Nov 30, 2021 Uncategorized

When a text length is greater than a cell length, some part of the text becomes invisible due to the lack of enough space allocated for the text. To ...

Latest Posts