Excel Functions

How to Use SUMIF Function to Sum Not Blank Cells in Excel

Summing is one of the most performed operations in Excel. In Excel, there are multiple functions that you can use to sum values. Among these, the ...

How to Use DSTDEVP Function in Excel (2 Suitable Examples)

Are you looking for an Excel function that will return the standard deviation of the entire population and also match the given criteria? In this ...

How to Use Excel SUMIF to Sum Values Greater Than 0

When working with large datasets in Excel, it is often necessary to sum values that meet a certain condition. One useful function for this purpose is ...

How to Use Excel DMAX Function (2 Easy Examples)

Excel is a powerful software as it has predefined functions and numerous features. These functions make the excel experience smoother and more ...

How to Use NPER Function in Excel (3 Relevant Examples)

Financial analysts frequently want to know the duration of repayment time while making a business deal. Therefore, if you are a financial analyst, ...

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 NOMINAL Function in Excel

Microsoft Excel is a handy software. We use Excel functions for our education, business, and financial analyses. Moreover, in light of the effective ...

How to Use DB Function in Excel (2 Ideal Examples)

When we assess any asset of a business, depreciation cost means the decrement of the value of the asset. The DB function is a Financial Function in ...

How to Use DVAR Function in Excel (2 Suitable Examples)

You can employ the Excel database functions to help you when using an Excel dataset. Sometimes, you may need to find the variance due to some ...

How to Use ODD Function in Excel (4 Easy Examples)

There are lots of functions in Excel to perform specific tasks. One of them is this ODD function. We use this function to get odd values. In this ...

How to Use DEVSQ Function in Excel (3 Suitable Examples)

In this article, we will show how to use the DEVSQ function in Excel. The DEVSQ function is used to calculate the sum of squares of deviations of ...

How to Use DSTDEV Function in Excel (3 Practical Examples)

In this tutorial, I am going to show you 3 practical examples of how to use the DSTDEV function in Excel. Specifically, you can quickly use these ...

How to Use DMIN Function in Excel (4 Suitable Examples)

In many situations, we need to use the DMIN function to find the minimum value in a range of cells based on criteria. In the following article, we ...

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 DOLLAR Function in Excel (5 Suitable Examples)

If you are looking for some special tricks to know how to use the DOLLAR function in Excel, you've come to the right place. We’ll show 5 suitable ...

Advanced Excel Exercises with Solutions PDF