>Information Technology
 



log in

Microsoft Excel Advanced

An advanced one-day course offering guidance and building a wealth of specialist skills.

Who Should Attend?

Suitable for advanced users who need to use the Query add-in and advanced features provided with Excel, such as pivot tables and solver, simple keyboard macros and customising Excel.

Benefits of Attending

On completion delegates will be able to manipulate data, create tables and work sheets, convert work sheets to presentation charts.

Course Overview

· Multiple sheets and 3-dimensional formula

· File linking

· Activating the query add-in and using external data

· Creating templates and workspaces

· "What if" analysis, goal seek and solver

· Creating pivot tables and scenarios

· Recording macros and assigning quick keys

· Customising Excel
Aimed At
Administrators / PAs
All employees
HR Professionals - All
HR Professionals - Experienced
Managers - Senior or Director
Receptionists / Telephonists
Trainers

Duration
1 day
Venues and Dates
To Be Confirmed

Member Price
£175.00 (+ VAT)
further information:

Diane Bilton

tel: 0121 707 1414

Contact us:

EEF Technology Centre - Reddings Lane - Tyseley - Birmingham B11 3ET t: 0121 707 1414 f 0121 7067859 VAT registration number applied for

EEF Limited is the organisation for manufacturing, engineering and technology-based businesses. It is an employers association regulated under Part II of the Trade Union and Labour Relations (Consolidation) Act 1992 and a company limited by guarantee. EEF Limited is registered in England and Wales, registered no 05950172, and its registered office is Broadway House, Tothill Street, London, SW1H 9NQ

privacy policy