Practice exercises for ACCT 628. No coding experience needed — these modules start from the basics and build on each other, just like the course videos do. They are designed to work together.

Learning Path

Work through each module in order after watching the associated course video — each one builds on the last.

Module 1

Macro Foundations

Recording macros, understanding absolute vs. relative references, and where your code actually lives.

 Module 2

Adding Programming Concepts

Bringing logic and control flow into your macros — conditions, decisions, and structure.

 Module 3

Variables

Store and reuse values in your macros without rewriting the same code over and over.

 Module 4

Loops

Repeat actions across rows automatically — the core of most real-world macro tasks.

 Module 5

Calculations and Dates

Work with numbers and time in VBA — formulas, arithmetic, and date functions.

 Module 6

Relative vs Absolute References

Understand when your macro moves with the data vs. stays locked to a specific cell.

 Module 7

Filters & Shortcut Keys

Combine filtering logic with keyboard shortcuts to work faster and smarter in Excel.

 Module 8

F8 Debugging Practice

Step through your macros line by line to find exactly where — and why — things go wrong.

 Module 9

Pseudocode

Plan before you code — write your logic in plain language and turn it into working VBA.
Project

Practice Project

Put it all together — the Aggie Advisors scenario walks you through building a complete macro from scratch using everything you've learned.

Go to project →

Why doing it yourself actually matters

You have watched the videos — now this is where you review and apply what you learned. Follow along with the Macro Demo file, revisit the concepts here, and work through the practice exercises. Each module is designed to reinforce exactly what Professor Sanders covers in that video.

The exam is in-person — no AI, no search bar, just you and the code. The students who walk out feeling confident are the ones who actually created the macros themselves, stepped through them with F8, and built a real sense of what each line does. These exercises exist to give you that practice in a low-stakes space before it counts.