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

GCD stands for Greatest Common Divisor. It is also called HCF (Highest Common Factor). In simple words, it is the greatest number that can divide a particular set of numbers. For example, the Greatest ...

Later, we'll add an IF() function that returns a subtotal for each day. How to calculate conditional subtotals in an Excel revenue sheet Your email has been sent Subtotals are common in a lot of Excel ...

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

The median function in Excel can be categorized as a statistical function. It can be entered as part of a formula in a cell of a worksheet. The syntax of the MEDIAN ...

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