Course Search:

Excel Macros from A to Z

Description:
This course refreshes the skills of Advanced users of Excel on the basics of Macros, then builds on the knowledge of participants to enable them to create, vet and edit Macros effectively and accurately.
  • Cost: €395.00
  • Duration: 1 day
  • Cork Date: 17 Aug, 04 Oct, 13 Dec
  • Limerick Date: 20 Jul, 10 Aug, 04 Nov
  • Dublin Date: 02 Aug, 08 Sep, 28 Oct
  • This course is also available as a customised client specific course.
Prerequisites:
All participants should have a strong working knowledge of Excel to Advanced level.
Introduction – a recap:
Macros
Recording Macros
Playing a Macro
Macro Security
Editing a Macro
The Fundamentals of Excel VBA:
The Visual Basic Editor:
Interacting with the User:
Programming Fundamentals:
Excel Worksheet Functions in VBA
Dates and Times
String Functions
Financial Functions
User Defined functions and Sub Procedures:
Write user functions
Passing Parameters to a function
Returning values from a function
Debugging:
Debugging and Error Handling
The Immediate Window
Watch Windows
Breakpoints and single stepping


Dublin: 01 6627700 - Cork: 021 4319010 - Limerick: 061 311982

© Professional Training Solutions Limited 1996-2010
CRO No. 252390 - Unit 22, Westland Square, Pearse Street, Dublin 2, Ireland.