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

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

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.

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

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.

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

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.

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

You can calculate Ratio in Excel by using the GCD function and the Substitute function. This article is a step-by-step guide to help you.