Our trainers are certified Microsoft Excel specialists with years of experience teaching Excel. Get the spreadsheet skills you need with our Microsoft professionals.
Bespoke Microsoft Excel Macros & VBA 2 Day Introduction Training Course (Intermediate-Advanced users)



This two 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.
- Private Training
- Bespoke Course Content
- Online & Onsite courses
- Date(s) arranged to suit
This course can be based around our base outline or part/fully customised according to your level & requirements. Our bespoke Microsoft Excel training is offered either Online, Onsite at your offices or at one of the XChange centres in London, Manchester and Glasgow.
Bespoke Microsoft Excel Macros & VBA 2 Day Overview
Microsoft Excel is the standard spreadsheet application, an essential component of the Microsoft Office Suite. Excel provides comprehensive tools to help you create, analyse, and share spreadsheets, and its powerful, enhanced formatting features allow users to analyse and visualise data through the creation of graphs and charts.
XChange Training offer Microsoft Excel bespoke courses that are tailored to focus on your specific needs.
If you are interested in discussing bespoke training from XChange Training please contact our training department to discuss this option further or fill in our course-builder form and we’ll contact you with a proposed course outline tailored to your needs.
Course Target Audience and delegate prerequisites
Previous knowledge of recording basic macros is advantageous.
Bespoke Training Prices
The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.
- 1 delegate: £1095
- 2 delegates: £1245
- 3 delegates: £1395
- 4 delegates: £1545
- 5 delegates: £1645
- 6 delegates: £1745
- 7 delegates: £1845
- 8 delegates: £1945

I have done similar excel courses before but I felt I learnt a lot more on this one due to the way the trainer covered the material and explained everything very clearly.
Romilly Evans, Leo, Excel - 1 Day Intermediate
Bespoke Microsoft Excel Macros & VBA 2 Day Outline
The following is a general outline. The range of topics covered during your training is dependent upon student level, time available and preferences of your course booking.
Using Variables in Visual Basic- Create a Variable
- Use the Locals Windows
- Declare variables
- Variable Scope
- Using the Mcgbox Function
- Using the Inputbox Function
- Decision Making: If...Then clauses and Select Case
- Loops and recurrence: For...Next and Do ...Loop
- Create a set of macros to complete a task
- Modify the macros as required to add flexibility
- Working with calculations
- Automate Sum Functions
- Create a simple function
- Create a UDF using Built-in Excel functions
- Debugging (understanding errors, using the debugging tools, the watch window, the immediate window)
- Error handling and trapping errors
- Setting References to Other Applications
- Creating a PowerPoint Presentation from within Excel
- Creating a Word Document from within Excel
- Creating Worksheet Events
- Creating Workbook Events
- Creating User Forms
- Using Form controls
Bespoke Training Prices
The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.
- 1 delegate: £1095
- 2 delegates: £1245
- 3 delegates: £1395
- 4 delegates: £1545
- 5 delegates: £1645
- 6 delegates: £1745
- 7 delegates: £1845
- 8 delegates: £1945

I have done similar excel courses before but I felt I learnt a lot more on this one due to the way the trainer covered the material and explained everything very clearly.
Romilly Evans, Leo, Excel - 1 Day Intermediate
What's Included
The following are provided for your best experience on this bespoke course:
- Tailored course content arranged around your requirements
- Flexible dates to suit your desired timeframe
- Course location either at our training centres or onsite at your premises.
- All computers for your use with choice of Windows or Mac systems (not onsite)
- Quality reference manual for post course reference to take away with you
- 6 months post course support to assist you where needed
- Official Authorised Certificate for your successful completion of the course
- Lunch To give you the most flexible options for lunch we provide lunch vouchers which can be redeemed locally at a number of popular eateries including Pret A Manger, EAT, Starbucks, Tesco, Sainsburys, Boots and Gregs (not onsite)
- Refreshments to keep you on top form are available for you throughout the course with a full range of teas, coffees and biscuits (not onsite)
Included with your course booking for all delegates on this course is 6 months free support so if you run into problems or need assistance relating to anything covered during your course we would be happy to assist you during this time.
After your class with XChange Training you will receive our official Certificate as a record of your successful completion of the course.
Bespoke Training Prices
The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.
- 1 delegate: £1095
- 2 delegates: £1245
- 3 delegates: £1395
- 4 delegates: £1545
- 5 delegates: £1645
- 6 delegates: £1745
- 7 delegates: £1845
- 8 delegates: £1945

