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 currently being delivered Live Online but still 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

Due to COVID-19 we are now offering our courses remotely helping you structure your day and focus on learning a new skill.
Courses are small - up to 4 delegates only.

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.

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

Wed 27th October 2021 (Live online)
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


Wed 27th, Thu 28th & Fri 29th October 2021 (Delivered Live Online)
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.

Coronavirus - Remote / Online IT Training

Coronavirus - Remote / Online IT TrainingIn the current climate, we are offering training remotely.

Our experts will hook up with you via a remote connection and the course will be delivered this way.

Many companies are adopting this delivery method and it's working well to keep structure whilst working from home and providing something positive to focus on.

You can have a group session, or one to one, or attend a public course on which we are only enrolling 4 delegates. You still have our after course support service for 1 year after delivery.

We will post out to you the course materials to work with during the training session.
Please contact us for further details:
E: info@tcstraining.co.uk
T: 02380 527816