Excel Macros and VBA Level 2

Open Enrollment Course Dates:  TBA

Click here to pre-register for this course now!

 Course Length: 1 day
 Delivery: Instructor Led/Group Live
 Prerequisites: Excel Advanced and Macros Level 1
 Course Fee: $395/single participant (call for group and/or on-site pricing)
 Course Hours: 8:30 a.m. – 4:15 p.m.

Description: This course will continue the discussion of fundamental Visual Basic programming by presenting the user with further examples of variable declaration plus branching and looping commands. There will also be exposure to array variables along with creating Visual Basic Functions, both for use in spreadsheet formulas as well as in Sub procedures. In addition the user will develop custom dialog forms while exploring a variety of Active X controls. Besides discovering various error handling routines the user will examine an assortment of debugging tools and techniques.

Highlights: variables and constants; array variables; looping commands; conditional branching; user-defined functions; Immediate window; custom dialog forms; Active X controls; error handling; break mode; debugging tools; Locals window; Watch window.

Cancellation Policy: 5 working days for full refund. Cancellations after that time are charged full tuition for the course.

For more information regarding refund, concerns, and/or program cancellation policies please contact our offices at 919-878-7100 ext. 22

Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Concerns regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.