Excel VBA

Computer Training Solutions
London, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This is a hands-on course, intended for advanced users of Excel, to enable them to automate complex or repetitive spreadsheet procedures. It will provide an in-depth introduction to the Visual Basic programming language (Applications Edition)

This course is designed for Excel developers how have already attended an advanced Excel course or who have attained similar knowledge.

As a result of this course, delegates should expect to be able to:

Automate complex or repetitive procedures by recording macros
Read, edit and debug Visual Basic code
Understand Objects/ Collections, Properties and Methods
Create user-interactive macros
Use and understand VBA Control-Structures
Build new worksheet functions
Create custom Dialog Boxes/ Forms

Main Topics Covered

Recorded Macros: avoiding the common problems, understanding the limitations.
How to run a Macro: customising the toolbars, assigning shortcut keys.
Finding and reading the code: modules, comments, keywords, and statements.
Understanding the Object model: the rules of grammar and syntax in an object oriented programming language, how to apply these, the Object-Browser.
Interacting with the user: Input Boxes and Message Boxes.
Looping: the For-Next loop, the Do-Loop, nested loops.
Variables: using and declaring variables to store data.
Making decisions; the If statement, the Block-If statement, Else-If, Select-Case.
Custom Functions: creating and using new functions on worksheets and in VBA code.
Debugging: how to respond to an error, the debug window, stepping through your Macro, the Watch window, the Immediate Pane.
Dialog Boxes/Forms: designing and building your own, adding controls, showing, controlling and interacting with your user built dialog boxes.
Event Driven Procedures: triggering macros automatically with workbook or form events.
Course Review (Time permitting): Question/answer session

...''

Elements of this syllabus are subject to change.

Phone:08456 44 1234

School Address:

Aurora House, 5-6 Carlos Place, Mayfair, London W1K 3AP UK

Jobs & Resumes: London
Houses & Roommates: London
Travel Agencies: London

Search other schools for Excel VBA training resources.

HTML
Paintshop Pro
PowerPoint Intermediate/Advanced
PowerPoint
Publisher 2003
Sage Line 50 - Accounts Intermediate
Sage Line 50 - Accounts Introduction
Sage Line 50 - Payroll
Word VBA
Visual Basic
CSS with XML
XLST & XPATH
XML
Acrobat
ASP Intermediate/Advanced
ASP
CorelDraw 12 Advanced

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.