Learn more about our VBA classes
The Excel Programming with VBA course concentrates on practical automation of repetitious Excel tasks and reports. This VBA class is perfect for those consistently working with Excel who need to automate repetitive tasks.
In this hands-on, instructor-led VBA training, you will work on real-world applications of Macros and Excel programming with hands-on exercises. In addition to extensive teaching experience, our instructors provide VBA consulting work and use examples and best practices from real-world projects in the class.
Read Aris B.'s review of NYIM Training on Yelp
VBA Course Outline
VBA Course PDF Outline
VBA Macros Day 1
|
| 1. Macros / VBA |
6. Variables |
| What are Macros? |
Declarations |
| What is VBA? |
Option Explicit |
| How to record macros |
Data Types |
| How to run macros |
7. Working with The Object Model |
| 2. VBA Editor |
Worksheets |
| Modules |
Ranges: Rows, Columns, Cells |
| Procedures |
8. Creating & Naming Objects |
| Project Explorer |
Naming conventions |
| Toolbars / Options |
Housekeeping |
| 3. Creating / Editing Code |
9. Navigation / Selection Techniques |
| Create Procedures |
Formula R1C1 Reference Style |
| Subs |
Offsets |
| Comments |
Range Names |
| 4. Invoking Macros |
10. Logic Statements |
| Hot Keys |
IF Statements |
| Quick Access Toolbar |
11. Looping Statements |
| Call Command |
Do Loops |
| 5. Compiling Code |
12. Interactive Code |
| Stepping through code |
Input boxes |
| Reset |
Message boxes |
| Run |
13. Error Handlers |
| |
Preventing fatal errors and crashes |
VBA Macros Day 2
|
| 1. VBA Editor |
7. Creating & Naming Objects |
| Project Explorer |
Naming conventions |
| Properties Window |
Housekeeping |
| Modules |
8. Navigation / Selection Techniques |
| 2. Creating / Editing Code |
Absolute versus Relative Reference |
| Functions |
Offsets |
| Events |
9. Logic Statements |
| 3. Invoking Macros |
Nested IF Statements |
| Worksheet Buttons |
Case Statements |
| Customize Ribbon |
10. Functions |
| 4. Compiling Code |
Intrinsic Functions |
| Stepping through code |
User Defined Functions |
| Setting Breakpoints |
11. Looping Statements |
| 5. Variables |
For Each Next Loops |
| Declarations |
12. Interactive Code |
| Option Compare Text |
User Forms - dashboards |
| Option Compare Binary |
Message Boxes |
| Lifetime and Scope |
13. Error Handlers |
| 6. Working with The Object Model |
Error numbers |
| Application |
Error descriptions |
Corporate VBA Training
Flexible training solutions & customized course content
Over two decades, NYIM has served the most prestigious businesses and institutions across the United States with its industry-leading VBA corporate training program. For our corporate clients, we can customize the VBA training to meet the needs of your team, and conduct the classes at your location or ours. We offer a free consultation to customize the content. For flexible scheduling options for your employees, ask about our voucher program.
Inquire about corporate VBA classes
Rated the Best VBA Classes in NYC
See for yourself why NYIM is rated the best VBA courses in Manhattan by our customers:
100+ 5-Star Reviews on Yelp: Best VBA Classes NYC
This class is both the best VBA training and value in NYC. The class is very small (I had only two other students in my session) which allows the instructor to provide very personal training. The syllabus is very thorough and involves real-world, complex scenarios: such as changing formulas and text on a worksheet and replacing text strings by using loops. I took this class as training for an applications developer position and found it to be worthwhile. The price is very reasonable and the classes don't take up the whole day either. I strongly believe this to be the best value in NYC while offering the least amount of disturbance to your work schedule.
Saba made the class non- intimidating and informative due to her casual approach, teaching from the basics forward and her helpfulness with every little question. I did like that the class was small and hands on with computers.
Saba really knows her stuff! Lively attitude kept things interesting. She was very interactive and engaging us in the class.
What You’ll Learn in our VBA Courses
What is VBA?
- VBA stands for Visual Basic for Applications, the programming language Microsoft Office is built on. Each application on the MS office suite – Excel, Word, PowerPoint etc. – has its own version of VBA.
What is a Macro?
- A snippet of code that is going to perform or automate a set of tasks for a user.
- In Excel, a macro can be recorded using the macro recorder in the Developer tab, or coded by hand in the Visual Basic Editor. You can create macros to perform more complicated series of tasks than what the defaults in Excel allow for.
When can or should you use VBA?
- If you’re doing something in Excel that’s redundant, slow, boring, tedious, and most of all, something that has multiple elements to it where the sequence matters, VBA can help you automate that workflow.
- VBA can enhance the capability of Excel; you can write code to expand the basic functionality of Excel beyond the standard defaults. With VBA, you can program your own functions, automate processes, and automate frequently used sequences of commands.
What are the major topics you’ll learn in our VBA classes?
- Security
- Recording macros
- Reading and analyzing code
- Programming basic macros
- Create more complex macros
- Variables
- Looping statements
- Logic statements
- User Forms
- Error Trapping
- Troubleshooting
How are our VBA courses structured?
The VBA classes are hands-on and project based. You’ll be working on a larger project throughout the class by solving and completing one step before moving to the next. We break down larger projects into smaller pieces to facilitate learning and retention.
See More Excel & VBA Classes at NYIM
All Excel Classes Beginner Intermediate Advanced Fast as Hell Certification
© NYIM Training 2018
