Excel Programming with VBA
- Format
- Live or Self-paced
Choose how you learn
Compare formats, then explore the details for your choice.
Book directly on nobledesktop.com. Opens in a new tab.
Book live on Noble DesktopSummary
VBA (Visual Basic for Applications) is the programming language used in Microsoft Excel. With VBA, you can automate repetitive tasks in Excel.
In this hands-on class, you will learn the fundamentals of VBA programming by working on real-world applications of macros and Excel automation. You’ll learn to automate repetitive operations, create custom commands, develop new worksheet functions, and more.
Prerequisites
Prior VBA programming knowledge is not required, but knowledge equivalent to our Excel Level II: Intermediate course is recommended, including VLOOKUP, Pivot Tables, and IF statements.
Curriculum
What you'll learn
- Security
- Recording macros
- Reading and analyzing code
- Programming basic macros
- Creating complex macros
- Variables
- Looping statements
- Logic statements
- User forms
- Error trapping
- Troubleshooting
Course outline
-
Excel VBA and Macros Level I 6 hours
Learn how to develop macros, perform calculations, and more in this beginner VBA and Macros course. From understanding macros and VBA to creating and editing code, this course will teach you the essential skills to automate Excel and enhance your productivity.
- Write and run basic macros to automate tasks
- Use macros to format worksheets efficiently
- Build interactive worksheets using VBA elements
- Automate tasks across multiple worksheets
- Perform calculations using VBA to enhance spreadsheet functionality
-
Excel VBA and Macros Level II 6 hours
Learn VBA and macros with this training class. Topics covered include VBA Editor, writing and editing code, invoking macros, working with objects, logic statements, functions, looping, interactive code, and error handling.
- 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
What's included
- Microsoft Office
- 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.
Live classes
Choose dates and book your instructor-led class on nobledesktop.com.
-
–
In-person or live online
Thu, Fri
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Mon, Tue
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Wed, Thu
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Tue, Wed
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Wed
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Thu, Fri
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Thu, Fri
10:00–17:00 · America/New_York (EDT)
Confirm current dates and availability on Noble Desktop before booking.
Self-paced course
Learn through recorded lessons on your own schedule.
This program is available for 60 days. You can choose when to start your access period. Once you activate, you will have 60 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
- $549
- Course length
- 12 hours
- Schedule
- On your schedule
VBA (Visual Basic for Applications) is the programming language built into Microsoft Excel. With VBA, you can take repetitive tasks in Excel and put them on autopilot.
In this hands-on class, you'll learn the fundamentals of VBA programming by working through real-world applications of macros and Excel automation. You'll learn how to automate repetitive operations, create custom commands, develop new worksheet functions, and more.
Self-paced prerequisites
No prior VBA programming knowledge is required, though knowledge equivalent to our Excel Level II: Intermediate course is recommended, including VLOOKUP, Pivot Tables, and IF statements.
Self-paced curriculum
What you'll learn self-paced
- Security
- Recording macros
- Reading and analyzing code
- Programming basic macros
- Building complex macros
- Variables
- Looping statements
- Logic statements
- User forms
- Error trapping
- Troubleshooting
Self-paced course outline
-
Excel VBA and Macros Level I (Self-Paced) 6 hours
Learn how to build macros, run calculations, and more in this beginner VBA and Macros course. From getting familiar with macros and VBA to writing and editing your own code, this course walks you through the essential skills you'll need to automate Excel and boost your productivity.
- Write and run basic macros to automate everyday tasks
- Use macros to format worksheets efficiently
- Build interactive worksheets using VBA elements
- Automate tasks across multiple worksheets at once
- Run calculations using VBA to expand what your spreadsheets can do
-
Excel VBA and Macros Level II (Self-Paced) 6 hours
Learn VBA and macros to automate tasks and expand Excel's capabilities. This course walks you through the VBA Editor, writing and editing code, working with objects, logic statements, functions, looping, interactive code, and error handling.
- 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