Data Analysis with Excel - Introduction

Date:
6 February 2019
Time:
9:30am-4:30pm
Location:
London, Edinburgh, Manchester, Glasgow, 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: £530 + VAT
Non-member price in England: £624 + VAT

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.


Edinburgh, 1 April 2019
Glasgow, 3 October 2019

Book with BPP


London, 6 February 2019
London, 8 April 2019
Manchester, 13 May 2019
London, 5 June 2019
London, 3 July 2019
London, 16 September 2019
Birmingham, 14 October 2019
London, 9 December 2019

Email to book



What you will learn

This one day course offers quick tips to improve functionality, spreadsheet formatting, 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 simple automation of tasks using macros.

Who should attend

People who should attend include users of Microsoft Excel who are new to data analysis, and those needing to obtain analytical skills for working around their day-to-day spreadsheets.

Also: support staff, spreadsheet authors and finance workers looking to improve Excel functionality and processing speed.

Full speaker list

Speakers

Our technology courses include excel training and financial modelling which covers practical scenarios that delegates are likely to encounter in the workplace. 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 a hands-on approach with:

  • Time savers
  • Keyboard hotkeys and shortcuts
  • Data filtering and searching
  • Functions
  • Logical
  • Conditional (IF)
  • Textual
  • Nesting
  • Using LOOKUP within large data sets
  • Formatting on cell condition
  • Analytical options
  • Working with SUBTOTAL
  • Goal seek
  • Pivot tables
  • Organising data for analysis
  • Quick breakdown and analysis of complex data
  • Automation using macros
  • Creating macros for repetitive tasks
  • Using the macro recorder

Location

London, Edinburgh, Manchester, Glasgow, Birmingham

Contacts

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

Topics

  • Business and Financial management
  • England and Wales
  • Scotland
  • Training courses
  • Edinburgh
  • Glasgow and West
  • London and Home Counties
  • Manchester and the North
  • Birmingham and the Midlands
  • Technology

Previous Page