On Site Training

Web design

If you like this site, let us create a web site for you.

Corporate portraits

Portraits for promotional material, web sites or just to decorate your office walls. See Kate's recent commissions.

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

Revision of formulae basics (see beginners course)

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