Intermediate VBA in Excel

Short course

In London, New York (USA) and Amsterdam (Netherlands)

£ 725 + VAT

Description

  • Type

    Short course

  • Level

    Intermediate

The purpose of this one day workshop is to take delegates VBA knowledge to the next level.

After this course delegate will be quicker and more efficient in VBA programming. They will also be able to produce complex user interactions through advanced userforms and automate some fundamental tasks such as emailing Excel content

Facilities

Location

Start date

Amsterdam (Netherlands)
See map

Start date

On request
London
See map

Start date

On request
New York (USA)
See map

Start date

On request

About this course

This course is primarily intended for those people who have attended the ‘Introduction to VBA in Excel’ course.

However, someone who is already familiar with VBA would also benefit from attending and we would recommend looking at both course outlines to select the one containing the largest amount of relevant, new, material

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • VBA
  • Excel

Teachers and trainers (1)

TBC TBC

TBC TBC

TBC

Course programme

The purpose of this one day workshop is to take delegates VBA knowledge to the next level.

After this course delegate will be quicker and more efficient in VBA programming. They will also be able to produce complex user interactions through advanced userforms and automate some fundamental tasks such as emailing Excel content

Specifically, participants will learn:

  • Full VBA data type understanding
  • Use of the Immediate window
  • User defined functions
  • Add-ins
  • Personal macro workbooks
  • Loop structures other than FOR NEXT
  • Pivot tables with VBA
  • Advanced Userforms
  • Event procedures including non object related events
  • Automating email from within Excel

Intermediate VBA in Excel

£ 725 + VAT