The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Excel DATEVALUE is a Date and time function, and its purpose is to converts a date in the form of text to a serial number. Learn how to use it.

The DELTA function in Microsoft Excel is an engineering function, and its purpose is to test whether two values are equal. Learn how to use it.

How to use wildcards with the XLOOKUP() function in Excel Your email has been sent Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible. Lookup functions ...

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

When teaching financial accounting, faculty often discuss bonds payable and how to calculate the issue price of a bond. Consider teaching students to calculate the issue price by using the net present ...