Microsoft Excel Intermediate

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. Alternatively a more complete self study package can be purchased from our e-learning catalogue.

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



Guide Price: 450 per group of 8 delegates

Delivery: In house
Category: Intermediate Microsoft Excel »

Search for intermediate microsoft excel courses in