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 ...

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

To calculate statistical variance in Microsoft Excel, use the built-in Excel function VAR.

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

How to Calculate the Midpoint of Two Dates in Excel. When you enter a number into an Excel cell that looks like a date, such as "Jun-1" or "6/1," Excel automatically adjusts the format of the cell ...

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.