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

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies in Microsoft Excel.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

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.