Learn how to unlock Excel’s hidden features with GROUPBY and create visually compelling, accurate reports like never before.

Averages are typically computed as the sum of values divided by the number of data points. However, averages are also calculable from percentages. As an example, grades in a course might be weighted ...

If you bought all of your stock in a single transaction, it's easy to determine how your investment is performing. Simply look at the current share price and compare it to the price you paid. However, ...

If you bought a different number of shares with each trade, a simple average of the prices won't be accurate. If you've bought a certain stock over a series of transactions, then it can be useful to ...