MS Office Training Course Provider
 
Go to Mouse Training Home Page All Software,  Computer and IT Training Courses in London and the UK Personal Development and Management Training Courses Bespoke System Training Experts in London MS Office - Excel, Access, Word and PowerPoint Consultancy in London All Mouse Training Services About Mouse Training - The Best London Training Course Provider Contact the Experts - Mouse Training!

London Training Courses

Microsoft Courses

IT Training Courses

Mac Office Courses

IT Training Courses

Adobe Courses

IT Training Courses

More Courses

IT Training Courses

Google Docs Courses

IT Training Courses

Get Expert Tailored Training Solutions

 
MS Office Training Provider

MS Excel Training LondonMicrosoft Excel 2002 VBA Training Course in London and the UK

Our Excel VBA course help you create automated spreadheets for all those repetitive tasks. VBA can also help to simply complex tasks that needs to be performed on a reqular basis. At the end of the course, users will be able to record and ruin macros, edit the VBA code, build in loopings structures and create custom forms. We also cover error handling and event procedures.


If this sounds like the training course you require, then please contact us on 020 7920 9500 or click the Contact Me Now button below. A member of our team will get back to you asap.

 
 

MS Excel 2002 VBA Training Course

 

MS Excel Macros and VBA (Visual Basic) Training Course

Duration - This is a 2 day course starting at 09:30 until 16:30 each day
Course Objectives - To develop automated procedures in Excel using the Visual Basic for Applications language .

What is a Macro?

 

Concept and discussion

 

The Visual Basic Interface

  • The Project Window
  • Code Window
  • Properties Window
  • Navigating between Excel and the VB Editor
 

Types of Recording

  • Relative
  • Absolute
 

Recorded Macros

  • Record New Macro
  • Assigning a keyboard short cut
  • Macro Locations
 

Methods of Executing

  • Menu
  • Visual Basic Toolbar
  • Keyboard Shortcut
  • Custom Toolbar Button
  • Custom Menu Item
  • Forms Toolbar
 

Editing the Code

  • Using the Visual Basic Editor
  • Structure of a sub routine
  • Key Words
  • Navigation in a Module
  • Editing in a module
  • Use of Function Keys
  • Run subroutines together
 

Checking For Errors

  • Debugging
  • Step Mode
  • Immediate Window
  • Object Browser
  • Toggle Breakpoint
  • Using Help
 

Portability

  • Personal Macro Workbook
  • This Work Book
  • New Workbook
  • Addins
 

Creating New Functions

  • Uses
  • Function Keyword
  • Use of Arguments
  • Variables
  • Constants
 
VBA Language Rules
  • Theory of Object
  • Properties and Methods
  • Active Objects
  • Object Model Hierarchy
  • Inheritance
 
Excel VBA Macros Training Course
Control Structures
  • IF
  • Nested IF
  • AND OR NOT
  • SELECT CASE
  • Inbuilt Functions
  • Distribution
  • Watch Pane
  • Step through Functions using the immediate Window
 
 

Spreadsheet Form Controls

  • Combo box
  • Spinner control
  • Scroll bar
  • Option button
  • Check Box control
 

Interactive Macros

  • Msgbox
  • Conditional Message Box
  • Inputbox
 

Creating Interactive Forms

  • Form Controls
  • User forms
  • Using the Properties Window
  • Combo box
  • Radio Buttons
  • Group box
  • Check box
  • Built in Dialog Boxes
  • Creating Custom Menus
  • Creating Custom Toolbars
 
Event Procedures
  • What are Event Procedures?
  • On Open
  • Before Close
  • On Activate
  • On Deactivate
  • On Key
  • On Time
 
Security
  • Protecting/locking code for view/edit
  • Digital Signatures
 

Customizing the VB Editor

  • Dockable Windows
  • Format Editor
 

All Micorosoft Excel Training Courses and Levels

 
Excel 2007 Introduction
Excel 2007 Intermediate
Excel 2007 Advanced
Excel 2007 VBA
 
Excel 2003 Introduction
Excel 2003 Intermediate
Excel 2003 Advanced
Excel 2003 VBA
 
Excel 2002 Introduction
Excel 2002 Intermediate
Excel 2002 Advanced
Excel 2002 VBA
 
Excel 2000 Introduction
Excel 2000 Intermediate
Excel 2000 Advanced
Excel 2000 VBA
 
Excel 97 Introduction
Excel 97 Intermediate
Excel 97 Advanced
Excel 97 VBA
 
How to book your course

How to book

  • Contact us via email or call us on 020 7920 9500
  • We agree a date and course outline with you
  • Confirmation takes place by email or phone
  • That's it!

Contact Us for Training course advice and tailoring

Training Course Costs On-Site

Training Course Info

You can also download our MS Office Training Manuals for Microsoft Office 2000, 2002(XP) and 2003

Training Course Costs On-Site

Course Costs

1-to-1 training courses are charged at £450 per day. (Our offices or your venue)

All IT training courses at our offices are charged at a daily rate of £695 per day, for 2 to 8 delegates.

We also offer training at your venue for £595 per day. If required, laptops are available at an additional £150 per day.

For courses outside the M25, trainer travel and accomodation expenses are not included in the above prices but are charged at cost.
Get an Instant Quote for your training course

On-site Training Course Quote

Build your course

With our course builder form, you can choose your own topics and build a course that suits your needs and your time scale. Select a application below to go to the Course Builder page

Custom Course Builder

Tailored Access  Training Courses Access
Tailored Excel Training Courses Excel
Tailored PowerPoint  Custom Training Courses PowerPoint
Tailored Word Custom Training Courses Word
Tailored Project Custom Training Course Project
Outlook Custom Training Course Outlook
Visio Custom Training Course Visio
Publisher Custom Training Course Publisher
Home | Software Training | Soft skills Training | Bespoke Training | Consultancy | Services | About Us | Contact Us | Privacy Statement | Links | Sitemap © 2007 MTC All rights reserved