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

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.

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.

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

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

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

How to calculate depreciation for fixed assets with the straight-line method, the sum of the years’ digits method, and others, using Microsoft Excel ...

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.

Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.