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:London, Manchester
Next course:Tue 26 September 2017
Time:09.30-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

Recording macros and buttons

Absolute and relative recording
Where macros can be stored
Assigning macros to buttons

Selecting cells

Selecting cells (absolute)
Selecting cells (relative)
Selecting to the end of a block
Selecting a range by its corners

The VB code editor

Using Project Explorer
Creating modules
Basic subroutines and comments

Messages and variables

Input boxes and message boxes
Declaring variables
Option Explicit
Scope of variables
Constants

Visual Basic explained

The Excel object model
Objects and collections
Methods and properties
Getting help in VBA

Loops and conditions

Simple IF conditions
Multiple IF and SELECT / CASE
Three main types of loop

Looping over collections

Object variables
Looping over collections

Event handling

Assigning macros to events
Cancelling events

Functions

Declaring functions
Passing arguments

Debugging and error handling

Setting breakpoints
Stepping through macros
ON ERROR statements

Forms

Drawing forms
Attaching macros to controls
Validating form input

Covered if time allows If time

Referencing other applications

Links to Word or Access
Working with files and folders

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
492 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

Sample customer feedback

"Forward thinking approach, is apparent from Wise Owl website."

Andy Taylor (Production Bureau Ltd)

"The course was brilliant and the trainer was a diamond. I have already written my first macro, it just needs finishing off; opens a couple of files and deletes out data that I normally delete manually. Didn't think I would be able to do that within days of the course. I was planning to start small, but once I got going I found my way around with some trial and error and checking google and the course manual. I am planning on going on the advanced course once I am ready. "

Abdul Khan (Places for People Group)

"Thoroughly enjoyed the introduction to the vast possibilities of VBA."

Matthew Walker (BerryWorld Ltd)

"Trainer was really, really good. (Excel Business Modelling) The trainer explains things at the perfect speed. Content is pitched at correct level. (Excel VBA macros)"

David Pearson (BAE Systems)

"All very well done and clear."

Damon Wigley (Figured In Limited)

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.

Other Microsoft Excel training resources

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

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

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

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

View Excel, Power BI - Excel or VBA macros blogs

This page has 0 threads Add post