Bespoke Microsoft Excel Macros & VBA 1 Day Fundamentals Training Course (Intermediate-Advanced users)

Bespoke Microsoft Excel Macros & VBA 1 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

This course is designed for users with a good working knowledge of Microsoft Excel 2010 or 2013.

A good working knowledge of Microsoft Excel 2010 or 2013 to intermediate/advanced level, including formula and function writing. No knowledge of macros or VBA is required.

 

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: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £895
• 5 delegates: £945
• 6 delegates: £995
• 7 delegates: £1045
• 8 delegates: £1095

Bespoke Microsoft Excel Macros & VBA 1 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.

Recording, Running & Editing Macros

• Recording Macros in Excel
• Running Macros in Excel
• Editing Macros in the Visual Basic Editor
• Saving Workbooks containing macros

Introduction the VBA Editor

• Understanding Windows and Panes in the VBA Editor
• Navigating VBA Editor
• Editor Modules
• Working with the Project Explorer

VBA for Excel Programming Essentials

• Understanding the syntax of VBA
• Using Variables in Visual Basic
• Commenting your work
• Introducing Objects
• Introducing Properties
• Introducing Methods

Create Macro's that do simple tasks

• Sort Data
• Insert Rows and Columns
• Insert Text
• Format Text
• Duplicate Data

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: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £895
• 5 delegates: £945
• 6 delegates: £995
• 7 delegates: £1045
• 8 delegates: £1095

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)

Normal daily course times run between 10am and 5pm however we can offer flexibility for this bespoke course should your time requirements vary.

Microsoft Certified Trainer

Our trainers are certified Microsoft Excel specialists with years of experience teaching Excel. Get the spreadsheet skills you need with our Microsoft professionals.

6 months support

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.

Official Course Certificate

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: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £895
• 5 delegates: £945
• 6 delegates: £995
• 7 delegates: £1045
• 8 delegates: £1095

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: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £895
• 5 delegates: £945
• 6 delegates: £995
• 7 delegates: £1045
• 8 delegates: £1095

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.

Course Name:	Bespoke Microsoft Excel Macros & VBA 1 Day
Location Preference:	--Please Choose-- XChange - London XChange - Manchester Onsite at my offices Undecided
Knowledge level of delegate(s):	--Please Choose-- Beginner Some Notions Intermediate Advanced
Number of delegates:	--Please Choose-- 1 2 3 4 5 6 7 8 9 10+
Nature of enquiry:	--Please Choose-- Check Date Availability Course Information Request Price Enquiry Course Suitability Other
Lead contact name:
Email address:
Telephone number:
Company (if applicable):
Specific query details:
Captcha code	Please enter the Captcha code

 

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: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £895
• 5 delegates: £945
• 6 delegates: £995
• 7 delegates: £1045
• 8 delegates: £1095

Related Courses

Bespoke Microsoft Project Training Courses

Microsoft Project - 1 Day Advanced Training Course

Bespoke Microsoft Visio Training Courses

Microsoft Visio - 1 Day Advanced Training Course

Bespoke Microsoft Outlook Training Courses

Microsoft Outlook - 1 Day Advanced Training Course

Bespoke Microsoft Powerpoint Training Courses

Microsoft PowerPoint - 1 Day Advanced Training Course

Bespoke Microsoft Excel Training Courses

Microsoft Excel - 1 Day Advanced Training 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: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £895
• 5 delegates: £945
• 6 delegates: £995
• 7 delegates: £1045
• 8 delegates: £1095

Scheduled Microsoft Excel Training Courses

We currently do not offer any public scheduled classes for this application however our bespoke courses will be able to suit your requirements.

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: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £895
• 5 delegates: £945
• 6 delegates: £995
• 7 delegates: £1045
• 8 delegates: £1095

Testimonials

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

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

Very informative and fun. The hands on experience is an excellent feature, and being able to start working on what we ultimately hope to produce was very useful.

Paul Nezandonyi, Royal Holloway, QuarkXPress - 2 Day Bespoke

Very good content and the trainer was very enthusiastic.

Bruce James, City & Guilds, Microsoft Project - 1 Day Intermediate

Good very clear instructing, especially given that this was the first time I used the software. Excellent.

Sarah Tennant, Christie’s, Bespoke Apple Keynote 1 Day Introduction

Overall a very well presented course and I hope to be back for other courses.

Shazad Khan, The Stationary Office, Acrobat - 1 Day Introduction

Teaching was at a good pace and the instructions given were comprehensive without being overly technical. I have learned many things which will help in my ongoing graphic design work.

Zahir Raniwalla, M&I Materials, Photoshop - 2 Day Introduction

The trainer tailored the training course to my needs which was great. I feel that I have learnt a lot and will be able to apply this knowledge to editing the company website.

Katie Spike, Getech, WordPress - 1 Day Introduction

We had an excellent instructor for the InDesign course - as someone who had no prior knowledge, he explained everything thoroughly and enthusiastically. I will definitely be back if my training requirements change!

Francesca D’Alessio, Rider Levett Bucknall, Adobe InDesign - Two 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: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £895
• 5 delegates: £945
• 6 delegates: £995
• 7 delegates: £1045
• 8 delegates: £1095