Microsoft Excel VBA Training Courses
Course schedule - Microsoft Excel VBA Training Courses
Classroom Training:
Learn to write VBA code with confidence
We will teach you how to write code using Microsoft Excel Visual Basic for Applications (VBA) which 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. Whether you are searching for an Excel VBA course for beginners or you have written code before and want to build on those skills, we have the course for you. Our Microsoft Excel VBA courses with certificate and comprehensive course materials also include after course support for 1 year on the course contents.
Course Pre-requisite: Delegates must have Advanced level knowledge of Microsoft Excel to enrol.
What makes TCS Training different from other IT Training providers?
We offer:
Hands-on IT training - engaging courses delivered by friendly and qualified trainers.
Public courses are small - up to 4 delegates only.
1 year after course support is included with all courses.
Group booking rates are available on request.
100% of participants recommend TCS Training - read live reviews
Microsoft Excel VBA Introduction Training Course – One Day – £355
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 features and procedures, report generation and other endless tasks including dashboard driven analysis.
On our Microsoft Excel VBA Introduction course you will learn about recording and running macros and then edit the code within. You will also learn about the VBA object framework and write code from scratch to perform a variety of tasks.
No previous Excel VBA code knowledge is required to attend this course. However delegates should have good experience in using Microsoft Excel.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
Microsoft Excel Macros & VBA one day Introduction training course outline
Recording and running macros
Macro recording
Record Relative macros
Different ways to run macros
Visual Basic for Applications (VBA)
Overview of the VBA environment
Review the macro code
Components of your code
Edit macro code
Code format
Coding standards
Writing macro code
Create a module
What is a procedure?
Write a complete macro procedure in the code window
Run procedures from the VBE
Getting Help
Context sensitive Help
VBA Help topics
Refer to specific parts of a workbook
Working with ranges and selections
Named Ranges
Naming and renaming worksheets in macro code
Communication with the user
Create dialog boxes
Delegates must be comfortable with topics covered at the Advanced level to attend.
Microsoft Excel VBA Intermediate Course – One day – £375
When you’ve mastered the basics in writing VBA code and want to learn about using VBA coding for decisions making, looping and writing VBA code to perform Excel functions our Excel VBA Intermediate course is for you. You will also learn about the VBA User Form Editor and controls and also error handling code.
Course Pre-requisite: Delegates must have attended our Microsoft Excel VBA Introduction level or be comfortable with writing code to Introduction level.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
Microsoft Excel VBA Intermediate training course outline
Arrays and Loops
• Introduction to arrays
• Loop types
• Do until and do while loops
• For next loop
• For each loops with collections
• Choosing the correct loop for repeated tasks
Decision Structures in VBA
• Using IF to make decisions
• Testing for multiple conditions
• Using Select CASE
• Call other procedures
Debugging and working with multiple macros
• Debugging Features in VBA
• Calling one Macro from Another
VBA Functions
• Creating Custom Excel Functions in VBA
• Using user-defined Functions in a worksheet
• Using Custom Functions in Macros
• Decision making with Select Case
• Declaring multiple arguments in a function
• Distributing functions
Error Handling & Tables
• Error Handling in VBA
• Finding the extend of data in a Spreadsheet
• Introduction to Using Excel Tables in VBA
Working with Forms
• Introduction to the VBA User Form Editor
• Creating a Custom Dialogue box with a User Form
• Creating a user form
• Adding form controls
• Setting properites for the form and controls
• Creating the event code for controls
• Initialising the form
• Closing the form
Workbooks and Worksheets
• Workbook objects and methods
• Creating a new workbook
• Saving and closing a workbook
• Adding and renaming sheets
• Using the cells property to select a range
• Using the offset property to refer to a range
• Using the columns and rows properties to specify a range
• Using the currentregion property to select a range
Error Handling
• Stepping through a procedure
• Using a break point
• The On Error Statement
• On Error GoTo
• The Resume
Microsoft Excel VBA Advanced Course – 1 day – £395
Our Microsoft Excel VBA Advanced course moves you on through your VBA coding journey to writing variables, functions and arrays. You will learn to create and work with forms, charts and Pivot Tables using VBA code.
Additionally you will write code for exporting of data including creating output files for multiple sheets exportation.
Course Pre-requisite: Delegates must have attended our Microsoft Excel VBA Intermediate level or be comfortable with writing code to Intermediate level.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
Microsoft Excel Macros and VBA 3-day training course outline
Introduction to Excel Macros and VBA
Recording macros
Running macros
Reviewing the code,
Familiarisation with the VBA environment
Running code from the VBE, Getting help
VBA Terminology
Modules and procedures
Components of your code
Objects
Collections
Properties
Methods
Programing Standards
Code format
Naming conventions
Procedural structure
Data Types, Variables and Operators
Working with variables
Using data types
Working with operators and expressions
Workbooks and Worksheets
Adding worksheets in the VBA code
Naming and renaming worksheets
Decision Structures in VBA
Using If to make decisions
Using select case
Loops
Do until and Do while stop Loops
Fur next Loop
Manipulating Data
Working with Ranges and Selections
Using the cells property to select a range
Using the offset property to refer to a range
Using the columns and rows properties to specify a range
Determining the extent of data
Working With Functions
Communicating with the user
Using Excel functions in VBA code
Custom Forms / Dialog Boxes
Creating a simple user interface
Adding form controls
Setting properties for the form and controls,
Linking the form to spreadsheet data
Closing the form
Error Handling
Stepping through a procedure
Using break points
Using the Immediate window
Debugging
Delegates must be comfortable with topics covered at the Advanced level to attend.
You may also be interested in these related courses
Microsoft Excel Courses
Our Microsoft Excel courses offering from Introduction through to Advanced Plus level in this versatile spreadsheet application. We also offer courses in Excel Data Lists and Dashboards, Power Query and Excel Scripts.
Microsoft Power BI Courses
On our Microsoft Power BI courses you will learn about the powerful business analytics tools helping you visualise your data and share insights across your organisation. You will produce and share reports and dashboards and collaborate on data analysis.
Microsoft SharePoint courses
Our Microsoft SharePoint courses to learn about this versatile tool to enhance productivity and collaboration within your company. Used for document management, collaboration, workflow automation and even website creation!
View all our IT Training Courses
Microsoft
Courses
Adobe
Courses
Programming
Courses
What our customers say
Why Choose TCS Training?
Expert Instructors
Our courses are led by experienced and certified trainers who are experts in their fields.
Flexible Learning Options
We offer both live online and on-site training to fit your schedule and learning preferences.
Comprehensive Course Materials
Receive detailed workbooks, reference manuals, and other resources to support your learning.
Post-Course Support
Benefit from up to a year of after-course support to help you apply what you've learned.
Customizable Training
We provide standard, tailored, or bespoke training solutions to meet your specific needs.
Group Booking Discounts
Take advantage of special rates for group bookings, whether for public or private courses.
Work with us
Want to chat to someone from our team about a training course or need something tailored for you - no problem.