How To: Make an Excel gradebook that removes the lowest score

Make an Excel gradebook that removes the lowest score

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 195th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, MIN and VLOOKUP functions to create a grade book based on given total score that drops the lowest score and calculates grades automatically.

Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.

Buy Now (97% off) >

Our Best Phone Hacks

Gadget Hacks' tips — delivered daily.

1 Comment

Thank you for this informative video!
My courses have multiple weighted categories, and I'd like to drop the lowest percentage in the work category and then show an average for that work category (per student). My Excel grade sheet has a max value (total points for the work category). In that introductory cell, I wrote =SUM(C4:N4)-MIN(C4:N4) so that the lowest percentage is dropped. However, I would like to know how to average the remaining percentages. What formula do I write in the average cells to reflect the dropped percentage as well as the remaining percentages?

Share Your Thoughts

  • Hot
  • Latest