VBA for Excel Training Courses York, Sheffield, Newcastle, Nottingham, Derby, Leeds, Bradford, Manchester, Chesterfield, Lincoln, Birmingham, Leicester, Coventry, Northampton and surrounding areas

Microsoft Excel VBA versions available for training courses include: MS Office 97, MS Office 2000, MS Office XP, MS Office 2003, MS Office 2007, MS Office 2010.

FSI Training specialise in delivering small to medium-sized group training courses tailored to your particular business needs including formal instructor led classroom training, on the job training, training workshops, training consultancy and floorwalking to support newly trained staff. If you are looking for a public training course at a training centre see here.

For longer training requirements, Microsoft training rollouts and training projects, please enquire.

If you don't have a suitable place for us to deliver your training onsite we can also offer a range of public Microsoft Excel training courses at training centres including London, Birmingham, Leeds, Manchester, Reading, Milton Keynes and at many other locations around the UK. - read more.

Excel VBA Introduction Training Course Topics

This one day course introduces proficient users of Microsoft Excel to the fundamentals of Visual Basic programming for Applications (VBA), the macro language of Excel, providing the techniques needed for automating and enhancing Excel spreadsheets with VBA programming.

Using the VBA Editor

1. Windows and Panes in the VBA Editor
2. VBA Editor Menus
3. Editor Modules
4. Project Explorer

Recording, Running & Editing Macros

1. Recording Macros in Excel
2. Running Macros in Excel (Shortcut Keys, Menu, Toolbar)
3. Editing Macros in Excel

VBA for Excel Programming Essentials

1. VBA syntax
2. Using Variablesin Visual Basic
3. Comments
4. Objects
5. Properties
6. Methods

VBA Dialogue Boxes

1. Msgbox
2. Inputbox

Controlling Flow

1. Decision Making: If...Then clauses and Select Case
2. Loops and recurrance: For...Next and Do ...Loop

VBA Forms in Excel

1. Creating User Forms
2. Form controls

Debugging and error handling in VBA for Excel

1. Debugging (understanding errors, using debugging tools, the watch window, the immediate window)
2. Error handling and trapping errors

Excel VBA Training Course Levels: delegates for this course should be already proficient in the use of Microsoft Excel to either a high intermediate or advanced level.

Selection of other MS Excel training course outlines

• Intermediate Excel training course - advanced formatting/editing in Excel
• Intermediate Excel training course - workbook features
• Intermediate Excel training course - organising workbooks
• Intermediate Excel training course - lists and databases
• Intermediate Excel training course - advanced charts
• Advanced Excel training course topics - what if conditional analysis
• Advanced Excel training course topics - sharing and getting data

Excel Training Testimonials

Very informative, easy to follow. Trainer was clear with his explanations
S Nottingham, Denney O'Hara (Microsoft Excel training Leeds)

Excellent day!
L McLachlan, Grange School (Excel training Rochdale)

Brilliant Training, went at the right speed [and] was made relevant to work
Kathryn Strong, Tennants Distribution (Excel training Manchester)

Fantastic course, not too much information overload. Explained simple. Exactly what I needed. Many thanks.
K Stobbs, Depuy Spine - A Jonson and Jonson Company (Introductory Excel training Leeds)

more testimonials

You can find further reading on Microsoft Excel at the FSI software bookshop.

Excel VBA Training Course Locations:

West Yorkshire: Leeds, Bradford, Halifax, Huddersfield, Wakefield, Bingley, Pontefract, Castleford, Dewsbury, Keighley

South Yorkshire: Sheffield, Doncaster, Barnsley, Rotherham

North Yorkshire: Skipton, York, Harrogate, Wetherby, Whitby, Scarborough, Middlesbrough

Lancashire: Manchester, Preston, Blackburn, Accrington, Burnley, Oldham, Bolton, Wigan, Liverpool, Lancaster, Stockport, Southport, Rochdale

Derbyshire: Derby, Chesterfield, Dronfield, Long Eaton

Nottinghamshire: Nottingham, Ilkeston, Mansfield, Sutton in Ashfield, Worksop, Hucknall, Beeston

