Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

It is possible to make the Sum Excel formula reference another sheet, or multiple sheets, and add up a range of cells across those sheets.

Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook. Before you apply this formula, check that each worksheet is formatted the same way.

In Excel, the INDEX function returns an item from a specific position (in a list, table, database). The MATCH function returns the position of a value (in a list, table, database).

This cheat sheet gets you up to speed on the features that were introduced in Excel 2016 and Excel 2019, the perpetual-license versions of Excel included with Office 2016 and Office 2019 ...

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.