|
| |
 |
On
Site Training |
|
- Training from £300 a day!
-
All
versions of MS Office covered 2010, 2007, 2003,
XP, 2000, 97
- MS
Office 2010 Upgrade Course
- MS Office 2007 Upgrade Course
- Excel
2010, 2007, 2003 Training
- Access
2010, 2007, 2003 Training
- Project
2007, 2003 Training
- Publisher 2010, 07, 03 Training
- Word 2010, 2007, 2003 Training
- PowerPoint
2010, 07, 03 Training
- Visio
2010, 2007, 2003 Training
- Outlook
2010, 2007, 2003 Training
- Dreamweaver
Training
- Adobe InDesign Training
- Introduction to SEO
- Event Photographer Sussex
|
| Free
Training Materials |
|
|
 |
|
|
Web
design |
|
| |
| If you like this site, let us
create a web site for you.
Contact us for a quote. |
| |
| |
| |
|
|
|
|
Corporate
portraits |
|
|
|
|
Microsoft
Office Training throughout West Sussex & East Sussex, Surrey and Hampshire: Horsham, Brighton, Burgess Hill, Chichester, Crawley, Eastbourne, East Grinstead, Haywards Heath,, Lewes, Littlehampton, Dorking, Farnham, Godalming, Guildford,Redhill, Reigate, Weybridge Woking, Havant, Petersfield, Portsmouth, Southampton, Winchester, Tonbridge & Tunbridge Wells.
|
|
Microsoft
Excel Advanced Training |
|
|
| Microsoft
Office Training > Excel
Training > Excel Advanced Training
Training |
Microsoft Excel Advanced
Training Overview (Excel 2010, 2007, 2003, XP
and earlier) |
This 1 day
Microsoft Excel advanced course is designed
for those that need to automate aspects
of Excel's functionality with the use
of Macros. Computer programming skills
will be acquired during this course so
a very good level of computer literacy
is needed together with a good grasp of
the Excel themes covered in the Beginners'
and Interemdiate Excel courses.
The outline is only a suggestion and
can be tailored to your business needs.
To accompany the instructor lead training,
each delegate will receive manuals and
practise, step-by-step exercises. This
will provide an excellent source of information
and on-going self study once the training
has been completed.
Upgrade
with the Excel 2007 Advanced Training
Course
For pricing click
here
To return to the application overview
page click
here
Excel Training in Sussex,
Surrey, Hampshire
and London |
|
| |
| What is a Macro? |
- Command macros
- Function macros
- Recorded macros
- Written macros
|
|
|
| Good Practise |
- Good practise
- Naming a macro
- Macro security
- Macro storage
- Editing a recorded macro
using VBA
- Relative vs absolute recording
mode
|
|
|
| Running
a Macro |
- Shortcut keys
- Macro button
- Custom Toolbar
- Custom Menu
- Automatically on workbook
opening/closing
|
|
|
| Introduction
to VBA |
- Navigating the VB editor
- Creating procedures
- Copying code between macros
- Calling macros in a separate
procedure
- User defined functions
- Userforms
- Message boxes
- Input Boxes
- IF structures
- Select Case structures
|
|
|
|
|
| |
|
|
