Data Analysis with Excel - Introduction

BPP Professional Education
Course summary
6 hours
634 GBP excl. VAT
Birmingham, London, Online courses
Next available date: Online delivery option may be available - Please contact provider. - Online courses
Professional Training

Course description

Data Analysis with Excel - Introduction

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.

COVID-19 Update

This provider offers an online version of their classroom courses

Do you have questions about COVID-19 in relation to this course?

At findcourses.co.uk we are committed to helping everyone who wants to learn, to learn. So are our trusted partner providers.

Get in touch on this page to find out whether there are any changes to this course in light of COVID-19.

Suitability - Who should attend?

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.

Outcome / Qualification etc.

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 conciselyLearning 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. Laptops with Excel 2013 will be provided on the course. The knowledge and skills gained can be used across all modern versions of Excel.

Get Inspired! Watch the Video

About provider

BPP Professional Education

BPP Professional Education -  Accountancy, Tax, Financial Services, Law & Insolvency Courses

BPP Professional Education is one of the specialist examination-based and professional development training arm of the BPP Group, Europe's biggest professional education and publishing provider with 2,000 staff members across 40 countries and over 30,000 students per year. BPP Professional Education...

Read more and show all courses with this provider

Request info

Fill out your details to find out more about Data Analysis with Excel - Introduction.

  Contact the provider

  Get more information

  Register your interest

Contact info

BPP Professional Education

3 London Wall Buildings
EC2M 5PD London

 Show phone number

Request information

Find out more about this Data Analysis with Excel - Introduction course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here