Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

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

How to Calculate the Midpoint of Two Dates in Excel. When you enter a number into an Excel cell that looks like a date, such as "Jun-1" or "6/1," Excel automatically adjusts the format of the cell ...

How to Find the Gross Margin in Excel. The term "gross margin" describes the profit achieved on sales, expressed as a percentage of the total revenue generated by the sales.

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 offers several easy ways to calculate expiry dates. This post explores different ways to automate expiry date calculations in Excel.

Using Excel’s conditional formatting to highlight duplicates in a single column is one way to find them quickly, although there’s less motive to delete duplicates in this situation.

As a child of the dark ages, I used the word rank to describe something that smelled rotten or suspicious. Rank in Microsoft Excel is, thankfully, totally different. In Excel, rank is a value that ...

Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.

Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

To calculate statistical variance in Microsoft Excel, use the built-in Excel function VAR.

With Excel and data from your broker, however, calculating the average return is fairly easy using the XIRR function. How to calculate average stock returns in Excel ...