Want to boost enrolments?
Login and promote your courses
Searching for courses?
Login or register
Classes Course
Place:
London
Price:
Duration:
1 Day
Start:
19/01/2009 other dates
See course programme
Requirements:
Designed for experienced Excel users familiar with both basic and advanced features and ... see more
| Requirements |
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.
|
| Price |
£295 + VAT
|
| 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 | |
| Where | London, United House, North Road, Islington see map |
| When | Start: 19/01/2009 Finish: 19/01/2009 See calendar |
| Where | London, United House, North Road, Islington see map |
| When | Start: 26/02/2009 Finish: 26/02/2009 See calendar |
| Where | London, United House, North Road, Islington see map |
| When | Start: 13/04/2009 Finish: 13/04/2009 See calendar |
| Where | London, United House, North Road, Islington see map |
| When | Start: 19/05/2009 Finish: 19/05/2009 See calendar |
| Where | London, United House, North Road, Islington see map |
| When | Start: 22/06/2009 Finish: 22/06/2009 See calendar |
| All venues | |
