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

This is the demonstration file to accompany the article, How to calculate conditional subtotals in an Excel revenue sheet, by Susan Harkins.

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

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

How to Calculate Operating Expenses in Excel. An Excel spreadsheet is designed to automate the task of repetitive calculations. It can be an invaluable tool for ascertaining the income, capital ...

Calculating CAGR or Compound Annual Growth Rate in Microsoft Excel is super easy. You will have to use the RRI function to get the job done.

The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the ...

How to Calculate a Running Total in Excel Learn to create cumulative sums in Microsoft Excel with these step-by-step instructions and screenshots.

Find the IRR in Excel by employing the IRR function, then use it as the discount rate that causes NPV to equal zero. Use What-If analysis, a built-in calculator in Excel, to solve for the discount ...

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.

You can alphabetize data in an Excel spreadsheet by row or column using the "Sort" feature, or through the "Data" and "Home" tabs.

Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies in Microsoft Excel.