Using excel techniques to analyse data - Intermediate

Date:
20 September 2018
Time:
9:30am-4:30pm
Location:
Aberdeen, Edinburgh, London, Birmingham

Member price in Scotland: £335.75 + VAT
Non-member price in Scotland: £395 + VAT

Please note, the ICAS member discount will be applied after checkout.

Member price in England: £509 + VAT
Non-member price in England: £599 + VAT

Please note, the title of this course in England is 'Data Analysis With Excel - Intermediate'. Due to differences regarding external costs, courses outside of Scotland are priced separately. ICAS members are eligible for a discounted price on all courses running in England & Wales.


London, 20 September 2018
Birmingham, 23 October 2018
London, 11 December 2018

Email to book


Edinburgh, 20 November 2018
Aberdeen, 22 November 2018

Book with BPP


What you will learn

This one day course offers quick tips to utilise the power of Excel.

This course involves; analysing large data sets, familiarity with a variety of reporting tools, array formulae and CSE keystrokes, nesting functions, data manipulation and text extraction, as well as scenario analysis and macro automation.

Who should attend

This course is aimed at those using Excel on a regular basis wishing to learn more about performing various forms of analysis. Also support staff, finance professionals and analysts wanting to increase their functional knowledge of Excel.

Full speaker list

Speakers

Our technology courses include excel training and financial modelling which covers practical scenarios which delegates are likely to encounter in the work place. The excel trainers are talented course designers and presenters with experience spanning over three decades. 

The Financial Modelling team specialise in training in corporate finance and modelling. In addition, they have completed a number of consulting assignments in the financial modelling field.

They have a wealth of experience training professionals, in both practice and industry, in all areas of financial modelling, accounting and financial analysis. Our technology teams have trained all over the world, including Amsterdam, Paris, Frankfurt, New York, Singapore, Sydney, Kampala and Abu Dhabi.

View full event details

Content

Learning outcomes include obtaining a greater understanding of:

  • Time savers
  • Pivot tables and charts
  • Frequency distribution tables
  • Functions
  • Logical
  • Conditional
  • Error
  • Textual
  • Nesting (for increased power)
  • Array
  • The CSE keystroke method
  • Simplifying IF functions
  • Multi-cell array functions
  • The LOOKUP family
  • Flexible lookup methods
  • VLOOKUP alternatives
  • Practical solutions for complex data sets
  • Scenario building
  • Extensive conditional formatting
  • Data bars
  • Using formula based rules
  • Increased automation techniques using macros
  • Applying meaningful macro functionality
  • Viewing and simple editing of macro VBA code

Location

Aberdeen, Edinburgh, London, Birmingham

Contacts

BPP
Tel: 0330 060 3303
Email: ldicas@bpp.com

Topics

  • Business and Financial management
  • England and Wales
  • Scotland
  • Training courses
  • Edinburgh
  • Grampian
  • London and Home Counties
  • Birmingham and the Midlands

Previous Page