Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

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 calculate compound interest in Excel at different rate of interests, like semi-annually, quarterly, monthly, etc.

An Excel formula is generally composed of several items. Knowing how to calculate formulas in Excel will make tracking various parts of your business that much easier.

The difference is your overall profit, in this example the formula result would be $17. Input a formula in the final column to calculate the profit margin on the sale.

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

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.

A. There are many ways to calculate depreciation in Excel, and several of the depreciation methods already have a built-in function included in the software. The table below includes all the built-in ...

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.

You can also calculate the volatility of an entire portfolio, but this formula is far more complex. To keep things simple, we will explain the formula assuming a two-stock portfolio.

Calculate the expected annual return of your portfolio in Microsoft Excel by using the value and expected rate of return of each investment.