Excel - Advanced

 

Purpose

To give participants the skills to unlock Excel’s full potential by using some of its advanced features.

Learning Outcomes

  • Name cells and ranges
  • Use data validation to control the type of data entered into cells
  • Create conditional dropdown lists
  • Use functions such as Countifs, Sumifs, Averageifs, Hlookup, Vlookup, Networkdays, Nested Ifs
  • Share workbooks and collaborate with others
  • Create Pivot tables and Pivot charts
  • Introduction to recording macros
  • Format and modify charts
  • Customise ribbons

Audience

Suitable for those who have already attended our Intermediate Excel course, or those who already have a sound working knowledge of MS Excel.

Method

2 Days virtual delivery

Due to current guidelines regarding social distancing, we have taken the decision to run our IT course portfolio virtually until further notice.

 

If you have any questions concerning this, please do not hesitate to contact our Digital Consultancy team via digitallearning@leadership.hscni.net

Cost

£270.00
(Prices do not include VAT)

Please select an appropriate time and venue and click the apply button to register for this course.

Label Dates & Times Venue Facilitator Administrator
Excel Advanced Thursday, 19 August, 2021 & 26th August
(19th and 26th Aug)
HSC Leadership Centre Leadership Centre
Lauren Camlin
Excel Advanced Thursday, 14 October, 2021 & 21st October
(09:30-17:00)
HSC Leadership Centre Leadership Centre
Lauren Camlin
Excel Advanced Thursday, 9 December, 2021 & 16th December
(09:30-17:00)
HSC Leadership Centre Leadership Centre
Lauren Camlin