Performance Through People (PTP) - Advanced Microsoft Excel

Advanced Excel

This course is ideal for anyone who wants to learn the more advanced uses of Excel and has some basic knowledge of this application. This course will provide further tools to complete more difficult tasks and reduce time in their completion. It is recommended that the introduction course is completed if you find working with formulas difficult.

COURSE OBJECTIVES

This course aims to give delegates confidence when using the Microsoft Excel Programme in easy to follow steps. Following the completion of this course delegates will be able to efficiently use the Microsoft Excel programme for a variety of tasks.

COURSE OUTLINE

This session will include;

Key elements from introductory excel course
Cell naming
Database functions
Sorting spreadsheets and subtotals
Pivot tables (cross tab views)
Recording and editing Macros
Creating and using spreadsheet templates
Recording Macros and getting to know Visual Basic programming language
Creating validation lists

Course Duration

1 Day

Delivery Options

PTP Training Centre

Full day open course at one of our certified training centres.

£139 + VAT per person

On-Site Training

Full day in-company course at your organisations premises.