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, but a wonderful experience in a beautiful venue.

All training courses are currently being delivered remotely but still with our 5* service.

All training courses include our after course support as standard.

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.

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 to arrange dates to suit you.


Dates are not always set in stone, so if you can't make a date above, please contact us anyway and we'll see what we can do for you.

Price

£375

Venue

Minstead Lodge, New Forest Venue Information

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 to arrange dates to suit you.


Dates are not always set in stone, so if you can't make a date above, please contact us anyway and we'll see what we can do for you.

Price

£1035

Venue

Minstead Lodge, New Forest Venue Information

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 functonality 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.

TCS Training offers courses away from the distractions of the office at our amazing venue in the New Forest, just 10 minutes from the M27 and Lyndhurst. A relaxing atmosphere allowing you to focus on learning and gain the most from your course. Alternatively we can deliver training courses at your company offices.

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. You don't need any special software installed to use this delivery method.

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. 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: [email protected]
T: 02380 527816