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.

On the Analysis sheet in cell A2, enter this formula: =+Company!A2. (The easy way to do this is to go to your cell, type the equal sign to start the formula, then click on the Company sheet name ...

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.