|
| |
 |
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 Intermediate Course (1
day) |
|
|
Excel 2007
Intermediate Course Overview |
This
Microsoft Excel course is designed
to offer training for those
that know the basics of
Microsoft Excel (see beginners'
course), but want to fill
in the gaps in their knowledge.
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 Excel overview
page click
here
Excel 2007 Training in Sussex,
Surrey,
Hampshire
and London |
|
|
| Formulae |
- Conditional Functions
- Nested IF
- IF OR
- IF AND
- SUMIF
- COUNTIF
- Lookup Functions
- VLOOKUP
- HLOOKUP
- MATCH
- INDEX
- Condtional formatting using
formulae
|
|
|
| Workbook
Consolidation |
- Using 3D formulae
- Using data consolidation
|
|
|
| Forms/Templates |
- Worksheet protection
- Workbook protection
- Data validation
- Form controls
- Creating a template
|
|
|
| Database
Work |
- Autofilters
- Advanced filter
- Pivot tables
- Subtotals
- SUBTOTAL function
- Database Functiions - DSUM,
DAVERAGE etc
- Custom views
|
|
|
|
|
| |
|
|
