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
|May 12, May 13: 9:00am–5:00pm||$545||12||185 Madison Avenue, NYC|
|May 14, May 16: 9:00am–5:00pm||$545||9||185 Madison Avenue, NYC|
|Jun 6, Jun 7: 9:00am–5:00pm||$545||10||185 Madison Avenue, NYC|
|Jun 23, Jun 24: 9:00am–5:00pm||$545||12||185 Madison Avenue, NYC|
|Jun 26, Jun 27: 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.
Our VBA classes include a Free Retake within six months of the course.
The Excel Programming with VBA course concentrates on practical automation of repetitious Excel tasks and reports. In this VBA & Macros training 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 course 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.
|1. Macros||6. Strings||12. Worksheets|
|What are Macros?||How to reference a string||Selecting a specific worksheet|
|How to record macros||Concatenating strings||Selecting the active worksheet|
|How to run macros||7. Declaring variables||Adding a new worksheet|
|How macros are related to VBA||How to declare variables||Naming a worksheet|
|2. VBA Editor||Using "Option Explicit"||Range|
|What is VBA?||Declaring multiple variables||Selecting a range of cells|
|How to edit VBA code||Requiring variable declarations||Avoiding variant declaration|
|"Sub" routine||8. Types of Variables||When to use variant|
|Project Explorter||String, Single, Boolean, Time||13. IF Statements|
|3. Turning on Project Explorer||Integer, Double, Date, Variant||If Then statements|
|Excel objects & modules||9. Properties||If Then Else statements|
|Excel objects||What are properties?||14. Referencing & Manipluating Cells|
|Modules||Renaming modules||Selecting a specific cell|
|Making a hidden sheet||Renaming sheets||Selecting the active cell|
|4. Comments||Watch window||Deleting cell contents|
|What are comments?||Using watch windows||15. Activating Scripts|
|How comments are marked||10. Rows||Workbook_Open|
|Importance of comments||Selecting a specific row||Auto_Open|
|5. Debugger||Selecting the active row||16. Loops|
|What is the debugger?||Selecting the last row||Do While Loop|
|How is it used?||Insert a row||For Next Loop|
|Step into||Deleting row contents||For Next Loop with Step|
|Step out||11. Columns||Do Until Loop|
|Play||Selecting a specific column||For Each Loop|
|Reset||Selecting the active column|
|Step over||Selecting the last column|
|Play||Insert a column|
|Breakpoint||Deleting the column contents|
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:
“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