Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

The MEDIAN calculation function sorts through the provided values/arguments to find the value that falls arithmetically in the middle of the group.

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.

How to Calculate Multiple Cells in Excel. Microsoft Excel is a spreadsheet program used to store and analyze data. While Excel is able to hold both text and numerical data, most of the pre ...

With Excel and data from your broker, however, calculating the average return is fairly easy using the XIRR function. How to calculate average stock returns in Excel ...

Learn what Value at Risk is, what it indicates about a portfolio, its pros and cons, and how to calculate the VaR of a portfolio using Microsoft Excel.

How to Calculate a Running Total in Excel Learn to create cumulative sums in Microsoft Excel with these step-by-step instructions and screenshots.

One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.