Data analysis with Excel - intermediate

Event type: Mastercourse

Harness the power of Excel - discover how to:

  •  interpret, communicate and search for data from large quantities of information
  •  synthesise information into a logical framework for analysis
  •  summarise it in a meaningful format.

Booking information

CIMA members and students should log in to their MY CIMA account before placing their booking in order to receive the appropriate discounts.

Date Location Price  
24 February 2015 - 09:30 London Price: GBP 599.00
Member price: £539. CDS member price: £415. Plus VAT on all prices.
16 April 2015 - 09:30 London Price: GBP 599.00
Member price: £539. CDS member price: £415. Plus VAT on all prices.
12 May 2015 - 09:30 Manchester Price: GBP 599.00
Member price: £539. CDS member price: £415. Plus VAT on all prices.
12 June 2015 - 09:30 London Price: GBP 599.00
Member price: £539. CDS member price: £415. Plus VAT on all prices.
18 September 2015 - 09:30 London Price: GBP 599.00
Member price: £539. CDS member price: £415. Plus VAT on all prices.
20 October 2015 - 09:30 Birmingham Price: GBP 599.00
Member price: £539. CDS member price: £415. Plus VAT on all prices.
2 December 2015 - 09:30 London Price: GBP 599.00
Member price: £539. CDS member price: £415. Plus VAT on all prices.

Who will benefit

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

What you can gain

Quick tips to utilise the power of Excel more effectively, which will enhance your expertise in:

  •  analysing large data sets
  •  a variety of reporting tools, array formulae and CSE keystrokes, nesting functions, data manipulation
  •  the basics of macro automation
  •  .controlling tables and charts using more advanced functions and complex nesting techniques
  •   cleaning up data and creating robust formulae.

 

Outline

  •  Time savers.
  •  Pivot tables and charts: control a chart via a pivot table; summarise data and automate the chart.
  •  The LOOKUP family: flexible lookup techniques; understanding the limitations of a VLOOKUP; practical solutions for complex data sets.
  •  Functions: logical; conditional and error; text-string (for manipulation); nesting (for increased power); array.
  •  The CSE keystroke method: simplifying IF functions; multi-cell array functions.
  •  Analyse trends in business data via a frequency distribution table: the calculative technique using 'bins array'; the non-calculative technique via a pivot table.
  •  Extensive conditional formatting: data bars; using formula based rules.
  •  Introduction to scenario building.
  • Increased automation techniques using macros: 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.

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. 

General information

CIMA members and students should log in to their MY CIMA account in order to receive the appropriate discounts.

The course starts at 9.30am. Lunch and refreshments are included.

6 CPD hours (where applicable)

CIMA Mastercourses held in partnership with BPP 

Find out more
If you have any queries please email or phone us on +44 (0)845 026 4722.

CIMA on demand
CIMA on demand is a high quality online professional development solution, specifically designed for busy finance and business professionals. Find out more