Overview of Student Grading Spreadsheet (Part 1 of 3)

We'll examine a spreadsheet application that brings together three tools you learned about recently:

• Module 8 - Named Ranges
• Module 9 - Excel Tables
• Module 10 - VBA Arrays

The Part 1 video is 9 minutes and covers:

• Overview - What you can expect to see in the spreadsheet
• Walk-through - How a user would use the spreadsheet to see what it accomplishes
• Structure - We see a flow diagram explaining how the worksheets and subroutines work together
• VBA Project - We look at each part of the VBA project and focus on the "Control" module because it has the top level subroutines to control code execution
• Naming Subroutines - We use names like Click_Protect() to make it easier to assign macros to buttons on the worksheet

Write your comments and feedback below

• If you have questions or comments about this lesson, write it in the section below.
• Alternatively you can email the instructor Victor at [email protected]