Microsoft Office training -  Excel VBA macros

Excel Training

Excel VBA macros (2 days)

£625 + VAT for most venues (£750 + VAT for London)

Tired of repeating tasks in Excel? Perhaps it's time to automate your work, by learning how to write macros using the built-in VBA programming language (VBA stands for Visual Basic for Applications, and is the language also used by Access, Word, Outlook and PowerPoint).

Course details

  • Locations for Excel VBA macros coursesLocations:London, Manchester
  • Next Excel VBA macros course locationNext course:Mon 23 January 2017
  • Excel VBA macros course timesTime:09.30-16.30

Course Contents

Recording macros and buttons

  • Training topicAbsolute and relative recording
  • Training topicWhere macros can be stored
  • Training topicAssigning macros to buttons

Selecting cells

  • Training topicSelecting cells (absolute)
  • Training topicSelecting cells (relative)
  • Training topicSelecting to the end of a block
  • Training topicSelecting a range by its corners

The VB code editor

  • Training topicUsing Project Explorer
  • Training topicCreating modules
  • Training topicBasic subroutines and comments

Messages and variables

  • Training topicInput boxes and message boxes
  • Training topicDeclaring variables
  • Training topicOption Explicit
  • Training topicScope of variables
  • Training topicConstants

Visual Basic explained

  • Training topicThe Excel object model
  • Training topicObjects and collections
  • Training topicMethods and properties
  • Training topicGetting help in VBA

Loops and conditions

  • Training topicSimple IF conditions
  • Training topicMultiple IF and SELECT / CASE
  • Training topicThree main types of loop

Looping over collections

  • Training topicObject variables
  • Training topicLooping over collections

Event handling

  • Training topicAssigning macros to events
  • Training topicCancelling events

Functions

  • Training topicDeclaring functions
  • Training topicPassing arguments

Debugging and error handling

  • Training topicSetting breakpoints
  • Training topicStepping through macros
  • Training topicON ERROR statements

Forms

  • Training topicDrawing forms
  • Training topicAttaching macros to controls
  • Training topicValidating form input

Covered if time allows If time

Referencing other applications

  • Training topicLinks to Word or Access
  • Training topicWorking with files and folders

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Advantage of this course over any other I've been on, is that it's extremely flexible and the trainer responded to all questions as we went without needing to go away and get back via email."

Dmitrij Zukov (Express Gifts Ltd)

"The (Access Introduction for Developer) course format, presentation and venue (London) were excellent and accompanied by impressive courseware. I will be recommending this to others."

Russell Harding (Amdipharm Plc)

"Thought that the course admin was very good, when booking I was kept fully updated on the process and with prompt responses and assistance. The content and manuals are of a high standard and covered all the basics giving a a good knowledge."

Mark Hannon (Midland Heart Ltd. (formerly Prime Focus))

"Excellent course, content and trainer."

Chris Coombes (London Community Rehabilitation Company Ltd)

"Excellent course. Perfectly pitched, well delivered and lunch included. Everything I wanted to learn was included. Highly recommended. "

Jason Thompson (Rathbone Training)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Delegates should be comfortable with using Excel (no advanced knowledge is needed). No experience of progamming is needed, although delegates should enjoy the logical challenge of learning new computer systems.

Related Courses

Advanced VBA

Very advanced

2 day course

Advanced Excel 2013

Intermediate

2 day course

Excel Business Modelling

Advanced

2 day course

Other Microsoft Excel training resources

Excel exercises

Excel exercises

Teletubbies, Wombles, Elmer the elephant - there are all sorts of exciting exercises on VBA programming published on this site!

View Excel 2010, Excel VBA or Power BI exercises

Excel videos

Excel videos

We've created a suite of videos explaining different aspects of VBA (although people learn best from other people, we've found).

View Excel VBA, Microsoft Excel or Excel 2013 Power BI Tools videos

Excel skills assessment

Excel skills assessment

You can test your VBA knowledge by seeing how it stacks up relative to that of others at this skills assessment site.

View Excel or Excel VBA skills assessment tests

Excel blogs

Excel blogs

There's a full-blown online tutorial included in the blogs we've published on Visual Basic for Applications.

View Excel, Power BI - Excel 2013 or VBA macros blogs

This page has 0 threads Add post