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

You use these functions when you want to find values based on the value in a corresponding cell. Thanks to the newish dynamic array function XLOOKUP (), you now have more power and less confusion.

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

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

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

If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.

How to Use the Countif & Countifs Functions in Excel. Microsoft Excel 2010 is a powerful spreadsheet program that business owners can utilize to track everything from employee's schedules to ...

The REGEX functions are available for people using Excel for Microsoft 365 on Windows or Mac, as well as those using Excel for the web.

The first is a basic translation of several cells in Excel, while the second example shows you how to use the TRANSLATE function dynamically with a drop-down list.

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