This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

You can calculate the T-Value in Excel with the mean, standard deviation and degrees of freedom. Since the T-Value is a comparison between sample mean and population mean, both values need to be ...

The payback period is the amount of time needed to recover the initial outlay for an investment. Learn how to calculate it with Microsoft Excel.

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

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.

For example, your worksheet should correctly calculate overtime for all hours worked over 40. In addition, your company policy or state law may require you to pay employees double time for any ...

Follow along in this step-by-step guide to learn how to easily calculate hours worked in Microsoft Excel.

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.

Formula of Mean: Know to How to Calculate Median for Grouped, Ungrouped data along with solved examples, questions with solution.

If you need to reconcile batches of records in Microsoft Excel, this simple VLOOKUP() solution offers a quick and easy way to find records in one batch that are missing from another.