Latest Posts

OFFSET Function to Create & Use Dynamic Range in Excel

Dynamic range in Microsoft Excel is commonly used to store a wide range of data by applying the OFFSET function. This stored data with a defined name ...

How to Filter Data in Excel using Formula

To filter data in Excel is quite usual, often you need to filter data to find the sets of data you require to operate a particular operation. Today ...

Excel Filter Data Based on Cell Value (6 Efficient Ways)

Sometimes data in a worksheet is too complicated or crammed that we face difficulties to find out desired data. Retrieve data from a dataset ...

Excel Compare Text in Two Columns (7 Fruitful Ways)

Comparing text in two columns in Excel is a significant task in our daily life especially when you have to find something compared to the given text. ...

3 Easy Ways to Sum Top n Values in Excel

Today I will be showing how you can sum any top n values from a data set in Microsoft Excel. Download Practice Workbook 3 Easy Ways to Sum Top n ...

Excel Compare Two Lists and Return Differences (7 Ways)

Sometimes we need to compare two lists in Excel for various purposes. In Excel, the list can be presented in two ways. It can be column-wise or ...

Excel Compare Two Strings for Similarity (3 Easy Ways)

You may need to compare two strings to complete your task. In Excel, you can do that easily. Today we are going to show you how to compare two ...

How to Add 30 Days to a Date in Excel (7 Quick Methods)

In Microsoft Excel, by using different functions you can easily add 30 or any number of days to a particular date. In this article, you'll learn a ...

Sum with INDEX-MATCH Functions under Multiple Criteria in Excel

While working with a large amount of data in Excel, it’s very common to use INDEX-MATCH functions to lookup parameters under multiple criteria for ...

Reference Operator in Excel [Basics + Special Uses]

It is highly unlikely that you'd be an Excel user without having heard of reference operators. We use these essential operators frequently. And this ...

Excel Top 10 List with Duplicates

For different purposes, you may need to find the top n number of values in Excel, n can be 5 or 10 and many more. Today we are going to show you how ...

How to Find Top 5 Values and Names in Excel (8 Useful Ways)

Microsoft Excel has provided numerous ways to determine the top 5 values or names or both from a huge range of data. In this article, you’ll get to ...

Excel If Statement with Multiple Conditions in Any Range

Today I will be showing how you can use Excel’s IF function with multiple conditions in any range. Download Practice Workbook Excel If Statement ...

SUMIFS Multiple Criteria Different Columns (6 Effective Ways)

Sometimes we may need to get a summation based on different criteria. For this purpose, Excel provides a function called SUMIFS. This is the updated ...

Excel Find Similar Text in Two Columns

Depending on the circumstances you may need to find similar text within two columns in Excel. Today, we are going to show you how to find similar ...

ExcelDemy
Logo