Excel Formulas

INDEX-MATCH with Duplicate Values in Excel (3 Quick Methods)

  Method 1 - Finding Duplicate Values in Excel with INDEX, MATCH, IF, and COUNTIF We have input some salespersons’ states and sales in the ...

How to Remove Print Lines in Excel (4 Easy Ways)

While working in excel, print gridlines are shown sometimes when you return to the normal view from the page break preview or page layout view. This ...

How to SUMIF for Multiple Criteria Across Different Sheet in Excel

Excel is the most widely used tool for dealing with massive datasets. If you have data across different sheets and want to sum those data based on ...

How to Remove Strikethrough in Excel (3 Ways)

Even though strikethrough cells are readable, it is uncomfortable for many readers. Also, erasing strikethrough can be cumbersome if we consider a ...

How to Remove Extra Spaces in Excel (5 Easy Ways)

Certainly, Microsoft Excel has a wide range of professional applications. In fact, we use Excel to manage data, process it, and get valuable ...

How to Remove Parentheses in Excel?

While dealing with data in Microsoft Excel, there may be unnecessary parentheses within it. No doubt, we would like to learn some easy and fast ...

How to Insert a Total Row in Excel (4 Easy Methods)

Total row in Excel helps us get a quick summary of different columns from a table or a range of cells. In this article, I’ll show you 4 easy and ...

How to Remove Space Before Text in Excel (4 Methods)

  How Space Before Text Affects the Dataset? Space(s) before the text can create a lot of trouble to analyze a dataset. It may give you wrong ...

How to Convert Serial Number to Date in Excel (7 Simple Ways)

For one thing, Excel by default stores time and dates in serial numbers which are converted to dates only by changing the formatting of the cells. ...

Split String by Character in Excel (6 Suitable Ways)

Sometimes you may have a dataset where different kinds of data are inserted in a cell and separated by a character such as a delimiter, a hyphen, a ...

How to Calculate Date Range in Excel (4 Ideal Methods)

In this article, I will discuss how to calculate a date range in Excel. Usually, calculating the date range is quite more complex than other ...

How to SUM with IF Condition in Excel (6 Suitable Examples)

Sometimes we need to sum up values based on criteria in Excel. To meet up this requirement, Excel has embedded itself with a built-in function called ...

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

This tutorial uses a dataset for Product Name, Salesperson, and Profit, as shown below: Download Practice Workbook You can download the ...

COUNTIF Date Is within 7 Days

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 Use SUMIFS Formula with Multiple Criteria in Excel

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo