Excel Forum
Similar Content
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 met...
Quickly Add, Edit, & Manage Business Specific Diagrams in Excel (SmartArt)
Tutorial: In this tutorial I am going to show you how to add, edit, and manage Business oriented dia...
Password Protect Excel Files
Tutorial: How to keep an Excel workbook safe by encrypting it with a password. This will make it so ...



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.