|
| |
 |
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.
|
|
Upgrade
with the Microsoft Excel 2007 Advanced Course |
|
|
Microsoft Excel 2007
Advanced Course Overview |
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.
To view the Office 2007 shared features
topics click
here.
To view Excel 2007 upgrade topics click
here.
For pricing click
here
To return to the application overview
page click
here
Excel 2007 Training in Sussex,
Surrey, Hampshire
and London |
|
| |
| What is a Macro? |
- Command macros
- Function macros
- Recorded macros
- Written macros
|
|
|
| Good Practice |
- Good practice
- 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
|
|
|
|
|
| |
|
|
