| |
|
Microsoft Office Training Surrey: Addlestone, Ashford, Banstead, Bellfields, Camberley, Caterham, Chertsey, Cobham, Dorking, Earlswood, Egham, Englesfield Green, Epsom, Esther, Ewell, Farleigh, Farnham, Godalming, Guildford, Haslemere, Horley, Hurst Green, Hythe End, Leatherhead, Oxted, Redhill, Reigate, Shepperton, Staines, Sunbury-on-Thames, Walton-on-Thames, Weybridge and Woking.
|
 |
Excel Advanced Training Course in Surrey |
|
 |
| Excel
Training Surrey > Advanced Excel
Training Surrey |
Advanced Excel
Training Content (Excel 2010, 2007,
2003, XP and earlier) |
The Advanced Excel training course is aimed at delegates who have a good grasp of functionality within Excel and are looking to automate aspects of their work with the use of macros. Some computer programming is included in this course.
For pricing click
here
WE COME TO YOU!
We are happy to travel to you anywhere in Surrey without charging travel expenses including: Addlestone, Ashford, Banstead, Bellfields, Camberley, Caterham, Chertsey, Cobham, Dorking, Earlswood, Egham, Englesfield Green, Epsom, Esther, Ewell, Farleigh, Farnham, Godalming, Guildford, Haslemere, Horley, Hurst Green, Hythe End, Leatherhead, Oxted, Redhill, Reigate, Shepperton, Staines, Sunbury-on-Thames, Walton-on-Thames, Weybridge and Woking. |
| Introduction to Excel Macros |
-
Recorded vs written Macros
-
Creating command macros to automate procedures
-
Creating custom functions
|
|
|
| Recording a Macro |
- Good practise guidelines for macro creation
- Naming conventions
- Security options in Excel and the security implications of using Macros
- Where to store Macros
- Relative vs absolute recording
mode
- Making simple edits to a recorded macro
using VBA
|
|
|
| Running
an Excel Macro |
- Assigning shortcut keys to a macro
- Running a macro from a button on a worksheet
- Creating custom toolbars and toolbar buttons to run your macros
- Creating custom menus and menu items to run your macros
- Running a macros automatically on a workbook
opening/closing
|
|
|
| Introduction
to VBA |
- Find your way around the Visual Basic Editor
- Creating code for procedures
- Using and editing code generated by the macro recorder
- Copying code between macros to add functionality to a macro
- Joining together macros by calling them from separate
procedure
- Creating custom functions in VBA
- Using custom functions in a workbook
- Creating VBA userforms
- Making your macros interactive with Message Boxes and Input Boxes
- Creating conditional macros with IF structures
- Looping code
|
|
|
|
|
|
|
|
|
|
