3.9 Read 33 reviews
Overview
This Intermediate Data Analysis using MS Excel course at BPP University provides a practical introduction to a range of Excel tools that support more efficient data handling and analysis.
What you will learn
Learners will explore how Power Query can be used to bring in and reshape large datasets without altering the original source, before moving on to macro recording as a straightforward way to automate repetitive tasks.
The course also introduces several of Excel’s core analytical features, including correlation, linear regression, and simple forecasting tools such as the Forecast Sheet and =TREND(), alongside practical problem‑solving aids like Goal Seek and the Auditing tools that help identify and resolve spreadsheet errors.
Programme Structure
By the end of this course, you will be able to:- Apply Power Query to source, combine and transform large datasets
- Create a macro to automate steps in Excel
- Apply the Regression tool to forecast numbers
- Apply Excel auditing tools to troubleshoot spreadsheets
Key information
Duration
- Part-time
- 1 days
Start dates & application deadlines
You can apply for and start this programme anytime.
Language
English
Delivered
Online
Campus Location
- London, United Kingdom
Disciplines
Data Analytics View 33 other Short Courses in Data Analytics in United KingdomWhat students do after studying
Join for free or log in to access our complete career info list.
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
Who is the course for?
- Finance professionals looking for more advanced and sophisticated techniques to analyse data using MS Excel, including accountants (trainee and qualified), financial controllers and directors, financial analysts and other professionals (HR/Operations/IT etc.)
Tuition Fees
Tuition fees are shown in and the most likely applicable fee is shown based on your nationality.
-
International Applies to you
Applies to youNon-residents150 GBP / full≈ 150 GBP / full -
Domestic Applies to you
Applies to youCitizens or residents150 GBP / full≈ 150 GBP / full
Funding
Improve page content