This course includes
- 6 hours of project-based training from experts
- Software Access
- Answers from real instructors
- Retake for free within 1 year
- Access to class recordings (30 days)
- Verified digital certificate of completion
- Learn at an accredited institution
This advanced VBA course builds on the foundation from Level 1 and brings your macro skills to the next level. You'll discover how to automate more complex tasks, streamline workflows, and apply everything you've learned across Excel in a faster, more powerful way.
To get the most from this course, you'll want to come in with a solid grasp of the core macro concepts covered in our Level 1 VBA class. With that foundation in place, you'll be well positioned to unlock the full potential of everything taught across our Excel courses.
This course has a prerequisite
Students should be comfortable with the concepts covered in Excel VBA and Macros Level I.
Tuition
Full Tuition
Full tuition: $345Due before the class starts
This course includes
- 6 hours of project-based training from experts
- Software Access
- Answers from real instructors
- Retake for free within 1 year
- Access to class recordings (30 days)
- Verified digital certificate of completion
- Learn at an accredited institution
Learning Experience Highlights
Training from government‑experienced instructors
Receive instruction from subject‑matter experts who bring proven government experience.
Specialized for government & DoD
Courses that are regularly updated based on feedback and industry developments, ensuring versions are mapped to federal competencies.
The instructor was wonderful and so knowledgeable. The course materials were extremely relevant to what my job is. I feel like I can be better because of this class.
— 2025 student
Real-world solutions
Directly addressing the day-to-day challenges of federal employees.
125+ departments & agencies served
Your trusted training partner, equipping public service professionals with the skills and knowledge to excel in their roles and drive meaningful impact.
100% Online. Start Anytime
- 24/7 access to our premium course videos and projects.
- Industry experts are assigned as your course instructor. Message your instructor with any questions.
- Participate in GSUSA online discussion forums — share ideas and receive additional support.
- Hands-on quizzes and mini projects to test and reinforce concepts.
Earn a Certificate of Completion
Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
Shareable on
Excel VBA and Macros Level II Course (Self-Paced) Curriculum
What You'll Learn at a Glance
- Navigate workbooks using offsets, named ranges, and variables
- Analyze data by combining looping structures with If and Case statements
- Build user interface structures to capture multiple variable inputs
- Control the lifespan and scope of your variables
- Create automated, event-driven processes
- Handle unexpected errors and events with reliable automation
Course Syllabus
Lesson 1: VBA Editor
- Project Explorer
- Properties Window
- Modules
Lesson 2: Creating / Editing Code
- Functions
- Events
Lesson 3: Invoking Macros
- Worksheet Buttons
- Customize Ribbon
Lesson 4: Compiling Code
- Stepping through code
- Setting Breakpoints
Lesson 5: Variables
- Declarations
- Option Compare Text
- Option Compare Binary
- Lifetime and Scope
Lesson 6: Working with The Object Model
- Application
- Workbook
Lesson 7: Creating & Naming Objects
- Naming conventions
- Housekeeping
Lesson 8: Navigation / Selection Techniques
- Absolute versus Relative Reference
- Offsets
Lesson 9: Logic Statements
- Nested IF Statements
- Case Statements
Lesson 10: Functions
- Intrinsic Functions
- User Defined Functions
Lesson 11: Looping Statements
- For Each Next Loops
Lesson 12: Interactive Code
- User Forms - dashboards
- Message Boxes
Lesson 13: Error Handlers
- Error numbers
- Error descriptions
Related Courses: Compare to Excel VBA and Macros Level II Course (Self-Paced)
These related courses share skills and topics with Excel VBA and Macros Level II Course (Self-Paced). Select up to two and tap Compare selected courses to view a side-by-side comparison.
-
Excel VBA and Macros Level I Course (Self-Paced)
6 hours $345Begin with VBA and macros in this beginner-friendly course that takes you from understanding the basics all the way to creating and editing your own code. You'll finish with the essential skills to automate Excel, streamline your workflow, and get more done in less time.
-
AI for Excel Course (Self-Paced)
6 hours $649This course teaches experienced Excel users how to leverage artificial intelligence to dramatically reduce time spent on repetitive, tedious spreadsheet tasks. Participants will learn to use AI tools—including ChatGPT, Claude, and Microsoft Copilot—as intelligent assistants for formula creation, data cleaning, analysis, and automation.