Data analysis with Excel – advanced
Member price: £539 + VAT
Non-member price: £634 + VAT
London, 7 February 2020
London, 22 April 2020
Manchester, 13 May 2020
London, 5 June 2020
London, 3 July 2020
London, 23 September 2020
Birmingham, 14 October 2020
London, 16 December 2020
What you will learn
Many of us struggle with the sheer amount of data that is available in this information age. In many cases, reports are built to present the data, but find that the end result still has a limiting structure and usability.
This one day course provides attendees with hands-on techniques with a focus on keeping things dynamic and expandable. Covering structured references, dynamic listing techniques, scenario modelling, and through the exercises we will get to use some of the more unexplored functions and areas in Excel.
Who should attend
The course material includes advanced features of Excel and participants will gain the maximum benefit from this course if they have already attended the Data analysis with Excel – intermediate course and / or are already competent spreadsheet users. This course is designed for users who use Excel on a regular basis, and are looking to further their knowledge in producing more robust spreadsheets.
At a minimum, it is assumed that participants will know how to:
- Use some of the functions explained on the Intermediate level of this course
- Navigate confidently in Excel
- Use absolute cell references (e.g =$A$1)
- Create and use nested functions, or at least have an understanding of the benefits of nesting functions together.