21st Jan'19

Microsoft Excel Essentials: Level 2 – Intermediate

09:15 - 16:30 (approx)
UNW Boardroom (Ground Floor), Citygate, St James’ Boulevard, Newcastle upon Tyne

Delivered by UNW’s Data Analyst Laura Hudson in an open and engaging format, this one-day course aims to enable attendees to perform complex calculations on datasets as well as effectively use advanced functions within Excel to analyse data. Delegates will also discover how to produce pivot tables to manipulate, extract and present data.

What will be covered?
• Performing calculations (overview of Excel level 1 training course)
• Cell referencing – absolute and mixed
• Tables
• Named ranges
• Security
• Data validation
• IF functions
• Lookup functions
• Pivot tables

Who is this training course for?

This course is a designed for those who are reasonably competent in using worksheets to enter data and do basic formatting work, but now want to enhance their understanding of using Excel to analyse data.

For more information regarding this event, or to reserve a place, please contact Maxine Johnston via maxinejohnston@unw.co.uk or on 0191 243 6259.

*The fee for this event is charged at £250.00 +VAT, all materials will be provided along with lunch and refreshments throughout the day. Please note that attendees need to bring their own laptops to this session.