Data Analysis With Excel - Intermediate
Pricing
Cost for BPP PD Members: £415 + VAT + 6 CPD Hours
(£599 + VAT for non BPP PD Members) Click Here for details of our membership scheme.)
Harnessing the Power of Excel
Course level
Intermediate
Course Objective
Interpret, communicate and search for data from large quantities of information. Learn how to synthesise information into a logical framework for analysis and summarise it into a meaningful format.
Delegates
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.
Course Content
This one day course offers quick tips to better utilising the power of Excel. The course involves analysing large data sets, using a variety of reporting tools, array formulae and CSE keystrokes, nesting functions, data manipulation, as well as an intro into macro automation.
This course contains some more advanced functions and complex nesting techniques which are used to control tables and charts. There are segments where we clean up data and create robust formulas.
Learning outcomes include obtaining a greater understanding of: