Instructor-led training - Excel 2007 VBA Course
Microsoft Office Training verified by visa - mastercard securecode about microsoft training company london ukadd this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrintable version
email this page to somebodyEmail this page
Customer: Sign in
Delegate: Sign in
Trainer: Log in
 
spacer Customer account
At a glance
 
spacer New booking
Choose courses
 
spacer Enquiries
Contact usTraining vacancies
 
spacer Information
Pricing and availabilityExcel 2007 VBAForumHints and tipsLocation/map/parkingPromotionsSearch
 
spacer Training
Public schedule On-site training Closed company E-Learning
 
spacer Pricing
Public schedule On-site training Closed company E-Learning

Excel VBA Training Course London & UK wide

Microsoft Excel 2007 VBA

Microsoft Excel 2007 VBA 2 day instructor-led. Courses never cancelled: Guaranteed. From £275 (list price £545)

Training formats available

Who is this training course suitable for?

This course is suitable for advanced users of Microsoft Excel. If they are responsible for very large and variable amounts of data, or teams, who need to learn how to program features and functions to develop the accessibility and usability of their data.

Prerequisites

A thorough knowledge of Microsoft Excel is required, or completion of our Microsoft Excel Advanced course.

Benefits

By the end of the course the delegate will be competent in the fundamentals of VBA, including working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions. This includes mastering how to control program execution, working with forms and controls, working with the PivotTable object. In order to ensure minimal downtime while building and rolling out the program, the course also includes modules on debugging code and handling errors.

Course Syllabus

Introduction
Introducing Visual Basic for Applications
Recording and running macros
Editing macros in the Visual Basic editor
Defining the development environment
Using help
Closing the VB editor

Developing with Procedures and Functions
Understanding and creating modules
Defining procedures
Creating a sub-procedure
Calling procedures
Utilising the immediate window to call procedures
Making and naming a function procedure
Working using the code editor

Introducing Objects
Defining objects
Examining the Excel object hierarchy
Defining collections
Utilising the object browser
How to work with properties
The with statement
How to work with methods
Building an event procedure

Utilising Intrinsic Functions, Variables and Expressions
Defining expressions and statements
How to declare variables
Determining data types
Programming with variable scope
Harnessing intrinsic functions
Defining constants and using intrinsic constants
Adding message boxes and using input boxes
How to declare and use object variables

Managing Program Execution
Defining control-of-flow structures
Using boolean expressions
Working with the if...end if decision structures
Working with the select case...end select structure
Working with the do...loop structure
Working with the for...next structure
Working with the for each...next structure
Restrictions for use of control-of-flow structures

Harnessing Forms and Controls
Defining UserForms
Utilising the toolbox
Using UserForm properties, events and methods
Understanding controls
Setting control properties in the properties window
Using the label control
Using the text box control
Using the command button control
Using the combo box control
Using the frame control
Using option button controls
Using control appearance
Determining the tab order
Filling a control
Increasing code to controls
How to launch a form in code

Using the PivotTable Object
Defining PivotTables
Making a PivotTable
Using the PivotTable wizard method
Using PivotFields
Adding a procedure to a custom toolbar

Debugging The Code
Defining errors
Working with debugging tools
Determining breakpoints
How to step through code
Working with break mode during run mode
Identifying the value of expressions

Handling Errors
Defining error handling
Defining VBA's error trapping options
Capturing errors with the on error statement
Determining the error object
Coding an error handling routine
Using inline error handling

Public Schedule - Pricing and Availability

Excel VBA 2007 2 day course
Version Date Location Places
available
Book Next place rate:
Card Invoice
2007 2008 Dec 11 Thu + 12 Fri Bayswater 3 book now £525 £545
2007 2009 Jan 8 Thu + 9 Fri Bloomsbury 7 book now £450 £475
2007 2009 Feb 5 Thu + 6 Fri Bloomsbury 7 book now £450 £475
2007 2009 Apr 16 Thu + 17 Fri Bloomsbury 8 book now £275 £399
2007 2009 May 14 Thu + 15 Fri Bloomsbury 8 book now £275 £399
2007 2009 Jun 11 Thu + 12 Fri Bloomsbury 8 book now £275 £399
2007 2009 Jul 16 Thu + 17 Fri Bloomsbury 8 book now £275 £399
2007 2009 Aug 13 Thu + 14 Fri Bloomsbury 8 book now £275 £399
2007 2009 Sep 17 Thu + 18 Fri Bloomsbury 8 book now £275 £399
2007 2009 Oct 15 Thu + 16 Fri Bloomsbury 6 book now £345 £425
2007 2009 Nov 12 Thu + 13 Fri Bloomsbury 8 book now £275 £399

"What do I get on the day?"

  • Microsoft qualified trainers with industry relevant experience
  • Modern air conditioned training suite, flat screen PC's, 1 per delegate
  • Lunch provided in a comfortable and relaxed setting
  • Comprehensive course material and files to take away
  • What do I get on the day? - More information

What is Microsoft Excel?

Microsoft Excel is a popular computer program that allows you to create and edit spreadsheets. These are used to store information in columns and rows that can then be organised and/or processed. Spreadsheets are designed to work well with numbers but often include text.

Rate this page:
2.0/5 (1 vote cast)
Institute of IT Training - Accredited Training Provider Microsoft Certified Partner
microsoft office
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application Main information pages See also

Access courses
DreamWeaver courses
Excel courses
MS Project courses
Outlook courses
PowerPoint courses
VBA courses
Word courses
(more...)

Public scheduled courses
On-site training
Closed company courses

Microsoft Office training
Pricing and availability
Training schedule
Training venues

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London

Microsoft Access training
Microsoft Excel training
Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training

Time Management Course London

Interested in Access training? Please see the following pages:
microsoft access courses · microsoft training access course
microsoft+access+training · access courses in london

Training Information

Training Articles

AddThis Social Bookmark Button What's this?
Add to Del.icio.us Add to Facebook Add to Digg Add to Reddit Add to Google Add to Yahoo Add to Diigo Add to Mr. Wong Add to Linkarena Add to Power Oldie Add to Folkd Add to Jumptags Add to Upchuckr Add to Simpy Add to StumbleUpon Add to Slashdot Add to Netscape Add to Furl Add to Spurl Add to Blinklist Add to Blogmarks Add to Technorati Add to Newsvine Add to Blinkbits Add to Ma.Gnolia Add to Smarking Add to Netvouz