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.

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

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.

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.

As a child of the dark ages, I used the word rank to describe something that smelled rotten or suspicious. Rank in Microsoft Excel is, thankfully, totally different. In Excel, rank is a value that ...

One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.

Excel provides built-in tools to help you to find discrepancies like Filters, Conditional Formatting, advanced functions (If and IS, VLookUp, etc.), and Add-ins.

How to Calculate Negatives in Excel. Microsoft Excel has the ability to automatically recognize a positive or negative number that you enter in a cell. However, if an incorrect format is selected ...

How to Calculate Multiple Cells in Excel. Microsoft Excel is a spreadsheet program used to store and analyze data. While Excel is able to hold both text and numerical data, most of the pre ...

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