 |
Corporate
portraits |
|
|
|
|
| Expertly
tailored Microsoft Office training courses: Brighton,
Worthing, Portsmouth, Chichester, Sussex, Surrey and London
|
 |
Excel
Intermediate Course |
|
 |
Excel Intermediate
Course Overview |
This
Microsoft Excel course is designed
to offer training for those
that have 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 practice,
step-by-step exercises. This
will provide an excellent source
of information and on-going
self study once the training
has been completed.
For pricing click
here
To return to the Excel overview
page click
here |
|
|
| 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
|
|
|
|
|
| |
|
|