ExcelDemy - Free Excel Tutorial & Online Courses

FindNext using VBA in Excel (2 Examples)

Dec 4, 2021 Uncategorized

If you are working with Microsoft Excel's VBA, you know how much time it can save. You may feel that VBA codes are complex to write. But once you ...

How to Use SUMIFS to SUM Values in Date Range in Excel

Dec 4, 2021 Uncategorized

To calculate sum values with conditions in a date range is a very common and tricky task in Excel. But Excel has the SUMIFS function to do this job ...

How to Use SUMIF with Text in Excel (9 Easy Ways)

Dec 3, 2021 Uncategorized

In our day-to-day life, we probably just want to sum cells quickly based on text criteria. Like, if you have a list of products and want to calculate ...

COUNTIF Date Is within 7 Days

Dec 2, 2021 Uncategorized

Sometimes we need to count if the date is within 7 days from the dataset for quick calculation. In this case, we need to use some Excel formulas with ...

How to Rename Sheet with VBA in Excel (Both Single and Multiple Sheets)

Dec 5, 2021 Macros & Excel VBA

In this article, I’ll show you how you can rename the sheet with VBA in Excel. You’ll learn to rename both a single sheet and a group of sheets with ...

How to Convert Table to List in Excel (3 Quick Ways)

Dec 2, 2021 Uncategorized

While you are working in excel with a data table, you may need to convert a table (with row headings and column headings) to a flat list in Excel for ...

How to Use SUMIFS formula with Multiple Criteria in Excel (11 Ways)

Dec 2, 2021 Excel Formulas

If you are looking for some of the easiest ways to use the SUMIFS formula with multiple criteria, then you will find this article useful. Sometimes ...

How to Use SUMIF with OR Logic in Excel (10 Methods)

Dec 2, 2021 Excel Formulas

By using the SUMIF function you can sum values based on a single condition or criteria like other cells being equal to either one value or another. ...

How to Sum Between Two Numbers Formula in Excel

Dec 2, 2021 Excel Basics

Every now and then we need to find out the sum of data for a range between two numbers in Excel. In this article, we use functions such as SUMIFS, ...

How To Compare Two Cells in Excel (10 Easy Methods)

Dec 2, 2021 Uncategorized

There are many ways to compare cells in Excel. You can compare two cells and find matches, differences and some other operations using Excel. In this ...

How to Delete Duplicates in Excel but Keep One (7 Methods)

Dec 2, 2021 Excel Basics

Excel is one of the widely used tools we use for our office and business. For most of those works, we need to deal with a large amount of data. ...

SUMIF vs SUMIFS in Excel

Dec 2, 2021 Uncategorized

While working with Microsoft Excel, the SUM function is one of the essential functions that everyone uses. We use this function in a lot of ...

Excel Formula to Split: 8 Examples

Dec 2, 2021 Uncategorized

Excel formula helps us to split a cell or a text string or a column. This makes the dataset more readable and easily accessible to the correct ...

Macro to Delete Row in Excel If Cell is Blank

Dec 1, 2021 Macros & Excel VBA

In this article, I’ll show you how to develop and run a Macro in Excel to delete a row if the cell is blank. You’ll learn all the steps from opening ...

Lookup Value in a Range and Return in Excel (5 Easy Ways)

Dec 1, 2021 Excel Basics

If you want to look up certain criteria in a range and find the matching value, this article is the right place for you. I’ll show you 5 easy ways to ...

Latest Posts