Create Account

Similar Content

Delete Entire Rows Based on Predefined Criteria (Text)
Macro: This macro will allow you to specify certain criteria and then to delete rows based up...

Formulas Based on Cell Color - SUMIFS, IF, COUNTIF, Etc.
Tutorial: How to use a SUMIF or SUMIFS function (or any conditional function or formula) on cell ba...

Name Worksheets Based on Cell Contents
Macro: This macro allows you to have your worksheets named by whatever is in a particular cel...

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

Tutorials

Featured Tutorial

Dynamically Update Drop-Dowm Menus in Excel

Featured Macro

Delete Empty Rows in Excel

Excel Magic Trick #194: Grade Book Based on Percentages

Use the SUM, VLOOKUP and ROUND functions to create a Grade Book Based on Percentage Scores that will calculate grade for you automatically. See how the VLOOKUP and the Percentage format can deliver the wrong Grade when you dont use the Round Function.
VLOOKUP function information.
ROUND function
Formulas for Grades.
Excel Lookup Series

Got a Question? Ask it Here in the Forum.