We offer training on both Windows and Mac computers locally around Cambridge but also any location in the UK and abroad if required:
Delegates will gain a general knowledge of VBA to manipulate and improve processes using Microsoft Excel.
Designed for advanced users of Excel.
Delegates should be experienced advanced level users of Microsoft Excel or have attended the Advanced Formulae and Functions and Validate and Summarise courses. This is a very fast paced course and a knowledge of recording macros is required.
What is Visual Basic for Applications?
An Introduction to Macros
Understanding the Visual Basic Environment
Managing Error Messages
Working with Variables and Data Types
User Defined Functions
Understand Objects and Collections
Add conditions to your macros
Communicate with the user
Repeating Actions in VBA – Loops
Customise Menus and Toolbars
Automation with Macros