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.

An Excel formula is generally composed of several items. Knowing how to calculate formulas in Excel will make tracking various parts of your business that much easier.

In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.