Latest Posts

SUMIF with Multiple Criteria for Different Columns in Excel

This article is all about how to SUMIF with multiple criteria for different columns in Excel. While working with Excel, sometimes we need to ...

How to Sum Colored Cells in Excel (4 Ways)

There’re no built-in Excel functions that sum up the colored cells in Excel by themselves. Yet multiple ways can manage to sum up the cells based on ...

How to Calculate Horizontal Running Total in Excel (3 Ways)

A running total is the total of a series of numbers that updates each time a new number is added to the sequence. It can be calculated by summing up ...

Does TABLE Function Exist in Excel?

In Microsoft Excel, a Table is a tremendously instrumental tool to process large amounts of data with ease. It saves a lot of time and reduces a lot ...

Cumulative Sum in Excel If Condition Applied (6 Methods)

Cumulative summation is one of the most used operations throughout the world to keep track of data related to similar things. Cumulative summation ...

How to Remove Spaces in Excel: With Formula, VBA & Power Query

In Microsoft Excel, there are several effective methods available to remove all sorts of unwanted spaces. You’ll get to know all possible and ...

How to Calculate Running Total in Excel (9 Ways)

If you are looking for some of the easiest ways to calculate the running total in Excel, then you will find this article useful. Running total means ...

How to Remove the First Character from a String with VBA in Excel

In this article, I will show you how you can remove the first character from a string with VBA in Excel. You’ll learn two easy procedures to remove ...

Remove Last Character from String Excel (5 Easy Methods)

In instances, we come across additional data attached to the right of entries. We badly want to remove them. But doing it manually is a hideous task. ...

How to Fill Color in Excel Cell Using Formula (5 Easy Ways)

In a worksheet, you may need to fill color in different cells depending on the formula used in the sheets. I’m going to explain different ways of how ...

SUMIFS Multiple Criteria Along Column and Row in Excel

Excel is part and parcel of our daily life. When we think about data, the first thing that comes to our mind is Excel. We can do all sorts of data ...

VBA to Remove Numbers from String in Excel (4 Methods)

While working with a large dataset, sometimes you may need to remove certain numbers from the data. To do this manually is really time consuming and ...

How to Delete Infinite Rows in Excel (5 Easy Ways)

There’s something common and irritating about spreadsheets with unnecessary rows or blank rows. But the good news is there are lots of ways to get ...

How to Add Space between Rows in Excel

To add space between rows, we need to insert blank cells between them. We can do it manually by right-clicking, pressing the keyboard shortcut, or ...

Excel Formula Based on Cell Color (5 Examples)

You might have a colorful dataset and you would like to use the cell color to work with the Excel formula. Excel has a lot of amazing bunches of ...

ExcelDemy
Logo