Excel Macros and VBA Level 1

Open Enrollment Course Dates: 

Click here to pre-register for this course now!

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

Objective: Upon successful completion of this course the student will be able to integrate basic spreadsheet functionality with the core components of macros and Visual Basic code. By being exposed to various data scenarios, the user can assimilate purposeful macro creation and effective operation.

Description: This course is designed to acquaint the user with macro creation by introducing them to the macro recorder. There will be a preliminary groundwork set for proper macro blueprinting in the development process. The users will also be introduced to the Visual Basic editor window where basic fundamentals of the programming language will be discussed. Upon nesting macro codes together they will generate stored macros and discover how to run them in other files. This will evolve into a distinction made between macros and VBA programming where the users will create various Visual Basic procedures. They will explore such facets of programming as variable and constant declaration, branching commands, looping, and error trapping.

Highlights: recording and executing macros; viewing procedure code; nesting macros; fundamentals of VB language; variable and constant declaration; variable scope and lifetime; DO UNTIL looping; conditional branching commands; error trapping routines.

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.