PowerPivot Fundamentals $199 (Normally $299)
$199 QuickBooks Level 1 or Level 2 for PC, Mac, or Online Classes (Normally $299/ea)
Now $545-Excel Power Programming with VBA (Normally $659)
Now $649-Photoshop Essentials 2 Day Course (Normally $749)
GIFT CERTIFICATES AVAILABLE
|Jun 26, Jun 27: 9:00am–5:00pm||$545||10||185 Madison Avenue, NYC|
|Jul 16, Jul 17: 9:00am–5:00pm||$545||10||185 Madison Avenue, NYC|
|Aug 6, Aug 7: 9:00am–5:00pm||$545||8||185 Madison Avenue, NYC|
|Aug 18, Aug 19: 9:00am–5:00pm||$545||10||185 Madison Avenue, NYC|
|Aug 30, Aug 31: 9:00am–5:00pm||$545||9||185 Madison Avenue, NYC|
|Sep 20, Sep 21: 9:00am–5:00pm||$545||10||185 Madison Avenue, NYC|
|Oct 6, Oct 7: 9:00am–5:00pm||$545||10||185 Madison Avenue, NYC|
|Oct 15, Oct 16: 9:00am–5:00pm||$545||10||185 Madison Avenue, NYC|
|Nov 1, Nov 2: 9:00am–5:00pm||$545||10||185 Madison Avenue, NYC|
|Nov 28, Nov 29: 9:00am–5:00pm||$545||10||185 Madison Avenue, NYC|
|Dec 8, Dec 9: 9:00am–5:00pm||$545||10||185 Madison Avenue, NYC|
|Dec 17, Dec 18: 9:00am–5:00pm||$545||10||185 Madison Avenue, NYC|
Call 212.658.1918 or email us
VBA (Visual Basic for Applications) is the programming language used in Microsoft Excel. With this programming language, you can automate repititive operations, create custom commands, develop new worksheet functions, and more. At NYIM's VBA classes in New York City, you will learn the fundamentals of VBA programming in hands-on, instructor-led training.
The Excel Programming with VBA course concentrates on practical automation of repetitious Excel tasks and reports. In this Excel VBA course, you will write macros to automate your Excel tasks even if the data is not consistently formatted, create custom Excel applications and environments, and create custom Excel Add-ins to increase the functionality of the program. 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.
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|
|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|
|Run||13. Error Handlers|
|Preventing fatal errors and crashes|
VBA Macros Day 2
|1. VBA Editor||7. Creating & Naming Objects|
|Project Explorer||Naming conventions|
|Modules||8. Navigation / Selection Techniques|
|2. Creating / Editing Code||Absolute versus Relative Reference|
|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|
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.
See for yourself why NYIM is rated the best VBA courses in Manhattan by our customers:
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.
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.
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.
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.
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.
© NYIM Training 2018