Description

By the end of this course you should be confident to create procedures for controlling the behaviour and appearance of Excel spreadsheets, create procedures to automate repetitive office tasks such as formatting, copying and pasting between workbooks and entering formulas.

You should be an advanced user of Excel and ideally have attended Intermediate and Advanced level courses prior to attending this course.

INTRODUCTION TO MACROS

• Recording a Macro
• Running a Macro
• The Visual Basic Editor
• The Project Explorer
• Properties Window
• Relative and Absolute References

OBJECTS, PROPERTIES, METHODS

• Cells and ranges
• Worksheets
• More complex objects
• Collections
• Performing Multiple Actions on an Object

VARIABLES

• Using Variables
• Declaring variables
• Variable Data Types

WORKBOOKS

• Opening workbooks
• Saving workbooks
• Closing workbooks
• Using paths in macros
• Flexible file names

It is 1-Day Programme and spaces are limited.

Please book online

For more information contact Cillian Griffey email cgriffey@shannonchamber.ie or call 061 360611

Training Cancellation Policy: Training courses which are cancelled over 7 days in advance of scheduled training date shall incur no cancellation fee. Training courses which are cancelled within 7 days of scheduled training date shall incur a cancellation fee equal to 50% of the cost. Registrants who fail to attend training will be charged 100% of the full fee.

Please quote Purchase Order number if required on invoice. Cheques should be made payable to Shannon Chamber Skillnet.

Shannon Chamber Skillnet is co-funded by Skillnet Ireland and member companies. Skillnet Ireland is funded from the National Training Fund through the Department of Education and Skills.

For further information please visit www.skillnetireland.ie