Data analysis - with Excel

Event type: Mastercourse

The advanced features and functions

Date Location Price  
25 June 2012 - 09:30 London Price: GBP 599.00
Members: £539.00
Corporate discount scheme: £415.00
+ VAT on all prices
22 August 2012 - 09:30 Birmingham Price: GBP 599.00
Members: £539.00
Corporate discount scheme: £415.00
+ VAT on all prices
13 September 2012 - 09:30 London Price: GBP 599.00
Members: £539.00
Corporate discount scheme: £415.00
+ VAT on all prices
29 October 2012 - 09:30 London Price: GBP 599.00
Members: £539.00
Corporate discount scheme: £415.00
+ VAT on all prices
6 November 2012 - 09:30 Glasgow Price: GBP 599.00
Members: £539.00
Corporate discount scheme: £415.00
+ VAT on all prices
28 November 2012 - 09:30 London Price: GBP 599.00
Members: £539.00
Corporate discount scheme: £415.00
+ VAT on all prices
18 December 2012 - 09:30 London Price: GBP 599.00
Members: £539.00
Corporate discount scheme: £415.00
+ 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.
  • Improved analysis, reporting, data manipulation and searching skills.
  • Enhanced expertise in scenario analysis and simple automation.

Speaker Details

The speaker will be drawn from a pool of qualified professionals who specialise in this subject. Having worked for leading organisations they will relate the course content to real life case studies.

Outline

  • Time savers.
  • Pivot tables.
  • Data filtering.
  • Functions: logical; error; text; nesting (for increased power).
  • Scenario building
  • Conditional formatting.
  • Simple automation using macros.

The course will start at 9.30am, with registration and coffee from 9.00am, and end at 4.00pm.

5.5 CPD hours (where applicable).



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.