If you need to perform an exponential calculation of numbers in a range of cells in Excel, this tutorial will show you how to do it in a few easy steps.

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

How to Calculate Negatives in Excel. Microsoft Excel has the ability to automatically recognize a positive or negative number that you enter in a cell. However, if an incorrect format is selected ...

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.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

How to Use Excel to Calculate Incremental Cost & Incremental Revenue. Microsoft Excel can be a powerful tool for large and small businesses alike. It is used to perform calculations, store and ...

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

Learning how to perform statistical data analysis in Microsoft Excel can help you improve your analytics and reporting. This guide takes you ...

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.

If you have a bunch of rows or columns in Excel that need to be updated with a math operation, instead of applying a formula or editing each cell, save some time by using Paste Special.

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.