Excel Functions

How to Use ABS Function in Excel (12 Suitable Examples)

The ABS function is one of the default functions of Microsoft Excel. When we work with data to find out the difference, it is natural to get a ...

How to Use XIRR Function in Excel (3 Examples)

If you want to know how to use the XIRR function in Excel, you are in the right place. Here, we will walk you through 3 usages of the XIRR function ...

How to Use Excel EXP Function (5 Examples)

The Excel EXP function is also known as an exponential function. It is mainly a mathematics formula that returns the value of the constant e raised ...

How to Use ROUNDUP Function in Excel (6 Examples)

The ROUNDUP function in Excel rounds a number up or to the higher side either right or left to the decimal point. In this article, you will get to ...

How to Use Excel XOR Function (5 Suitable Examples)

Excel XOR function is an exclusive OR function. The XOR function returns TRUE if an odd number of logical statements are TRUE and FALSE if an even ...

Best value How to Use Excel XOR Function (5 Suitable Examples)

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

The LINEST function is a built-in function in Excel that is categorized as a Statistical Function. It is one of those essential functions. In this ...

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

SUBTOTAL is one of the default functions of Microsoft Excel. This function provides the opportunity to perform a group of Excel function operations. ...

How to Use SQRT Function in Excel

In Mathematics and Trigonometry, we frequently need to know the square root of a number. The square root of an integer is a value that equals the ...

How to Use SHEETS Function in Excel (5 Useful Examples)

How would you feel if you have numerous worksheets in your Excel workbook? In such a situation, Excel provides a useful function to know the number ...

How to Use CONVERT Function in Excel

The CONVERT function is an Excel Engineering function, and it will convert units from one measurement system to another. In this article, we'll go ...

How to Use Excel MONTH Function (6 Examples)

Excel MONTH function is an effective function to extract the month from a given date. This function returns the month as a number between 1 to 12. ...

How to Use CELL Function in Excel (5 Easy Examples)

The CELL function is categorized under the information function in Excel. The CELL function returns information about the cell contents, formatting, ...

How to Use CEILING Function in Excel (With 3 Examples)

The CEILING function as the name suggests rounds up a number to the nearest top integer or the multiple of the specified significance. If you want to ...

How to Use AGGREGATE Function in Excel (13 Examples)

In this article, you will learn about the AGGREGATE function in Excel. Here, you will explore its uses, aggregate data, with multiple criteria, ...

How to Use Excel EXACT Function (6 Suitable Examples)

The Excel EXACT function tests two text strings and returns TRUE or FALSE depending on their exact match or otherwise respectively. The EXACT ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo