|
| |
 |
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.
|
|
Excel
Intermediate Training |
|
|
| Microsoft
Office Training > Excel
Training > Excel Intermediate
Training |
Excel Intermediate
Training Overview (Excel 2010, 2007,
2003, XP and earlier) |
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.
Upgrade
with Excel 2007 Intermediate
Training
For pricing click
here
To return to the Excel overview
page click
here
Excel 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
|
|
|
|
|
| |
|
|
