Excel Forum
Similar Content
The Magically Appearing Cell in Excel
Tutorial: A fun way to make a cell's contents appear when a specific action occurs. This works when...
Find the Next Blank Row with VBA Macros in Excel
Tutorial: Learn how to find the next empty cell in a range in Excel using VBA and Macros.  This me...
Make Perfect Scrollable Boxes in Worksheets in Excel - Great for a Dashboard
Tutorial: Make a scrollable box in a worksheet in Excel that allows you to scroll through a table o...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Magic Trick #197: Grade Book with Weights


Use the SUM and VLOOKUP functions to create a Grade Book Based on Total Score and Weights Assigned to different Categories (Tests and Quizzes) that will calculate grade for you automatically.
VLOOKUP function information.
Formulas for Grades.
Excel Lookup Series





Got a Question? Ask it Here in the Forum.