How to Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money.

You can calculate Ratio in Excel by using the GCD function and the Substitute function. This article is a step-by-step guide to help you.

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.

How to Calculate Time Cards in Excel. If you pay employees an hourly wage and use time cards to track their weekly work time, you can use Microsoft Excel to calculate work totals, simplifying your ...

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...

Find out more about return on equity, the formula to calculate ROE, and how to calculate this measure of corporate profitability 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.

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

Learn how to calculate the discount rate in Microsoft Excel, what the discount factor is, and how the discount rate and discount factor compare.

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

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