Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

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

Adding a running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a conditional running total will require a bit more effort. Solutions are simpler than you might think.

Several basic templates are available for Microsoft Excel that make it simple to calculate production costs.

How to add a condition to rank using a PivotTable in Excel A simple rank is easy to calculate, but sometimes you’ll want to accommodate a condition.

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.

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