3.9 Read 33 reviews
Overview
Sharpen your Excel skills with this Foundations of Data Analysis using MS Excel course at BPP University. Learn how to build clean, efficient spreadsheets using formulas, formatting, and logical functions that save time and reduce errors.
What you will learn
This course builds a solid foundation in essential Excel skills, moving from core navigation and formatting through to practical data analysis techniques.
Learners will start by developing confidence with the basics: entering and organising data, using shortcuts, applying formatting, and working with absolute references to ensure formulas behave as intended.
The course then introduces logical statements and lookup functions, showing how Excel can be used to return results based on conditions and connect related information within a dataset. Building on this, learners explore key date and text functions that make it easier to clean, restructure, and work with data in a form suitable for analysis or forecasting.
The final segment covers additional tools for handling larger datasets, including functions such as SUBTOTAL and SUMIF(S), the use of structured Tables to support filtering and sorting, and an introductory look at PivotTables to summarise information quickly and effectively.
Programme Structure
By the end of this course you will be able to:- Confidently navigate Excel worksheets and apply essential formulas and functions to streamline data analysis.
- Format, structure, and organise data effectively using tables, cell formatting, and referencing techniques.
- Apply logical, text, and date functions to manage conditional scenarios and manipulate data dynamically.
- Automate calculations and enhance efficiency using advanced functions such as SUMIF, LOOKUP, and related tools.
- Analyse and present data insights by creating PivotTables and using slicing techniques for deeper exploration.
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 32 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 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-residents200 GBP / full≈ 200 GBP / full -
Domestic Applies to you
Applies to youCitizens or residents200 GBP / full≈ 200 GBP / full
Funding
Improve page content