Excel Functions

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)

In this tutorial, we’ll unpack the EOMONTH function, how to use it, and how to combine it with other functions. The screenshot above is an ...

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

How to Use AND and OR Functions in Excel (3 Practical Examples)

While working in Excel, we often use the AND function. Sometimes we also use the OR function. There are times when we might need to use both the AND ...

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

An imaginary coefficient with a real coefficient makes up a complex number. Real and imaginary coefficients can be transformed into complex numbers ...

How to Use Excel IMABS Function (5 Practical Examples)

Microsoft Excel is a handy software. We use Excel functions for our educational, business, and other daily purposes. We operate the Excel IMABS ...

How to Use IMAGINARY Function in Excel (3 Examples)

Imaginary numbers are often used for mathematical and scientific analysis. In this article, we will show you how you can use the Excel IMAGINARY ...

How to Use COMPLEX Function in Excel (2 Practical Examples)

Excel is, without a doubt, a powerful software. Using Excel's tools and capabilities, we can carry out continuous operations on whatever dataset we ...

Compatibility Function in Excel (34 Practical Examples)

In this tutorial, I am going to share with you 34 practical examples of compatibility function in Excel. You can easily apply these functions to ...

How to Use Excel IMSUM Function (4 Easy Examples)

This tutorial will demonstrate how to use the Excel IMSUM Function. When we are dealing with complex numbers, we can easily add them with the help of ...

How to Use PERMUT Function in Excel (with an Alternative)

Excel is extremely useful to perform extensive calculations and solve advanced mathematical problems. Now, in mathematics or real life, sometimes we ...

How to Use IMPRODUCT Function in Excel (4 Examples)

Certainly, while working in Excel, we may have to deal with imaginary numbers. Luckily, Excel has a palette of functions for calculating complex ...

How to Use IMDIV Function in Excel (3 Examples)

In Excel, we use the IMDIV function for calculating the quotient value after dividing a complex number by another complex number. In the following ...

How to Use the COMBIN Function in Excel – 4 Examples

This is an overview The Excel COMBIN Function Objective determines the total possible number of combinations in a given number of items. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo