Advanced VBA

Excel with Business

Programme Description

Advanced VBA

Excel with Business

60274_VBA.jpg

Become a VBA virtuoso

You’ve completed the beginner course in VBA, or have some experience. Now challenge yourself to the next step. Advanced VBA is a learner-friendly course that takes you through more powerful features, expanding the possibilities of what you can make VBA do for you.

Why Microsoft VBA?

VBA, or Visual Basic for Applications, is like Excel on steroids. As an advanced feature, it can seem intimidating at first.

But with just a little VBA knowledge you’ll be able to automate tasks in Excel and turbocharge your data handling capabilities.

On this 5 hour course you will cover:

  • Advanced methods for automating tedious Excel jobs.
  • How to write and implement Excel events.
  • Discover how to modify a variety of standard behaviors, such as double-clicking, opening files and saving files.
  • Learn how to design and implement specialized classes of objects.
  • Discover how to customize the right click menu within cell ranges.
  • Learn external libraries, and how you can extend VBA’s capabilities beyond standard Excel options.
  • How to modify the Excel user interface, including the “Ribbon” and context menus to interact with your VBA code.

We’re confident you’ll love your new courses, but if you are not 100% happy you have 30 days to exchange or refund

Syllabus

  • Section 1: Overview
  • Section 2: Foundation
  • Section 3: Events
  • Section 4: Creating Objects
  • Section 5: The Excel Interface
  • Section 6: References & Libraries
  • Section 7: Closure
This school offers programs in:
  • English


Last updated November 27, 2017
Duration & Price
This course is Online
Start Date
Start date
Open Enrolment
Duration
Duration
Part time
Full time
Price
Price
59 GBP
Information
Deadline
Contact school
Locations
United Kingdom - London, England
Start date: Open Enrolment
Application deadline Contact school
End date Contact school
Dates
Open Enrolment
United Kingdom - London, England
Application deadline Contact school
End date Contact school
Price
per year