Microsoft Office Training verified by visa - mastercard securecode about microsoft training company london uk add this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrint this page
email this site URL to someome to a friend or colleagueEmail this site
Customer: Sign in
Delegate: Sign in
Trainer: Log in
Home Course details Training formats Pricing FAQ Clients Book online Online schedule (live) Forum Contact us
 
spacer New booking
Choose courses Enter your details
 
spacer Information
Pricing and availability Location/map/parking Forum Hints and Tips
 
spacer Enquiries
Contact us Training vacancies
 
spacer Training
Public schedule On-site training Closed company E-Learning
 
spacer Pricing
Public schedule On-site training Closed company E-Learning

Excel 2002 Visual Basic for Applications

VBA - Design an application; create interactive forms; create custom toolbars and menus; use Visual Basic code and procedures; add security features more detail

Excel 2002 Visual Basic for Applications

Course length: 2 days.

Prerequisites: Excel 2002 Advanced or equivalent knowledge.

This course is designed for students who are familiar with Excel as a user and wish to progress to programming.

  • Run macros and understand the basics of a Visual Basic Module.
  • Create relative and absolute recorded macros and assign macros to various objects.
  • Write procedures that execute one or more lines of code repetitively.
  • Write procedures that test conditions and then run only certain statements based on the results.
  • Create macros that interact with the user.
  • Store Excel macros so they are available in any workbook.
  • Analyze how code works and locate the source of errors.
  • Understand the basics of Visual Basic programming.
Institute of IT Training - Accredited Training Provider Institute of IT Training - Accredited Training Provider Prodigy Platinum Learning Partner Microsoft Office Specialist Authorised Testing Centre

Microsoft Registered Partner
microsoft office
ms office project server

Association of Computer Trainers

secure online payments - visa - mastercard