Excel VBA and Macros Level II
via Noble Desktop
Affiliated with Course Report
Continue developing spreadsheet automation in Noble Desktop's Excel VBA and Macros Level II course. The curriculum builds on introductory VBA concepts and applies them to more involved programming work. You practice extending what a macro can do and organizing code to support repeated tasks within Excel workbooks.
- Format
- Live or Self-paced
Choose how you learn
Compare formats, then explore the details for your choice.
Enrollment and course access are provided by Noble Desktop.
Is this course right for you?
You should be comfortable with the concepts from the introductory VBA and macros course. If you are starting programming within Excel, compare Excel Programming with VBA before moving into this advanced continuation and its more involved automation work.
Compare your options
Summary
Our Advanced Excel VBA Training will teach you to automate tasks and streamline workflows using macros. Excel VBA Macros Level 2 is our advanced class and assumes familiarity with the basic macro concepts introduced in our Level 1 Excel VBA class. An understanding of the skills taught in VBA Excel classes will empower users to utilize all the tools from our Excel courses in the most efficient and powerful way.
Prerequisites
Students should be comfortable with the concepts covered in Excel VBA and Macros Level I.
Topics included
Curriculum
What you'll learn
- Navigate a workbook using offsets, named ranges, and variables
- Analyze data using looping structures in combination with If and Case statements
- Create user interface structures to capture multiple variable inputs
- Control the lifespan and scope of variables
- Create automated event-driven processes
- Create automation to handle unexpected errors and events
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
What's included
- Microsoft Office (1 month)
- Free course retake within one year to refresh the material and gain practice.
- Class recordings
Stated by the provider. Confirm what your tuition covers before enrolling.
Schedule & enrollment
Find dates that fit your schedule, then book on Noble Desktop.
All class times are Eastern (ET).
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
Confirm current dates and availability on Noble Desktop before booking. Enrollment opens in a new tab.
Self-paced course
Learn through recorded lessons on your own schedule.
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
- Tuition
- $345
- Course length
- 6 hours
- Schedule
- On your schedule
Enroll with Noble Desktop
View current tuition and secure enrollment options from the course provider.
View tuition & enrollLoading enrollment options…
Prefer to enroll directly? Open the course website.
Our Advanced Excel VBA Training will teach you how to automate tasks and streamline your workflows using macros.
Excel VBA Macros Level 2 is our advanced class and assumes you're already familiar with the basic macro concepts introduced in our Level 1 Excel VBA class. Getting a handle on the skills taught in VBA Excel classes will empower you to use all the tools from our Excel courses in the most efficient and powerful way possible.
Self-paced prerequisites
Students should be comfortable with the concepts covered in Excel VBA and Macros Level I.
Self-paced curriculum
What you'll learn self-paced
- Navigate a workbook using offsets, named ranges, and variables
- Analyze data with looping structures paired 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
- Build automation that handles unexpected errors and events gracefully
Self-paced 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