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.

Microsoft Excel's spreadsheet design allows you to quickly calculate values separated into two columns and replicate this calculation without having to manually recreate the formula for each row.

How to Calculate the Average Return for the Share of Stock in Excel Credit: Next, I need to fill in all the other cash flows I've received from my Microsoft investment.