In Excel, folks can use the RRI to calculate Compound Annual Growth Rate, also known as CAGR. What are the 5 functions in Excel every professional should use?

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

Net present value (NPV) is used to estimate the profitability of projects or investments. You can calculate NPV in two ways using Microsoft Excel.

Historical volatility is a long-term assessment of risk. Discover why it is important to investors and learn how to calculate volatility in Excel.

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

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.

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.