Build A GPA Dashboard In Excel - Using IFS Function, SUM Function, & Listbox
In this video, I create a small dashboard that allows you to calculate your end-of-semester GPA. Changes can be made by course with a list box so you can test how different grades will affect your overall score.
GPA (grade point average) is an academic achievement calculated as the hotel grade points divided by credits awarded.
====== PROFILE ======
https://hubpages.com/@joshuacrowder
===== CHAPTERS =====
00:00 Start
01:20 Enter Listbox For Letter Grade
02:20 Show Score With IFS Function
04:40 Product Of Grade & Credit
05:17 SUM Function To Total
05:58 Calculate GPA
======= TAGS =======
#msexcel #excel #GPA #exceltutorial #msexcel #exceldashboard #microsoftexcel #office365
#microsoftexceltutorial #sumfunction #ifs #ifsfunction