Excel Functions

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 EDATE Formula for Days: 3 Ideal Examples

Method 1 - Returning Date After Specific Months Using EDATE Formula We will show the basic use of the EDATE function. Our dataset includes the Date, ...

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 the COUNTIF Function with an Array Criteria in Excel

In the dataset below, we have Employee Names, Working Days and employee Status according to performance. We will apply the COUNTIF function with an ...

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

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

Indeed, Microsoft Excel is a highly effective program. We can execute continuous operations on a given dataset using Excel's tools and capabilities. ...

How to Calculate Working Days Excluding Sundays in Excel

If you are looking for how to calculate working days in Excel excluding Sundays, then you are in the right place. In every office and other ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo