Lesson series

How to Do a Weighted Average in Excel

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.

  • 68 learners

    Enrolled

  • 4 hours

    Video duration

  • 27 hours

    Course duration

  • 4 Ebooks

    Free of charge

    Learners

    Assignments

    Hours

    Videos

    Join my school and you won't regret it..

    I am a Certified Life Coach with a holistic approach that brings clarity, direction, and positive support for my clients. I help you live your best life, by filling the gap between where you are now, and where you want to be. By identifying where growth is desired, setting goals and objectives, and holding accountability, you will reach your highest goals and dreams.
    Write your awesome label here.