How to Calculate T-Value From Mean & Standard Deviation in Excel. Calculate t-values in your Microsoft Excel spreadsheet by combining built-in functions with custom formulas. T-values, also known ...

Calculating the IRR for a project with an initial outlay and single cash flow is very easy to do. It's also very practical for measuring the returns.

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.

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.

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