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:

  • Time savers
  • Pivot tables and charts
    • Control a chart via a Pivot Table
    • Summarise data and automate the chart
  • The ‘LOOKUP’ Family
    • Flexible lookup techniques
    • Understanding the limitations of a VLOOKUP
    • Practical solutions for complex data sets
  • Functions
    • Logical
    • Conditional
    • Error
    • Textual
    • Nesting (for increased power)
    • Array
  • The CSE keystroke method
    • Simplifying IF functions
    • Multi-cell array functions
  • Analyse trends in business data via a Frequency Distribution Table
    • The calculative technique using ‘bins array’
    • The non-calculative technique via a Pivot Table
  • Extensive conditional formatting
    • Data Bars
    • Using formula based rules
  • Introduction to scenario building
  • Increased automation techniques using macros
    • Applying meaningful macro functionality
    • Viewing and simple editing of macro VBA code
    All exercises and project files used on the course will be available to take home.

    "A CPD certificate of completion will be provided by BPP Professional Education Limited upon request, following attendance."


    Course Dates

    Location Dates Time Availability  
    London 30 Sep 2020 9:30 AM - 4:30 PM  Spaces Book Now
    London 23 Oct 2020 9:30 AM - 4:30 PM  Spaces Book Now
    London 14 Nov 2020 9:30 AM - 4:30 PM  Spaces Book Now
    London 12 Dec 2020 9:30 AM - 4:30 PM  Spaces Book Now

Membership Scheme

You and your firm could be saving £000's on your CPD training. Find out how to join our membership scheme and receive immediate benefits.

Tailored training

We can tailor any of our public courses to meet your needs as well as providing completely bespoke training solutions. Learn more about tailored training.

Special Assistance Policy