| |
| Onsite Microsoft Excel 2010 Training - we come to you! |
Microsoft Office Training > Office 2010 Training > Excel 2010 Training Intermediate
 |
Excel 2010 Intermediate Course
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.
The outline is only a suggestion and
can be tailored to your business needs.
To accompany the instructor lead training,
each delegate will receive class notes that
will provide an excellent source of information
and on-going self study once the training
has been completed. For pricing click
here
We can offer onsite training to businesses across the South East from Southampton to Southend-on-Sea! |
|
|
|
| Course Outline |
| Formulae |
- Conditional Functions
- IF
- Nested IF
- SUMIF
- SUMIF
- 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.
|
|
|
|
|