I have done similar excel courses before but I felt I learnt a lot more on this one due to the way the trainer covered the material and explained everything very clearly.
Romilly Evans, Leo, Excel - 1 Day Intermediate
Training Location Options
This course is offered for your convenience either at one of our bespoke training centres in London, Manchester and Glasgow or onsite at your offices anywhere in the UK. Just let us know what would work best for you or your team.
The location details of our bespoke training centres are shown below:
LONDON
5 St John’s Lane
Clerkenwell
London
EC1M 4BH
St John’s Lane is located in the heart of Clerkenwell close to the junction of Farringdon and Clerkenwell Road. Farringdon tube & train station is just a few minutes away and the training centre can also be accessed from Chancery Lane and Barbican tubes in about 10 minutes. There is also easy direct access by bus from Waterloo (243) and West End (55) with nearby stops.
MANCHESTER
Piccadilly House
49 Piccadilly
Manchester
M1 2AP
Piccadilly House is located in central Manchester directly next to the Piccadilly Gardens transport interchange with excellent bus and tram connections and is easily accessed from Piccadilly train Station (5 mins). Victoria station is also close by (around 10 mins).
GLASGOW
Centrum Business Centre
38 Queen Street
Glasgow
G1 3DX
The Queen Street training centre is located in central Glasgow within easy walking distance of the 3 local train options of Central Station, Queen Street and Argyle Street offering excellent transport connections.
Courses are run between 10am and 5pm with an hour break for lunch and both mid morning and mid-afternoon refreshment breaks.
Bespoke Training Prices
The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.
- 1 delegate: £1095
- 2 delegates: £1245
- 3 delegates: £1395
- 4 delegates: £1545
- 5 delegates: £1645
- 6 delegates: £1745
- 7 delegates: £1845
- 8 delegates: £1945

I have done similar excel courses before but I felt I learnt a lot more on this one due to the way the trainer covered the material and explained everything very clearly.
Romilly Evans, Leo, Excel - 1 Day Intermediate
Bespoke Course Enquiry
If you are considering this Microsoft Excel Course but would like further information simply send us your query quickly & easily with the form below. Whether you would like to check date availability, pricing, course suitability or just need further information about a course send us your query and we will get you a swift reply, usually within 2 business hours!
If you would prefer to check course details by phone please call us on 0345 363 1130.
Bespoke Training Prices
The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.
- 1 delegate: £1095
- 2 delegates: £1245
- 3 delegates: £1395
- 4 delegates: £1545
- 5 delegates: £1645
- 6 delegates: £1745
- 7 delegates: £1845
- 8 delegates: £1945

I have done similar excel courses before but I felt I learnt a lot more on this one due to the way the trainer covered the material and explained everything very clearly.
Romilly Evans, Leo, Excel - 1 Day Intermediate
Scheduled Microsoft Excel Training Courses
Bespoke Training Prices
The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.
- 1 delegate: £1095
- 2 delegates: £1245
- 3 delegates: £1395
- 4 delegates: £1545
- 5 delegates: £1645
- 6 delegates: £1745
- 7 delegates: £1845
- 8 delegates: £1945

I have done similar excel courses before but I felt I learnt a lot more on this one due to the way the trainer covered the material and explained everything very clearly.
Romilly Evans, Leo, Excel - 1 Day Intermediate
Testimonials
I have done similar excel courses before but I felt I learnt a lot more on this one due to the way the trainer covered the material and explained everything very clearly.
Romilly Evans, Leo, Excel - 1 Day Intermediate
Good pace and very clear directions. I will definitely be recommending XChange Training in the future.
Charlotte Green, AXA Investment Managers, Powerpoint & Excel - Bespoke Introduction
Good interactive training. Trainer was excellent. Thanks
Andy Doust, RRG Group, Microsoft Excel VBA 1 Day Introduction
The trainer was very good indeed. We got a lot out of the experience and will book again for more training in the future.
Neil Cleverley, TTS Group, Illustrator - 2 Day Migration
A good introduction to the wider functions of Premiere Pro delivered at a speed that was good for me.
Andrew Fowler, Groundwork, Premiere Pro - 1 Day Introduction
The trainer was great and had sound knowledge of Photoshop. He ensured that we were all happy with the content being covered.
Asad Chaudary, British Council, Photoshop - 2 Day Introduction
I have studied a course with XChange Training before and it is extremely well organised, friendly staff and has a good work environment.
Victoria Hassett, ETM Group, InDesign - 1 Day Introduction
With his very patient approach the trainer was able to get us to the stage we were hoping to be at by the end of the day. Many thanks.
Alan Sadler, Marie Stopes International, QuarkXPress - 1 Day Bespoke
I found the instructor very helpful and knowledgeable. I would like to return for further training...
Rebecca Sanderson, Frank Cass, Database Publishing - 1 Day Introduction
The Instructor was very knowledgeable in the subject matter and as the training could become heavy in places she managed to lighten the atmosphere with a good sense of humour!
Andy Jackson, Southdowns College, Premiere Pro 101 - 3 Day Introduction
Bespoke Training Prices
The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.
- 1 delegate: £1095
- 2 delegates: £1245
- 3 delegates: £1395
- 4 delegates: £1545
- 5 delegates: £1645
- 6 delegates: £1745
- 7 delegates: £1845
- 8 delegates: £1945

I have done similar excel courses before but I felt I learnt a lot more on this one due to the way the trainer covered the material and explained everything very clearly.
Romilly Evans, Leo, Excel - 1 Day Intermediate