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
|