Lesson Description

This lesson examines calculation methods. If terms like AVERAGE function and SUMPRODUCT have left you confused, fear not – our step-by-step guide is here to simplify things for you.

We start by demonstrating how to find a regular average using the AVERAGE function. However, the real game-changer comes when you explore the nuances of weighted averages, where certain disciplines hold more weight than others. We break down the process of assigning percentage-based weight values.

Whether you're a beginner or an experienced Excel user, this lesson will ensure you confidently grasp the details of weighted averages.