Search

07 March 2019

Intermediate Excel

Category: MASTER COURSE

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

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.

Please Note: There is some overlap between this course and the Financial modelling series and the Data analysis with Excel series and delegates should carefully read the outlines to determine which course would be most suitable for them.

What you will gain
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.

Programme outline

  • 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 and SumIf
  • Excel Name functionality
  • Date functionality
  • Practical exercise

The course starts at 9.30am. Lunch and refreshments are included.
6 CPD hours (where applicable).

CIMA work in partnership with BPP Professional Education to offer CPD training courses

Booking Information

Date Location Price
7 March 2019 - 09:30 Manchester Price: GBP 522.00
Member price: £470. Plus VAT on all prices.
2 May 2019 - 09:30 London Price: GBP 522.00
Member price: £470. Plus VAT on all prices.
2 July 2019 - 09:30 London Price: GBP 522.00
Member price: £470. Plus VAT on all prices.
3 October 2019 - 09:00 Birmingham Price: GBP 522.00
Member price: £470. Plus VAT on all prices.
29 October 2019 - 09:30 London Price: GBP 522.00
Member price: £470. Plus VAT on all prices.


Related Events

06/03/2019 09:30:00

Introduction to Excel

MASTER COURSE

  • Cost:
    GBP 522.00
    Member price: £470. Plus VAT on all prices.
  • Location:
    Manchester
  • Speaker(s):

This one day course has been developed for those who are new to Microsoft Excel and need an introduction to the basic functionality.

Find out more

Intermediate Excel

CIMA members and students should log in to MY CIMA before booking to receive the appropriate discount.

Book Now

In-house training 
We can develop tailored training programmes to enhance the finance and business skills of staff across your organisation. To discuss how we can meet your learning and development needs please email us.

Find out more 
If you have any queries please email cima@bpp.com or phone us on: +44 (0)3300 603400.

The venue for this course will be confirmed 14 days before the scheduled date. 

CIMA work in partnership with BPP Professional Education to offer CPD training courses.  

This course will be delivered by BPP Professional Education Limited (“BPP”).  Accordingly, when you sign up for this course, CIMA will pass on the contact details you have provided to BPP so that they can contact you to complete your booking and process payment.  BPP will process any personal information it collects about you in accordance with its privacy policy, which is available at: http://www.bpp.com/professional-education/privacy

The information provided to BPP will not be used by BPP for marketing purposes.

CIMA on demand is our range of online CPD training courses specifically designed for busy finance and business professionals who need training that's convenient and will fit around their schedule. Find out more at www.cimaondemand.com