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.

We show you how to calculate compound interest in Excel at different rate of interests, like semi-annually, quarterly, monthly, etc.

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.

Master Excel percentages with expert hacks to save time, reduce errors, and boost confidence in your data. Learn shortcuts and avoid mistakes ...

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.

Microsoft Excel's spreadsheet design allows you to quickly calculate values separated into two columns and replicate this calculation without having to manually recreate the formula for each row ...

Learn how to calculate your effective tax rate using Microsoft Excel, what income tax rates to apply to your earned income, and what tax percentage applies to each span.

How to Set Up Auto Calculate in Excel 2010. When you edit the values on your Microsoft Excel worksheet, pressing the "F9" button refreshes the calculation manually. To avoid the tedious task of ...

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

To calculate the returns on your mutual fund investments made on different dates, using XIRR formula in excel makes the task easier. You may be investing through SIP or making lump sum investments ...

The key to calculating a conditional running total is discerning the condition and then expressing that condition in a way that Excel can interpret. In this case, the condition is the month.