Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

The reference created using the INDIRECT function will stay the same, even if your sheet's structure changes. By default, references in Excel use the A1 reference style, which means that it refers to ...

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

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Excel and Google Sheets have three functions to calculate the internal rate of return: IRR, XIRR, and MIRR. Learn how these functions can calculate investment returns.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.

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

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

SERIESSUM function returns the sum of a power series based on the formula. Learn how to use the SERIESSUM function in Excel.