Add EXL4 to my courses Excel VBA Level 1 (1 day - £295, plus VAT)

Microsoft Excel VBA Training Courses in London

Designed for experienced Excel users familiar with both basic and advanced features and functions. This course provides an overview of VBA and introduces users to basic VBA programming techniques.

Basics

Excel VBA overview
Understanding macro steps
Modifying macro steps
Storing values in variables
Adding comments to your code
Stepping through macros
Getting help on macros
Objects, properties and methods
About Excel objects

Range object

The Selection property
The Range property
Targetting cells

Counting the cells in a selection
Using the Offset statement
Retrieving the value of a cell
Retrieving a formula from a cell
Setting the value of cells

Using Visual Basic

Language structure
Using variables
Declaring variables
Data types
Making decisions
If statements
Looping structures

Interactivity

Assigning a macro to the Ribbon
Assigning a macro to the QuickAccess Toolbar
Assigning macros to other objects
Built-in dialogue boxes
Using form controls

 

Back to top

Macresource Business SoftWare Training Courses
Access training | Excel training | Access VBA training | Excel VBA training
Project training | Visio training | Outlook training | Windows XP training
FileMaker training | MySQL training | PowerPoint training | Word training
Free computer software tutorialsLondon computer training room hire