Name: Microsoft Excel VBA
Rating: 4.9 (68 reviews)

Microsoft Excel VBA Course

This VBA and Excel course will unlock the power of coding in Excel. Learn how to create dynamic macros to automate repetitive tasks, streamline data processing, and enhance productivity.

Dive into the world of Visual Basic for Applications (VBA) and gain the skills to write custom code that extend Excel's functionality. Discover the art of coding with VBA as you build interactive applications, manipulate data, and control Excel objects.

This course will equip you with the knowledge and tools to harness the full potential of VBA in Excel.

This course requires solid Excel foundations — our Microsoft Excel Introduction and Microsoft Excel Advanced courses are the recommended starting points.

Course Outline

Getting Started

Displaying the Developer Tab
Recording and running a Macro
Macro-Enabled Workbooks
Using the Visual Basic Editor
The Development Environment
Understanding Macro Security

Working with Procedures and Functions

Understanding Modules
Understanding Procedures
Calling Procedures
Creating a Function Procedure
Working with the Code Editor

Understanding Objects

Objects and Collections
Working with Properties
Using the With Statement
Creating an Event Procedure

Using Expressions, Variables, and Intrinsic Functions

Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Using Intrinsic Functions
Understanding Constants
Declaring and using Object Variables

Controlling Program Execution

Control-of-Flow Structures
Working with Boolean Expressions
Different types of Control-of-Flow structures
Guidelines for use of Control-of-Flow Structures

Working with Forms and Controls

Working with UserForm Properties, Events and Methods
Working with different Controls
SettingControl Appearance
Populating a Control
Adding Code to Controls
Launching a Form in Code

Handling Errors

Understanding Error Handling
Writing an Error-Handling Routine
Working with Inline Error Handling

Questions and answers

This course is only available as a private course. This allows you to choose the dates for your training. And, if you wish, we can tailor the content for you or your team. Please contact us for more details.

Really thorough and could relate to struggles and correct some errors made

Very interactive & trainer tailored the course to suit our needs

Tom was fantastic, he tailored the course to suit what we were looking for meaning we will be able to use this in our day to day lives and make our jobs easier. Tom made the class interactive and kept us all really engaged. Highly recommend, thank you Tom

Really very thorough, very approachable and an enjoyable course

Very thorough referencing and alternative working options

Very interactive learning style, tutor is clearly very knowledgeable & friendly

Very relaxed tutor, calm and concise when correcting errors made by delegates, Me!

Loved the way the course was taught, by taking us through each step but getting us to do it at the same time, such an easy way to learn and helped make it easier to understand.

Great at explaining with relevant examples. Great at responsive learning and getting the group involved in problem solving.

Loved the teaching style Rob had, it really worked well for the training

I learned a lot, not just about the using VBA, but on methods to problem solve on my own. Really enjoyed the course

Great course, covered solid basics and happy to answer questions even if not 100% relevant which was great and helped shape the day and tailor to our needs.

Everything. Very clear and well explained

Course/ trainer was really informative - made sure we were all following along and understanding the topics as well as adapting some of the content to suit our specific needs Really enjoyed the session - looking forward to trying out some of the things I have learned The site is really nice and welcoming (great view!) and lovely refreshments

It was a thoroughly enjoyable day and I have learnt many new techniques that I can see how I can implement in my working life. I especially enjoyed learning about the shortcuts.

Communication, ease of understanding and friendly

Good at talking us through the examples step by step at a steady pace. Tom was very clear and concise and I learned a lot!

Course delivery and content was excellent

Tom was a saint with his patience and enthusiasm, he was knowledgeable and again, as a beginner course was very good.

Explaining training, clear instructions, Tom was very approachable confident to ask questions.

Clear explanations, good 1 to 1 time where required

Taking the time to explain simple steps if anyone got lost

Great explanations and overall teaching method!

The trainer was very knowledgable, had a great attitude and was very patient with us asking lots of questions!

Everything! All aspects were explained really well and easy to follow. I really enjoyed my first excel training day!

Tom was amazing. Helped along the way whenever anyone got stuck, very approachable. Went at a speed that enabled everyone to keep up

Microsoft Excel VBA Course

Reviews

Satisfaction

Recommend

Microsoft Excel VBA Course