How to Calculate Average on Excel From Multiple Sheets. Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook.

If you have a recent pay stub, you can use Microsoft Excel to calculate your annual salary, as well as estimate how much a raise will affect your paychecks.

Q. When I’m working in Excel, I sometimes have trouble remembering a formula. Is there an instant crib sheet I can refer to? I know I can look it up in Help , but that’s such a slow process. A. Yes, ...

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

The article How to calculate conditional subtotals in an Excel revenue sheet uses simple expressions, a function, and a conditional format to display a daily balance in a revenue sheet.