Using excel techniques to analyse data - An introduction

15 November 2016

Member price: £301.75 + VAT

Non-member price: £355 + VAT

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

Edinburgh, 15 November 2016

Book with BPP

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.

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


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 experienced course designers and presenters. They have vast experience presenting and developing course materials now spanning over 3 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


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




Tel: 0330 060 3303


  • Training courses
  • Technology
  • Scotland
  • Edinburgh

Previous Page