Grade Tracker For Students - Calculate Your Grades in Excel

This video explains how to create a University Grade Tracker in Excel to help you track your progress and stay motivated to achieve your desired grades. The grade tracker calculates the grade required in the remainder of your modules to achieve your desired grades. Your overall weighted average grade is calculated using a combination of the SUMPRODUCT and SUM functions while the percentage of your academic year completed is calculated using the SUM and COUNT functions. The tracker illustrates the current and expected grade diagrammatically through bar charts to help you better understand in which modules you are underperforming.

Access the templates featured in The Excel Hub's video tutorials here:
https://theexcelhub.myshopify.com/

Subscribe for weekly Excel tutorials, techniques and examples:
   / @theexcelhub  

Please share this video with others that may find it useful:
   • Grade Tracker For Students - Calculat...  

Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!

🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram:   / theexcelhub  

ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.

For any enquiries, please contact:
[email protected]

Overview: (0:00)
Calculate Grade Required: (0:57)
Calculate Days Left: (1:55)
Summary Calculations: (2:24)
Charts: (4:18)