ExcelDemy - Free Excel Tutorial & Online Courses

SUMIF with Multiple Criteria for Different Columns in Excel

Nov 28, 2021 Excel Formulas

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)

Nov 28, 2021 Advanced Excel

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)

Nov 28, 2021 Excel Formulas

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?

Nov 28, 2021 Uncategorized

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)

Nov 28, 2021 Excel Basics

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

Nov 28, 2021 Excel Formulas

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)

Nov 25, 2021 Excel Formulas

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

Nov 25, 2021 Macros & Excel VBA

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)

Nov 25, 2021 Excel Basics

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)

Nov 25, 2021 Excel Formulas

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

Nov 25, 2021 Excel Formulas

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)

Nov 25, 2021 Macros & Excel VBA

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)

Nov 25, 2021 Macros & Excel VBA

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

Nov 25, 2021 Macros & Excel VBA

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)

Nov 25, 2021 Excel Formulas

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 ...

Latest Posts