Search

11 December 2019

Data analysis with Excel - advanced

Category: MASTER COURSE

Discover how to use the more advanced functions of Excel - including structured references, dynamic listing techniques, scenario modelling - to create dynamic and expandable spread sheets.

Who should attend?
Designed for those who use Excel on a regular basis and want to further their knowledge of how to produce more robust spreadsheets, the course covers the more advanced features of Excel.

What you will gain
Many of us struggle with the vast amount of data currently available, finding that the structure of the reports we build to present this data limits their use. This course will provide hands-on techniques to help you create spreadsheets which are dynamic and expandable, enabling you to benefit from using functions including structured references, dynamic listing techniques and scenario modelling.

All exercises and project files used on this course will be available to take home.

Programme outline
Advanced listing techniques
- Tricks in creating dependent lists
- Dynamic selection tips
- Dynamic extraction of unique values

Facilitating calculations
- Dynamic and expandable named ranges
- Multi-nested functions / expandable referencing
- Structured table references / table nomenclature
- Aggregate calculation using the ‘wildcard’ technique 

Key functions
- DSUM / SUMPRODUCT / SUMIFS (and building conditions)
- Advanced uses of: OFFSET / CHOOSE / INDEX / MATCH
- ROWS
- INDIRECT 

Further advanced techniques for summarising and presenting data
- Mini pivot table reports
- Fast calculations with data tables
- Data modelling with scenario manager
- Histogram and Pareto Charts 

Excel dashboards (extracts)
- Creative charting techniques
- Building a visual analysis
- Tips and tricks in custom formatting 

Bonus VBA exercises
- Apply simple automation to speed up processes 

You will gain maximum benefit from this course is you are already a competent spreadsheet user or have attended Data analysis with Excel - intermediate. It is assumed you will know how to:

  • use the functions covered in Data analysis with Excel - intermediate
  • navigate confidently in Excel
  • use absolute cell references (eg=$A$1)
  • create and use nested functions, or at least understand the benefits of nesting functions together.

Laptops with Excel 2013 will be provided on the course. The knowledge and skills gained can be used across all modern versions of Excel.

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
11 December 2019 - 09:30 London Price: GBP 634.00
Member price: £571. Plus VAT on all prices.
7 February 2020 - 09:30 London Price: GBP 634.00
Member price: £571. Plus VAT on all prices.
22 April 2020 - 09:30 London Price: GBP 634.00
Member price: £571. Plus VAT on all prices.
13 May 2020 - 09:30 Manchester Price: GBP 634.00
Member price: £571. Plus VAT on all prices.
5 June 2020 - 09:30 London Price: GBP 634.00
Member price: £571. Plus VAT on all prices.
3 July 2020 - 09:30 London Price: GBP 634.00
Member price: £571. Plus VAT on all prices.
23 September 2020 - 09:30 London Price: GBP 634.00
Member price: £571. Plus VAT on all prices.
14 October 2020 - 09:30 Birmingham Price: GBP 634.00
Member price: £571. Plus VAT on all prices.
16 December 2020 - 09:30 London Price: GBP 634.00
Member price: £571. Plus VAT on all prices.


Related Events

09/12/2019 09:30:00

Data analysis with Excel - introduction

MASTER COURSE

  • Cost:
    GBP 634.00
    Member price: £571. Plus VAT on all prices.
  • Location:
    London
  • Speaker(s):

Excel essentials: quick tips to improve functionality, formatting techniques, data searching and calculations amongst large data sets within Excel. This course will provide an introduction to data analysis, reporting tools, data manipulation and searching, plus an insight into the simple automation of tasks using macros.

Find out more

10/12/2019 09:30:00

Data analysis with Excel - intermediate

MASTER COURSE

  • Cost:
    GBP 634.00
    Member price: £571. Plus VAT on all prices.
  • Location:
    London
  • Speaker(s):

Harness the power of Excel. Discover how to: interpret, present and search for data from large quantities of information, synthesise information into a logical framework for analysis and summarise it in a meaningful format.

Find out more

12/12/2019 09:30:00

Data driven dashboard reporting - with Excel

MASTER COURSE

  • Cost:
    GBP 634.00
    Member price: £571. Plus VAT on all prices.
  • Location:
    London
  • Speaker(s):

Find out how to create impactful Excel reports with this one day course. Dashboards enable you to make sense of raw numbers by presenting them in visually rich charts and tables, giving valuable insights into the key performance indicators of the business. Find out how.

Find out more

Data analysis with Excel - advanced

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 

Our catalogue of online CPD training courses designed to fit around your schedule.

Get any 5 courses for just £99 +VAT - limited time only.  

Find out more