FORGOT YOUR DETAILS?

Learn Excel VBA and Macros for Advanced Users

Live Online Learning (1hr 15min)

If you are already confident recording simple macros in Excel, take your knowledge further and learn Excel VBA Visual Basic and Macros in this advanced live online training.

From basic terminology to final testing, our expert instructor will walk you through all the essential elements and processes, helping you learn Excel VBA and programming simple code into Excel.

This Learn Excel VBA and Macros for Advanced Users training session is suitable for users of Excel 2013 and 2016.

What will I learn?

How to use Visual Basic Editor environment - Explore the different parts of the Visual Basic Editor interface.

How to create a new sub procedure - Your first steps in programming a new macro and adding comments.

How to program macro terminology - Learn the basic terminologies and concepts when programming macros.

How to work with sub procedures - Start a new sub procedure in the code window of Visual Basic Editor.

How to create simple program codes - Write program codes for selecting cells, assigning values and formatting cells and ranges.

How to run sub procedures - Run a macro created in the codes and assign shortcut keys.

How to test and debug a sub procedure - Learn how to test and correct simple errors in a sub procedure.

Requirements - You should have a good knowledge of Excel 2013 or 2016, and have experience of recording simple macros.

What Are Live Online Sessions?

Live Online gives you all the benefits of classroom training, but from the comfort of your home or office. Sessions take place on a shared online screen, where your friendly trainer will guide you and your class through the learning topic.

These interactive sessions also give you the opportunity to practice what you’ve learnt, as you take control and demonstrate your new skills to your trainer. Two-way text or voice chat is always available, for when you want to discuss a topic, need help, or want to ask any questions.

Cost:

£95 per person, per session

Maximum Group Size:

6 people

Request Training

t: 0203 941 4100 | e: [email protected]

Course Content

  • What is the Visual Basic Editor
  • What are the different parts of the Visual Basic Editor interface
  • How to program a new macro
  • How to add comments to a macro
  • What are the basic terminologies of macros
  • What are the common concepts of programming macros
  • How to start a new sub procedure in Visual Basic Editor code window
  • How to write program codes for selecting cells
  • How to assign values
  • How to format cells and ranges
  • How to run the macro created in the codes
  • How to assign shortcut keys
  • How to test for simple errors in a sub procedure
  • How to correct errors in a sub procedure
TOP