Lincolnshire: Lincoln, Gainsborough, Boston, Sleaford, Market Rasen, Grantham, Grimsby, Scunthorpe, Cleethorpes, Skegness

Leicestershire: Leicester, Loughborough, Hinckley, Melton Mowbray, Coalville, Lutterworth

Warwickshire: Warwick, Birmingham, Coventry, Nuneaton, Rugby, Solihull, Redditch, Stratford-upon-Avon

Cheshire: Chester, Stockport, Birkenhead, Wallasey, Runcorn, Macclesfield, Crewe

Staffordshire: Stafford, Stoke-on-Trent, Wolverhampton, Walsall, Cannock, Lichfield

Northamptonshire: Northampton, Peterborough, Corby, Kettering, Wellingborough

Northumberland and Tyneside: Newcastle, Sunderland, Redcar, Gateshead, Whitley Bay, Chester le Street, Consett, Ponteland

FSI is continually expanding the areas in which we are able to provide training courses across the UK. If you are unable to see your location here, then please have a look at the most recent additions to our software training locations.

Other Microsoft Office Training Courses in Leeds:

-- Microsoft Word Training Course
-- Microsoft Access Training Course
-- Microsoft PowerPoint Training Course
-- Microsoft Outlook Training Course
-- Microsoft Office 2007 Introductory Training Course
-- Microsoft Project Training Course
-- Microsoft Visio Training Course

Let us know what computing skills you are interested in and what level of technical training is required and we can even tailor our software training packages to fit your specific business needs. One-to-one onsite training packages are available for only £300 (plus VAT) per day.

Cost-effective Microsoft Excel training courses for small groups

For small group teaching of up to ten people we offer a cost-effective payment model available for one day training courses aimed at charities, small to medium-sized businesses and organisations.

The first person is charged at the standard one-to-one day rate which for most courses is £300.00 plus VAT, the second person at £75.00 plus VAT and everyone one there after at £50.00 plus VAT for up to ten people in total. This means that we can now offer a day's training for a group of five people for only £525.00 plus VAT. (small surcharges may apply for printing of teaching materials and additional travel.)

Please note that this applies only to one day courses where students are being taught together on client premises, on the same version of the software, and where all students are at similar competency levels.

Travel supplements may apply

Training Facilities

For groups of five and above, we can organise a fully-equiped training suite for you close to Leeds city centre, or in the city of your choice, and at a reasonable price for full and half days. Facilities include, networked PCs, overhead projector, high-speed internet access and refreshments. If you would like to hire a training suite for your training sessions, please let us know in good time and we can make arrangements. All training rooms are compliant with the Disability Discrimination Act.

Training for individuals and small groups is usually delivered on site at client premises, so you will need to be able to provide a small computer suite, cluster or training area where we can work. Trainees should also come equipped with writing materials and stationery as these are not provided.

To book a training course simply call 0844 493 3699, or email training@foursquareinnovations.co.uk

Microsoft Excel VBA Training Course FAQs

Q: Why do we offer one-to-one training courses?

A: Providing one-to-one training means that we can devote our attention specifically to you and the pace you want to learn at. You get the full and undivided attention of our dedicated trainers throughout the duration of the course, allowing then to identify and nurture your strongest competencies and to identify and help you to overcome areas where you are having difficulty.

Q: Do you cater for groups of trainees?

A: Yes, we can cater for groups and training can either take place on your premises or at a training suite in a city of your choice.

Q: Why do you offer bespoke/tailored training courses rather than off-the-shelf training courses?

A: While we do provide off-the-shelf training courses, we also think it is important to offer you the opportunity to focus on the specific skills you want to learn. Many IT training companies take a one-size fits all approach to software training and book you in as part of a group on a pre-diarised day to learn a generic syllabus. Our approach to training is to allow you to specify areas of the software that you want to concentrate upon, and then tailor your training course accordingly. This gives us the flexibility to respond to your specific business needs. This also allows us to train you on the exact version of the software that you use in the workplace.

Q: What information do you need from me when I book a training course?

A: We need to know what version of the software you want training upon, your level of competency (e.g. intermediate or advanced) and information about any specific training requirements you have.