Intermediate Excel

3 October 2019
Birmingham, London, Glasgow

Member price in Scotland: £238 + VAT
Non-member price in Scotland: £280 + VAT

Please note, the ICAS member discount will be applied after checkout.

Member price in England: £444 + VAT
Non-member price in England: £522+ VAT

Please note, due to differences regarding external costs, courses outside of Scotland are priced separately. ICAS members are eligible for a discounted price on all courses running in England & Wales.

Glasgow, 20 November 2019

Book with BPP

Birmingham, 3 October 2019
London, 29 October 2019

Email to book

Who should attend

This one day classroom course has been designed as a follow on from the Introduction to Excel course for those who need to be able to take advantage of some of the more powerful and useful Excel functionality that is available.

What you will learn

Some more advanced Excel functionality is covered with a mix of hands on practical exercises (laptops are provided). In addition to a set of printed notes delegates will be able to take their Excel files away with them.

View full event details


  • Moving away from the mouse towards keyboard shortcuts
  • Ribbon access via ALT
  • More complex formulae
  • Absolute cell referencing: Row or Column only
  • Formatting using Styles
  • Logical statements continued: Nesting/AND/OR
  • Additional functionality:
    • Match
    • Lookups
    • Index
    • Offset
    • SumIf
  • Excel Name functionality
  • Date functionality
  • Practical exercise


Birmingham, London, Glasgow


Tel: 0330 060 3303


  • Business and Financial management
  • England and Wales
  • Scotland
  • Training courses
  • Glasgow and West
  • London and Home Counties
  • Birmingham and the Midlands
  • Technology

Previous Page