Excel Intermediate 2000/XP/2003

Duration 1 day

Designed for
Users wishing to extend their knowledge of the features and functions available within this program

Pre-requisites
Delegates should have attended the introductory course or have gained similar knowledge and experience in the workplace

Course Aims
By the end of this course delegates will be able to build complex spreadsheets which link via formulae, together with being able to construct functions which incorporate logic into the statement. An element of automation is also examined so that repetitive sheets can be recreated with minimal effort. Delegates will also be shown the ‘database’ capabilities and be able to manipulate data to give various outputs.

Course contents

Customising tools
Freezing panes
Notes
Styles
Templates/Auto Templates
Multiple Worksheets -v- Multiple Workbooks
Group editing
3D Formulas
Linking Worksheets/Workbooks
IF and Nested IF Functions
Date/Time Functions
Data Tables
Lookup Functions
Outlining
Managing lists (Database)
Using Data Forms
Sorting Records
Autofilter
Advanced Filtering
Extracting Records
Database Functions
Subtotalling

Qualifications
for team leaders
and first line
managers

ILM Endorsement refers to bespoke programmes that have some form of assessment and are approved as ILM Endorsed Awards. Call or contact Adapt to discuss your specific requirements

Looking for a bespoke programme which has been approved by ILM but doesn’t have an assessment process? Choose Adapt to design a programme for an ILM Development Award

What they said about ...

ILM Level 3 Award in First Line Management

Jane is an excellent trainer and explained everything very clearly, excellent course with content well explained

The trainer answered all my questions superbly, very comprehensive on the detail of the course

Very knowledgeable and helpful and understanding and re explaining

Very good course which has taught me how to talk and deal with my team

Kept interesting and fresh throughout. Easy to stay attentive