Excel Advanced 2010

Duration 1 day

Designed for
Power users or those who typically would produce spreadsheets of a more complicated nature and who wish to further develop their skills

Pre-requisites
Delegates attending this course should have a good understanding of the basics and be able to confidently demonstrate them.

A pre-course questionnaire is available for delegates to confirm their existing knowledge before attending this programme

Course Aims
The aim of this course is to develop delegates’ usage of Excel to the highest level and enable them to utilise the Add-ins in order to produce sophisticated reports containing relevant information. The power and adaptability of macros will also be practiced in order for delegates to return to their own environments with an all round knowledge and understanding of the software

Course Content

Pivot Tables
Slicers
Goal Seek
Solver
Scenarios
Using Views and Creating Reports
Consolidating Data
Auditing Tools
Recording a Macro
Assigning Macros to Buttons
Viewing Code
Editing Code
Linking Data with Other Applications
Screenshots
User Defined Functions
On-Sheet Controls

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