Introduction to VBA in Excel
Short course
In New York (USA), London and Amsterdam (Netherlands)
Description
-
Type
Short course
-
Level
Beginner
-
Location
-
Duration
1 Day
The purpose of this one day workshop is to introduce participants to the VBA language which resides within Excel. No prior knowledge of programming is required and only a basic knowledge of Excel will be enough to maximise benefit from this session. In just one day participants will be able to record, edit and write useful VBA code. The course is interactive throughout with delegate learning through building the code themselves as opposed to watching a presentation on the concepts.
Facilities
Location
Start date
Start date
Start date
Start date
About this course
Anyone who uses excel will benefit immensely from this course. Any repetitive tasks can be automated. Any user experience can be improved. Any complex task can be simplified.
Reviews
Subjects
- VBA in Excel
- Macro
- Language and environment
Teachers and trainers (1)
TBC TBC
TBC
Course programme
The purpose of this one day workshop is to introduce participants to the VBA language which resides within Excel. No prior knowledge of programming is required and only a basic knowledge of Excel will be enough to maximise benefit from this session. In just one day participants will be able to record, edit and write useful VBA code. The course is interactive throughout with delegate learning through building the code themselves as opposed to watching a presentation on the concepts.
Specifically, participants will learn to:
- Understand the framework of the VBA language and environment
- Navigate the VBA editor and functions within Excel
- Record, edit and write a macro
- Apply fundamental programming building blocks such as loops
- Design and code user forms
Introduction to VBA in Excel