Latest Posts

Insert Rows in Excel Based on Cell Value with VBA (2 Methods)

In this article, I’ll show you how you can insert rows in Excel based on cell value with VBA. You’ll learn to insert rows after each row, as well as ...

Excel Paste Transpose Shortcut: 4 Easy Ways to Use

In this article, we will discuss the Transpose option of Excel Paste Shortcut. In Excel, we generally transpose Rows to Columns or vice-versa. We can ...

How to Convert Text to Date in Excel (10 ways)

If you are looking for some of the easiest ways to convert text to date in Excel, then you will find this article useful. So, let’s dive into the ...

How to Split a Cell into Two Rows in Excel (3 ways)

If in a large dataset multiple information are compacted in one cell, then it is hard to find and lookup data to view or to do any task. In this ...

Invoice Excel Formula

Many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make databases for ...

How to Convert Date to Text Month in Excel (8 Quick Ways)

When we enter a date in Excel then it is possible to extract the month name from the date. This article will guide you with 8 quick useful methods to ...

Delete an Excel Row If a Cell Contains Specific Values (3 Methods)

While working with data in Excel, the deletion of an Excel row is quite a common phenomenon. There are a good number of methods that we can use to ...

How to Convert Text to Number in Excel with VBA (3 ways)

In Microsoft Excel, working with numbers is most common. Sometimes, we have to process a dataset with large amounts of numbers. But, you may find ...

Convert Number (YYYYMMDD) to Date Format in Excel (4 Methods)

You might have the date in your dataset in a format like YYYYMMDD (e.g., today’s date is 20211128) or, as the count of total days since January 1, ...

How to Use Excel COUNTIF That Does Not Contain Multiple Criteria

We are used to applying the COUNTIF function in Excel to count the cells according to given criteria but it’s a little bit difficult to count the ...

Excel Delete Rows in a Range with VBA (3 Easy Ways)

In this article, I’ll show you how you can delete rows in a range with VBA in Excel. You’ll learn to use VBA to delete every nth row, rows with a ...

VBA Macro to Insert Row in Excel Based on Criteria (4 Methods)

Sometimes we need to modify our large dataset in Excel by inserting rows based on certain conditions. Implementing VBA macro is the most effective, ...

How to Convert Number to Date in Excel (6 Easy Ways)

Sometimes in Excel, we input the date but it returns it as a bunch of numbers as it stores the date value as a number. This makes the dataset very ...

Excel Transpose Formulas Without Changing References (4 Easy Ways)

Transpose data means data in Excel's rows are shifted in Excel’s columns where auto-update is necessary or not. Transposing formulas is the same as ...

Excel Formula for The Date Range

Date Range in Excel helps us to do a calculation on date values. In this article, we are going to know more about the Excel Formula for the date ...

ExcelDemy
Logo