Microsoft Excel Programming with VBA – Virtual

Master the programming language VBA to go beyond advanced Excel use by writing Macros, using control structures, developing user forms, and debugging code errors.

Course Overview

This 3 day Excel VBA programming course introduces advanced Excel users to the process of writing and editing Macros in Excel, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.

This course is suitable for anybody wanting to learn any version between 2007 and latest 2021. Our courses cover all differences between the versions.

Price

£649.00

+ VAT

Duration

3 Days

Training Options

Virtual Classroom

 View Course Details

Microsoft Excel Programming with VBA Course Content:

  • Lesson 1: Getting Started
  • Lesson 2: Working with Procedures and Functions
  • Lesson 3: Understanding Objects
  • Lesson 4: Using Expressions, Variables, and Intrinsic Functions
  • Lesson 5: Controlling Program Execution
  • Lesson 6: Working with Forms and Controls
  • Lesson 7: Working with the PivotTable Object
  • Lesson 8: Debugging Code
  • Lesson 9: Handling Errors

Upon successful completion of this course, students will be able to:

  • Apply VBA to develop macros
  • Format worksheets
  • Create user-interactive macros
  • Work with multiple worksheets
  • Perform calculations

Instructor led, group-paced, virtual classroom-delivery learning model with structured hands-on activities.

  • Professional Microsoft Certified Trainer
  • CPD Accredited Classroom training in Small Groups for Max Focus
  • Only Microsoft Approved Courseware and Exercise Files are used
  • Free Assessment of Skills prior to booking
  • Certificate of Completion & Complementary 12 Months Post Course Support
  • 100% Money Back Guarantee & Price Match Guarantee
  • Bespoke Courses & Group Discounts from £89 per person

This course will appeal to students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. It may also appeal to students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required.

To meet this prerequisite, you can take any one or more of the following courses:

  • Microsoft Excel Introduction
  • Microsoft Excel Intermediate
  • Microsoft Excel Advanced

This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.

The Microsoft Certified Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.

Don’t know which level you need to enrol?

Testimonials

Top Excel FAQs

How do I know which Excel level is right for me?

We offer quick and free Excel assessment which you can find “here”. It would tell you your Excel level, as well as recommend courses you may take. You may also go by course pre-requisites section on each course page.

Will I receive a certificate upon completion?

Yes, all of our courses come with certificate of completion. After you finish the course, we will send you your certificate through e-mail in 2-3 working days.

Can I ask questions or seek clarification during the course?

Of course, we pride ourselves in interactive and hands-on courses, so questions are welcome and encouraged during the course.

Is there ongoing support after completing the Excel course?

Yes, after the course we provide a variety of post-course support documents so you may revisit the content in your own time, as well as providing 12 months support via e-mail.

How experienced are your tutors?

Our company prides itself on quality of our courses, and that would not be possible with exceptional trainers! We employ tutors with both practical and teaching experiences, making sure they have specialist knowledge. We are happy to provide references and their profiles on demand.

Do I need any equipment for the Live Virtual courses?

For Microsoft Office courses you would need a computer with full version of the software you are training in. We also strongly recommend having access to a second screen for the training. This will allow you to do the exercises on your primary laptop or computer and see the virtual whiteboard on a secondary device. That device can be anything from a separate computer screen, to something like a tablet or phone.