Excel Programming with VBA
via Noble Desktop
Affiliated with Course Report
Automate spreadsheet tasks with Visual Basic for Applications in Noble Desktop's VBA course. The curriculum introduces programming within Excel so you can connect repeated workbook actions with reusable code. You practice developing a programming approach to tasks that would otherwise need the same sequence of manual spreadsheet operations.
- 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?
Prior VBA programming is not required, but intermediate Excel skills are recommended. Choose this course for spreadsheet automation. Compare the advanced VBA continuation if you already understand the introductory programming and macro concepts.
Compare your options
Summary
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, PivotTables, and IF statements.
Topics included
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.
Schedule & enrollment
Find dates that fit your schedule, then book on Noble Desktop.
All class times are Eastern (ET).
-
Dates
–
Mon & Tue
Class time
10am–5pm ET
Attend
In-person or live online
-
Dates
–
Mon & Tue
Class time
10am–5pm ET
Attend
In-person or live online
-
Dates
–
Wed & Thu
Class time
10am–5pm ET
Attend
In-person or live online
-
Dates
–
Tue & Wed
Class time
10am–5pm ET
Attend
In-person or live online
-
Dates
–
Tue & Wed
Class time
10am–5pm ET
Attend
In-person or live online
-
Dates
–
Thu & Fri
Class time
10am–5pm ET
Attend
In-person or live online
-
Dates
–
Thu & Fri
Class time
10am–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 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
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.
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, PivotTables, 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