VBA Training Sydney Onsite

Visual Basic Training Courses
Get a Quote

VBA Training Sydney

Trainers Direct offers professional VBA training courses onsite in Sydney for users who are just starting out and already have some knowledge of recording Excel Macros right up to expert user level. We provide training courses on Visual Basic for Excel and Access as well as consultancy and support.

Onsite or Public Course?

  1. Cost effective onsite courses for groups
  2. One on one for the same price as a public course Learn More…

What's Included?

  1. Tailored PDF course notes
  2. Membership of our support group
  3. Complimentary training needs analysis
  4. Laptop hire available

Top 3 Reasons to Choose Us

  1. 5 Star Google Reviews
  2. Microsoft Certified Instructors
  3. 20 year’s global experience
Visual Basic with Excel Macros (Duration 1-2 Days)
The VBA environment
  • Understand the essentials of the Excel Developer tab
  • Learn the basics of the VBA Editor
  • Understand macro-less workbooks as opposed to VBA Macro (and VBA Function) enabled workbooks
  • Set up trusted locations for workbooks with code you trust
  • Set macro settings for workbooks you may not trust
Writing procedures
  • Understand how procedures work
  • Use VBA functions and VBA macros from the Excel interface
  • Understand the structure of VBA code projects within a workbook
  • Insert code modules
  • Save your procedures in a workbook
  • Use procedures (Macros and Functions) you have written in the Excel user interface
The Excel Object Model
  • Gain an overview of the Excel Object Model
  • Understand the purpose of Object/Type actions and values (methods and properties)
Debugging
  • Learn the rudiments of basic debugging

This course assumes the learner has a good knowledge of working with Excel. Users should at least be able to create and edit workbooks, enter formulas, copy, paste, and format data and have some knowledge of recording basic macros.

Bespoke

Combine topics to create your own tailor made training course. Our expert VBA trainers can train up to expert level. Ask about our free training needs analysis for a truly relevant and hands on learning experience.

Microsoft Office short courses are available on site throughout NSW including Sydney CBD, Parramatta, Wetherill Park, Mascot, Hills District, North Sydney, Chatswood, St Leonards, Smithfield, Ryde, Pennant Hills, Sutherland Shire, Norwest, Macquarie Business Park, Bondi, Horsnby, Arndell Park, St Marys, Penrith, Fairfield and Northern Beaches. Check out our public course dates and competitive prices.

We cover all Microsoft applications including Excel, Word, PowerPoint, Access, OneNote, Publisher, Outlook, MS Project, Office 365