Data Analysis with Excel - Introduction

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.)

Excel Essentials

Course level

Introductory/Developmental

Delegates

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.

Course Content

This course is very hands-on and practical. Each participant will be encouraged to discuss ideas and problem-solve relating to spreadsheets and data sets, utilising the tools and techniques covered during the course.

This one day course offers quick tips in improving functionality, formatting techniques, data searching and calculations amongst large data sets within Excel. This involves an intro to data analysis but some more advanced techniques will be shown and explained. Also, reporting tools, data manipulation and searching, plus an insight into simple automation of tasks using macros.

By the end of the course, delegates will be able to:

  • Understand the principals of data analysis
  • Learn to synthesise and summarise information into a logical framework
  • Consider when to use a chart or a table
  • Know how to use visual effects to improve their reports & presentations
  • Explore how to summarise, present and communicate data clearly and concisely

    Learning outcomes include a hands-on approach with:

    • Time savers
    • Keyboard hotkeys and shortcuts
    • Data filtering and searching
    • Functions
      • Logical / Mathematical
      • Conditional
      • Text string (for cleaning data)
      • Nesting
    • Applying ‘VLOOKUP’ within large data sets
    • Applying meaningful Conditional Formatting
    • Analytical options
      • Calculating SUBTOTAL on filtered records
      • Goal seeking
    • Organise business data via Pivot Tables
      • When to use a Pivot Table for analysing large amounts of data
      • Quick breakdown and analysis of complex data
    • Automation using macros
      • Creating macros for repetitive tasks
      • Best practice for macro preparation
      • Using the macro recorder
  • 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 29 Sep 2020 9:30 AM - 4:30 PM  Spaces Book Now
    London 13 Nov 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