Attendance for this one day course must be approved by your line manager as there is a charge of £90 per attendee which will be recharged to your cost centre.

Attendees should provide their own laptop for the day -preferably Office 365, if updated.Please contact HGB.Training@swissport.com with at least 2 weeks notice should you require a laptop to be provided for the duration of the course.

Attendees must also have completed the online assessment before registering for this course to ensure they meet the minimum standard required. If you have any queries regarding this please contact HGB.Training@swissport.com BEFORE registering.

This course is aimed at regular users of Excel who are familiar with the basics and who need to broaden their knowledge of Excel.

On completion of this course, attendees will be able to: create and apply formulas that include statistical, logical, lookup and date functions; apply formatting based on conditions; work across multiple sheets; write formulas to link sheets and workbooks; use a variety of tools to manage and extract data from lists; create a basic PivotTable to summarise data; create and modify charts.

Attendees should have attended our Excel Foundation course or have equivalent knowledge. Before attending this course, attendees must be confident with creating basic formulas (+ - / *), use of AUTOSUM, copying formulas and an awareness of $ within formulas.

The course will include the following topics:

Introduction to Named Ranges

Further Formulae and Functions

Work with Multiple Sheets and Workbooks

Work with Data Lists

Introduction to Conditional Formatting

Introduction to PivotTables

Charts

Work with Sparklines