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

Cost

£212.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 23rd May 2019 and 30 May 2019
(9:30am-15:30pm )
HSC Leadership Centre Barbara Patton
Caroline Baird
Creena Miskimmin
Excel Advanced 3rd & 10th September 2019
(9:30am-15:30pm )
HSC Leadership Centre Barbara Patton
Caroline Baird
Creena Miskimmin
Excel Advanced 8th & 15th October 2019
(9:30am -15:30pm)
HSC Leadership Centre Barbara Patton
Caroline Baird
Creena Miskimmin
Excel Advanced 29th January & 5th February 2020
(9:30am -15:30pm)
HSC Leadership Centre Barbara Patton
Caroline Baird
Creena Miskimmin