Excel Functions

How to Use Excel LARGE Function with Duplicates in Excel

The LARGE function cannot identify the unique nth largest value if duplicates are available in an array. In this article, you will find the nth ...

How to Use COUNTIF & ISNUMBER to Count Numbers in Excel

Microsoft Excel facilitates us to estimate various types of data as well as perform monetary, arithmetic, and statistical computations. Sometimes we ...

Excel ISNUMBER Not Working (3 Reasons with Solutions)

We have to determine whether a cell contains a number value or not in different parts of the Excel formulation. But in a lot of unfortunate cases, ...

How to Use Excel LARGE Function with Criteria (4 Suitable Ways)

In this article, we will learn how to use the LARGE function with criteria in Excel. With the LARGE function, you can get the maximum number from a ...

How to Lookup Next Largest Value in Excel (4 Easy Ways)

We may need to lookup the next largest value in Excel, as we work on a dataset. Excel has functions that can help us to solve this problem. In this ...

How to Use IF with ISNA Function in Excel (3 Ideal Examples)

While working with Excel, we often face #N/A error when the required value is missing from the dataset. But if you want to get rid of this visible ...

Use ISNUMBER Function with IF and Then Statements in Excel

The ISNUMBER function is very useful to find out if a cell value is a number. This function can also be combined with IF and Then statements in Excel ...

How to Use DPRODUCT Function in Excel (6 Practical Examples)

While working in Excel, we often need to use various Database Functions. The DPRODUCT function is one of the most widely used database functions in ...

How to Use FORECAST Function with Multiple Variables in Excel

If you are looking to use the FORECAST function with multiple variables in Excel, then you have come to the right place. Here, we will walk you ...

How to Use EOMONTH Function in Excel (10 Ideal Examples)

Certainly, while working in Excel, we often have dates in the dataset and luckily, Excel has a palette of functions for dealing with dates in the ...

How to Use EDATE Formula for Days (3 Ideal Examples)

The EDATE function is one of the most widely used functions for date calculation. It has multiple uses if it is used with other functions of Excel. ...

How to Use COUNTIF Function with Array Criteria in Excel

While working in Microsoft Excel, sometimes we need to use the COUNTIF function with array criteria. However, it might seem difficult to you when ...

How to Use COMBIN Function in Excel (4 Examples)

Today, we are going to learn about the Excel COMBIN function. This tutorial will provide a complete overview of the COMBIN function in detail, the ...

How to Calculate Working Days in a Month in Excel (3 Ways)

Calculating working days in Excel is often essential for businesses and individuals when planning and tracking tasks. It also helps in determining ...

How to Use COUNTIFS for Cells Not Equal to Multiple Text in Excel

The COUNTIFS function gives you the opportunity to provide more than one criterion and returns the count of cells that meet all the criteria at the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo