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.

Learn what Value at Risk is, what it indicates about a portfolio, its pros and cons, and how to calculate the VaR of a portfolio using Microsoft Excel.

Learn how to calculate moving averages in Excel using dynamic arrays. Simplify rolling totals with custom functions for efficient analysis.

Type in the interval that you want to use for the X-axis labels. The first axis label displays, then Excel skips labels until the number of your interval, and continues on in this pattern.