Excel (1 day training course) - Intermediate (LHR), Heathrow Cargo Handling Building, Thursday, 21. February 2019

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 contact 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 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

 

Thursday, 21. February 2019, Heathrow Cargo Handling Building, Excel (1 day training course) - Intermediate (LHR)

Find more interesting events
Get event recommendations based on your Facebook taste. Get it now!Show me the suitable events for meNot now