Whenever you change something on a Microsoft Excel 2010 spreadsheet, the program will recalculate some of the cells in the worksheet, even some of those that did not change. Normally, Excel operates ...

Subtraction is the easiest way to count days between two dates in Excel. You can use the arithmetic operator – (minus sign) to subtract one date from another to find the number of days between them.

If you are using Microsoft Excel to manage numerical data, at some point you're inevitably going to display percentages. Doing so can give you a new insight, or make summarizing heaps of data a bit ...

The interquartile mean is a measure of central tendency. While all values in a data set are used to calculate the mean, only the interquartile range -- the central portion of a data set -- is used to ...

How to calculate conditional running totals in an Excel revenue sheet Your email has been sent Adding a running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a ...

One of the most common problems with some Excel workbooks (and other types of spreadsheets) is painfully slow load times and updates. There are three typical cuprits: too many calculations, too much ...

Finding the exact difference between two dates in Excel may not be the most used feature, but it can be a lot of fun. A classic example is working out someone’s age. It’s not as complicated as it ...

Calculating returns from your stock portfolio can be a tricky matter, especially if some of your holdings pay dividends, or you make frequent deposits and withdrawals from your account. With Excel and ...

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