Excel includes a number of these functions that you can use to not only to make working with spreadsheets faster, but also to help ensure your accuracy. These functions let you code the ...

Functions of Different Categories in Excel. To analyze your company's payroll expenditures, you might create an Excel spreadsheet and use some of the functions in the Financial or Math ...

How to Use Trig Functions in Excel. Excel has built-in functions for sine and cosine, the two core trigonometric functions, and for hyperbolic sine and hyperbolic cosine, their hyperbolic ...

Discover 7 powerful Excel functions that will revolutionize your workflow, automate tasks, and save you hours of time. From ...

Currently, the GROUPBY function is available only in Microsoft Excel 365. If you would like to follow along in using this function, you can download this Excel workbook and view the video at the end ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.

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

Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.

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

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.