| |
| Onsite Microsoft Excel 2007 Training - we come to you! |
Microsoft Office Training > Office 2007 Training > Excel 2007 Intermediate
 |
Excel 2007 Intermediate Training
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 course notes which
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 |
|
|
|
| Course Outline |
| Formulae |
- Conditional Functions
- IF
- Nested IF
- SUMIF
- SUMIFS
- COUNTIF
- COUNTIFS
- Lookup Functions
- Using Text Functions to clean and manipulate data
- TRIM
- TEXT
- RIGHT
- LEFT
- MID
- CONCATENATE
- VALUE
- TIME AND DATE Functions
- DATE
- NOW
- DAY
- MONTH
- YEAR
- NETWORKDAYS
- Conditional 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 Functions - DSUM,
DAVERAGE etc
- Custom views
|
|
|
|
|
| |
| Onsite Microsoft Office Training |
Microsoft
Office Computer Training Courses throughout Surrey, Sussex, Hampshire, Kent, Essex, Berkshire, Buckinghamshire, Dorset, Hertfordshire, Oxfordshire, Wiltshire and London including Crawley, Brighton, Portsmouth, Southampton, Winchester, Farnham, Guildford, Basingstoke, Salisbury, Bournemouth, Poole, Dorchester, Tunbridge Wells, Ashford, Canterbury, Maidstone, Gravesend, Croydon, Kingston-upon-Thames, Reading, Newbury, Oxford, Watford, Hemel Hempstead, Dartford, Stevenage, Milton Keynes, Basildon, Chelmsford, Southend on Sea and Colchester.
|
|
|
|
|
