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

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.

VLOOKUP, one of the most useful Microsoft Excel functions, is also available on Google Sheets. Here's how to use VLOOKUP to sift through Sheets data.

Navigating through dozens of sheet name tabs in Microsoft Excel to find the one you need can be quite time consuming. Cut your navigation time in half by creating index sheets that contain a list ...

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.