TCS Training IT Training
IT training, delivered in a way you’ll understand IT

Remote/Online Microsoft Excel Macros and VBA training

We don't just offer an Excel Macros and VBA training course, we support you afterwards too.

All training courses are delivered Live Online with our 5* service.

Public courses, private courses - live online or at your company offices

Contact us

Remote/Online Microsoft Excel Macros and VBA Training Courses

Our Microsoft Excel VBA training courses are delivered live online helping you structure your day and focus on learning a new skill without the need to travel.
We post your course materials out to you and then send course joining instructions ensuring you have everything you need for a successful and engaging day.
Our public courses are small - up to 4 delegates only.

If you would prefer one of our trainers to visit your offices to deliver your training, please let us know as we may be able to accommdate if we have a trainer in your area.
We also offer group booking rates for live online delivery - just let us know how many delegates you would like training for and we will put together a quotation and send you dates to choose from.

If an advertised public course date doesn't suit you, then please do ask as we may be able to run the course on an alternative date.

Microsoft Excel Macros and VBA Introduction Course - One Day

Learn to write Microsoft Visual Basic for Applications (VBA) to automate tasks in Microsoft Excel. By writing and running a procedure, referred to as a macro, you can quickly automate Excel's features and chores, report generation and other endless tasks including dashboard driven analysis.

We offer this course as a three day comprehensive course, or you can opt to take Day 1 of the course on it's own, with an option to attend the second and third days together at a later date.

Training Dates

Please contact us for a dates to suit you






Please contact us to arrange dates to suit you either Live Online or at your offices if the date advertised doesn't work for you. Group booking rates are available on request.


Price

£375

Download Course Details

Microsoft Excel Macros & VBA One Day Introduction Course Outline
Book this course

Microsoft Excel Macros and VBA 3-day Course

This course will take an absolute beginner from recording a macro to building an interactive solution. Delegates will learn how to implement user-friendly methods for running macros.

The course teaches the relevant skills in creating macros to enhance Excel and to automate repetitive tasks such as analysing and manipulating data. Practical exercises support all topics covered and include development of an intuitive user application.

Best programming practices will be covered to include discussion of validation and effective error handling. An overview of some of the technical aspects of VBA and programming provide the delegate with a sound basis for further developing their skills.

As well as the workbook/reference, a complimentary memory stick is provided to take away examples.

Course Pre-requisite: Delegates must have Advanced level knowledge of Microsoft Excel to attend.

Training Dates


Please contact us for a date to suit you




Please contact us to arrange dates to suit you if the advertised dates do not work for you, either Live Online or at your offices. Group booking rates available on request.

Price

£1035

Download Course Details

Microsoft Excel Macros & VBA 3-day Course Outline
Book this course

Microsoft Excel Macros & VBA Training

Microsoft Excel Visual Basic for Applications (VBA) is a computer programming language used to control Excel's functionality by automating tasks, building user defined functions and much more.


An Excel macro is stored VBA code saved as a procedure which can then be used to repeat commonly performed tasks by using a trigger such as a keyboard shortcut, toolbar icon or button within Excel.

Learn Microsoft Excel Macros and VBA the easy way, with TCS Training. We give you the skills you can apply with confidence, ensuring you get the most from the Excel code you write.

Course Pre-requisite: Delegates must have Advanced level knowledge of Microsoft Excel to attend.

We also offer bespoke training courses with consultancy - details available on request.

Book or Enquiry: Microsoft Excel Macros & VBA Training Course

Please help us by completing all fields


Note: We will endeavour to book you on your desired course date, but if not, we will offer an alternative date.

Live Online Training Delivery – how it works

Live Online Training Delivery – how it works We email you a link to join the course where our expert trainer will deliver instructor-led training. 

This is similar to classroom delivery, but you’re watching on a second screen, rather than the trainer being physically in front of you.

Many companies are adopting this delivery method and it’s working well to keep structure whilst working from home or taking the course in your office meeting room without the need to travel.

However, we know that although things work well on the course, when putting things into practice you may need a bit of extra support – so all courses include support for 1 year. If you do however want a trainer to deliver training at your offices, we may be able to provide this also.

Please contact us for a discussion, whatever your training need.

E: info@tcstraining.co.uk
T: 02380 527816