>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, the manufacturers' organisation - Broadway House - Tothill Street - London SW1H 9NQ
t: 020 7222 7777 f: 020 7222 2782 e: enquiries@eef.org.uk VAT registration number: GB 941 8117 27

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