Intermediate Excel

Date:
3 October 2019
Time:
9.30am-5.00pm
Location:
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

Content

  • 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

Location

Birmingham, London, Glasgow

Contacts

BPP
Tel: 0330 060 3303
Email: ldicas@bpp.com

Topics

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

Previous Page