Search

14 May 2019

Data analysis with Excel - intermediate

Category: MASTER COURSE

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.

Who should attend?

  • All who use Excel on a regular basis wishing to learn more about performing various kinds of analysis and exploring more complex functions and calculations.
  • Support staff, finance professionals and analysts wanting to increase their functional knowledge of Excel.

It is recommended that you attend this course before Data analysis with Excel - advanced, as it will familiarise you with many of the core functions and disciplines which are studied in more detail on the advanced course.

What you will gain

  • Apply more complex calculations to your spreadsheets.
  • Make quicker decisions to synthesise and summarise lots of information.
  • Work with pivot charts and tables.
  • Create bespoke formats and write formula-based rules.
  • Apply advanced text manipulation and other types of calculations to create error-free spreadsheets.
  • Perform various forms of analysis on business data.

These quick tips and tricks will help you to utilise the power of Excel more effectively, enhancing your expertise in:

  • analysing and extracting data quickly from data sets
  • a variety of reporting tools, array formulae and CSE keystrokes, nesting functions and data manipulation
  • the basics of macro automation
  • some of the more complex and advanced areas and functions within Excel, including complex nesting techniques, performing unconventional and flexible lookups, summarising and analysing trends, and controlling charts via pivot tables
  • writing formulae to develop bespoke conditional formats
  • dealing with spreadsheet errors and automating repetitive tasks.

Programme outline
Time savers / fast keys / shortcuts

Key functions

  • IF / MAX / IFERROR / ISERROR
  • INDEX / MATCH / OFFSET / LOOKUP / VLOOKUP
  • LEFT / RIGHT / MID / LEN
  • Introduction to ARRAY functions
  • Complex nesting techniques

Lookup in-depth

  • Flexible lookup techniques for unconventional datasets
  • Problems and limitations of a VLOOKUP
  • Practical solutions for complex datasets

Data manipulation

  • Advanced use of text-string functions
  • Text extraction with nesting

Additional forms of analysis

  • Control a chart via a Pivot Table
  • Summarise data and automate chart elements
  • Frequency distribution table

Bespoke and extensive conditional formatting

  • Create immediate visuals using Data Bars
  • Writing formulae to control range formatting

Introduction to scenario building

  • Experiment with goal seek
  • Introduction to solver analysis

Bonus macro and VBA exercises

  • Applying meaningful macro functionality
  • Viewing and simple editing of macro VBA code

All exercises and project files used on the course will be available to take home. 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

See also: Data analysis with Excel - introduction offers an introduction to the topic, while Data analysis with Excel - advanced and  Excel VBA for finance professionals will extend your knowledge. 

Booking Information

Date Location Price
14 May 2019 - 09:30 Manchester Price: GBP 624.00
Member price: £562. Plus VAT on all prices.
6 June 2019 - 09:30 London Price: GBP 624.00
Member price £562. Plus VAT on all prices.
4 July 2019 - 09:30 London Price: GBP 624.00
Member price: £562. Plus VAT on all prices.
17 September 2019 - 09:30 London Price: GBP 624.00
Member price: £562. Plus VAT on all prices.
15 October 2019 - 09:30 Birmingham Price: GBP 624.00
Member price: £562. Plus VAT on all prices.
10 December 2019 - 09:30 London Price: GBP 624.00
Member price £562. Plus VAT on all prices.


Related Events

13/05/2019 09:30:00

Data analysis with Excel - introduction

MASTER COURSE

  • Cost:
    GBP 624.00
    Member price £562. Plus VAT on all prices.
  • Location:
    Manchester
  • 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

15/05/2019 09:30:00

Data analysis with Excel - advanced

MASTER COURSE

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

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.

Find out more

20/05/2019 09:30:00

Data driven dashboard reporting - with Excel

MASTER COURSE

  • Cost:
    GBP 624.00
    Member price: £562. 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 - intermediate

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.

Find out more