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

How to Change a Range in Microsoft Excel. When you copy a formula, referenced ranges automatically adjust according to the formula's new position unless the ranges use absolute references ...

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.

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

Learning how to perform statistical data analysis in Microsoft Excel can help you improve your analytics and reporting. This guide takes you ...

Understand the basics of the current ratio, including its use in assessing a company's liquidity and learn how it is calculated in Microsoft Excel.

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.

How to calculate average stock returns in Excel In the following example, I'll calculate the returns for Microsoft stock using historical prices and dividends. The first step is to get organized.