Discover Classes. Earn Rewards.

Excel Programming with VBA

at NYIM Training - Murray Hill

(710)
Course Details
Price:
$595 10 seats left
Start Date:

Thu, Jul 11, 9:00am - Jul 12, 5:00pm (2 sessions)

Next start dates (5)

Location:
Murray Hill, Manhattan
185 Madison Ave 11th Fl
At 34th St
New York, New York 10016
(Map)
Share:
Purchase Options
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 10

What you'll learn in this excel class:

The Excel Power Programming with VBA concentrates on how to automate repetitious Excel tasks and reports. By the end of this course, you will feel confident in writing macros to automate your Excel tasks, even if the data is not consistently formatted, creating custom Excel applications and environments, and creating custom Excel Add-ins to increase the functionality of the program. 

This 2-day class is perfect for those consistently working with Excel and will need to automate repetitious tasks.

Materials:
  • Custom Printed Manual
  • Multiple XLS and XLT examples for in class and after class
  • Shortcut sheets
  • After class resources

SYLLABUS:

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

Still have questions? Ask the community.

Refund Policy
  • Registration Fee: All courses include a non-refundable registration fee of 10%.
  • Cancellations: Students may cancel up to seven business days prior to the course and receive all monies paid, less the non-refundable registration fee. Cancellation requests within the policy should be made directly to CourseHorse.
  • Rescheduling: Students may reschedule once up to three business days prior to the start date of the course at no charge. Reschedules within three business days incur a $20 rescheduling fee. Reschedule requests should be emailed to [email protected]

Map

Google Map

NYIM Training

All classes at this location

Start Dates (6)
Start Date Time Teacher # Sessions Price
9:00am - 5:00pm TBD 2 $595
This course consists of multiple sessions, view schedule for sessions.
Fri, Jul 12 9:00am - 5:00pm TBD
9:30am - 5:30pm TBD 2 $595
This course consists of multiple sessions, view schedule for sessions.
Sun, Jul 28 9:30am - 5:30pm TBD
9:00am - 5:00pm TBD 2 $595
This course consists of multiple sessions, view schedule for sessions.
Thu, Aug 01 9:00am - 5:00pm TBD
9:00am - 5:00pm TBD 2 $595
This course consists of multiple sessions, view schedule for sessions.
Fri, Aug 23 9:00am - 5:00pm TBD
9:00am - 5:00pm TBD 2 $595
This course consists of multiple sessions, view schedule for sessions.
Tue, Sep 10 9:00am - 5:00pm TBD
Start Date Time Teacher # Sessions Price
9:30am - 5:30pm TBD 2 $595
This course consists of multiple sessions, view schedule for sessions.
Sun, Sep 22 9:30am - 5:30pm TBD

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 5950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (3)

Get quick answers from CourseHorse and past students.

Question from John M.
Do I need to bring my laptop with Excel?
Answer from Georgia C. CourseHorse StaffCourseHorse Staff
Hi John! No. The school will provide the computers you will use in class. So the program is already there.
Answer
Cancel
Question from Anonymous
What level of excel do I need before taking this VBA class?
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hi there! Students should have an advanced knowledge of Excel to attend Excel Programming with VBA.
Answer
Cancel
Question from Rochelle F.
Will anymore weekend sessions be offered?
Answer from Kristle C. CourseHorse StaffCourseHorse Staff
Hi Rochelle! At the moment, only one session is offered on weekend - March 31 - April. We do not have an updated schedule yet for this class.
Answer
Cancel

Reviews of Classes at NYIM Training (701)

(701 Reviews)
Excel Programming with VBA
Reviewed by Carson G. on 5/1/2019
One day out of class and already using what I learned. Extremely helpful excel class.
Excel Programming with VBA
Reviewed by John E. on 2/23/2018
It was really helpful. I wish it were 3 days since the last half of the 2nd day we basically rushed through what was planned for the course since we didn't have time.
Excel Programming with VBA
Reviewed by Milad T. on 2/13/2018
Garfield is great!
Excel Programming with VBA
Reviewed by Petro . on 10/27/2017
Great Training and instructor. Minor suggestion would be to have more hands-on training by students.
Excel Programming with VBA
Reviewed by Robert W. on 12/5/2016
Chris was a great VBA teacher. I highly recommend what he brings to the table in the form of actual experience and project in his classes.
loading...
loading...
Similar Classes

School: NYIM Training

NYIM Training

For nearly two decades, NYIM has trained thousands of business professionals in the latest computer software programs, including Excel, Financial Modeling, Microsoft Office, Adobe, SQL, AutoCAD, QuickBooks, and many more.  

The company is known for its practical and hands-on approach to its...

Read more about NYIM Training

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Ready to take this class?
BOOK NOW
Taking this class for work? Get exclusive perks & discounts for free.
Loading...