Introduction to Excel Macros & VBA

This one day course is for advanced Excel users who have never used Visual Basic for Applications (VBA) and who would like to learn how to automate repetitive tasks.  This course moves at a fast past and is an introduction to the basics of editing macros.

Course Dates:

11th Oct 2017 (fully booked)

19th Dec 2017 (spaces available)

23rd Jan 2018 (spaces available)

21st Feb 2018 (spaces available)

20th Mar 2018 (spaces available)

20th Apr 2018 (spaces available)

21st May 2018 (spaces available)

19th Jun 2018 (spaces available)

Course Length: 1 day

Course Costs:

Standard Price: £300 (+VAT)

Charity: £200 (+VAT)

Public Sector: £245 (+VAT)

Book now

Course Location

Happy, Alie Street – view map & directions

Course Requirements

Delegates must be experienced Excel users who understand the difference between relative and absolute cell referencing.   The course is aimed at those who have extensive experience of using Excel and are familiar with using worksheet functions, using multiple arguments and nesting functions.  Experience of recording basic macros is essential.

What You Will Learn

In particular you will be able to:

  • Record relative and absolute macros.
  • Run macros from buttons and shortcut keys.
  • Edit macros in the VBA Window.
  • Make macros more flexible by adding user prompts.
  • Create VBA code to split up text strings.
  • Loop macros using VBA.
  • Create macros that run other macros.
Book now

Timetable

Session 1

Recording Macros; Relative vs. Absolute macros; Assigning macros to a button on a spreadsheet; Assigning macros to a button on a toolbar.

Session 2

Introduction to the VBA Window; Editing macros in VBA; Creating user prompts in macros.

Session 3

Text Functions; Looping code using VBA.

Session 4

More macros; Running one macro from another; Getting help with VBA.


SMALL PRINT

The course will run from 10am to 4:45pm (light cold buffet 1pm to 1:45pm). Please be careful to arrive by 9.45am for registration and refreshments. The course will start precisely on time and it may not be possible to go back over material missed by late arrivals. If you arrive over 30 minutes late you may be asked to leave and attend another day.

Please ensure you read our Terms and Conditions before booking for our payment terms and cancellation policy.


THE HAPPY GUARANTEE

We want everyone to go away from our courses feeling as though they have learnt useful, practical skills that they can use straight away when they go back to work.

If you don’t feel that your training has been useful or if you are unhappy in any way, please just get in touch with our Customer Services team within 30 days of the course. We will be happy to offer you additional support and training free of charge to help you to gain the skills you need, or if you’d prefer, a full refund.

Your Course Trainers

Darren Andrews

Darren Andrews

Darren is one of Happy's Senior Trainers, able to train almost every IT course on the Happy Computers course programme. He has been with Happy for nearly ten years.

Paul Wherly

Paul Wherly

Paul trains on Microsoft products both on the Mac and PC platforms including VBA. Paul has trained with Happy since "the dawn of MS-DOS when formulas ruled the earth."