Calculate t-values in your Microsoft Excel spreadsheet by combining built-in functions with custom formulas. T-values, also known as t-statistics, calculate the likeliness that a population ...

How to Calculate an Interquartile Mean in Excel. The interquartile mean is a measure of central tendency. While all values in a data set are used to calculate the mean, only the interquartile ...

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.

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

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.

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.

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

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

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

Excel offers several easy ways to calculate expiry dates. This post explores different ways to automate expiry date calculations in Excel.