 |
MS Access Training |
|
| |
MS Excel Training |
|
 |
MS Word Training |
|
|
MS PowerPoint Training |
|
|
MS Project Training |
|
|
MS Visio Training |
|
|
MS Outlook Training |
|
|
|
| |
|
|
|
 |
 |
 Microsoft Excel Macros and VBA Training Course in London and the UK
If you are an experienced Microsoft Excel user, this course will help you reach the next level in Excel usage. You will be able to write macros to automate all repetitive tasks, or simplify complex formulae or tasks.
Microsoft Training Courses (MTC) provides Excel Macro's or VBA training on all versions of Excel, incuding version 2007.
|
|
| Excel VBA Training Course Information |
| The duration of this course is 2 Days. Training usually starts at 09:30 and lasts until 16:30 - 17:00. You will receive a Training Manual CD, course exercises and after course support all included in the cost. We offer fantastic refreshment throughout the day, like hot drinks, snacks and a selection of bottled water and soft drinks. |
|
| Select the Contact Me Now!!! button below to have a member of our team contact you regarding this course, or contact us |
|
| |
|
| |
| |
MS Excel VBA Training Course Contents |
| |
| 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
|
Recorded Macros |
- Record New Macro
- Assigning a keyboard short cut
- Saving with the file
|
| |
Methods of Executing |
- Menu
- Visual Basic Toolbar
- Keyboard Shortcut
- Custom Toolbar Button
- Custom Menu Item
- Button
- Alt [F8]
- Forms Toolbar
|
| |
Editing the Code |
- Using the Visual Basic Editor
- Structure of a sub routine
- Describe the colour scheme of Key Words
- Navigation in a Module
- Editing in a module
- Use of Function Keys
- Reassign keyboard shortcut
- Run subroutines together
|
| |
Checking For Errors |
- Debugging
- Step Mode
- Immediate Window
- Object Browser
- Toggle Breakpoint
- Help system
|
| |
Types of Recording |
|
| |
Portability |
- Personal Macro Workbook
- This Work Book
- New Workbook
- Addins
|
| |
Creating New Functions |
- Uses
- Function Keyword
- Use of Arguments
- Variables
- Constants
|
|
 |
| Control Structures |
- IF
- Nested IF
- AND OR NOT
- SELECT CASE
- Inbuilt Functions
- Distribution
- Watch Pane
- Step through Functions using the immediate Window
|
| |
| VBA Language Rules |
- Theory of Object
- Properties and Methods
- Active Objects
- Object Model Hierarchy
- Inheritance
|
| |
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
|
|
|
|
| |
| |
| |
|
|
|
|
|
 |
Course Costs |
| 1 to 1 Training |
1 to 1 training is charged at £450 per day.This means you will have the best training possible and only focus on topics you will use and actually benifit from. Read more about the benifits of 1 to 1 training here
All our courses are closed to you. |
| |
| Groups of 2-8 |
If you need to have more than 1 person trained, then our group pricing cannot be beaten.
For 2 Delegates = £475 per day. That's less than £200 per day per delegate
For 3 Delegates = £495 per day. Thats less than £170 per day per delegate
For 4 Delegates = £695 per day. Thats less than £150 per day per delegate
For 5 to 8 delegates = £695 per day. That could be as little as £90 per day per delegate.
All prices are excluding VAT |
| |
All our courses are closed to you and your company. |
|
How to book |
Simply call us on 020 7920 9500
or
Email Us
or
use our Contact Us form
We will then confirm the course and dates with you and send joining instructions
Thats it.
Remember that you do not pay until your course has run. This ensures that you are 100% satisfied with your course. If not, we run it free or you simply do not pay.
|
 |
|
|
|
