Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

AVERAGEIF and AVERAGEIFS aren't the only functions in Excel that calculate the average of a dataset. For example, the AVERAGE function produces a straightforward arithmetic mean of a set of data, 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.

To calculate an expiry date in Excel, you may use the EDATE function, EOMONTH function, or WORKDAY function. These functions help you work with date and time in your worksheets, allowing you to ...

Excel will calculate the number of days between the dates entered in cells B3 and A3 and display the result in cell C3. Take your mouse pointer to the lower-right corner of cell C3. It will turn ...

It’s not as complicated as it sounds, and there’s a handy function in Excel that can give you an exact age to the day. Read on for tips on how to calculate age in Excel.

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.

Excel 2010 includes a built-in function for computing the trimmed mean. Open a new Microsoft Excel 2010 spreadsheet. Click on cell "A1," and enter the first number in the data set you want to get ...

How to use Excel’s RANK.AVG() function. In almost every way, Excel’s RANK.AVG() function performs as RANK(), except in one way: RANK.AGE() returns an average rank if a number occurs more than ...