3.9 Read 33 reviews
Overview
Basic Excel functionality is covered with a mix of hands-on practical exercises in this one-day course. Delegates will be able to take their completed Excel files away with them for future reference. The skills taught on this course are pre-requisites for BPP's follow-on Financial Modelling and Data Analysis courses.
Learning Outcomes
By the end of this Excel Essentials for Modelling and Analysis course at BPP University, you will be able to:
- Enter and edit data confidently in Excel
- Navigate the Ribbon and understand the difference between ribbon tabs and worksheet tabs
- Use shortcuts (rather than the mouse) to work more efficiently
- Apply basic formatting and presentation techniques to worksheets
- Perform simple calculations using formulae, AutoSum, and edited formulas
- Understand the difference between absolute and relative cell referencing
- Use basic functions such as copy, cut, paste, and basic logical statements (e.g., IF)
- Sort and filter data effectively
- Create simple charts and graphs to present data visually
- Print and save workbooks correctly for professional use
Programme Structure
This course will cover:- Data entry
- The Ribbon (ribbon tabs and worksheet tabs)
- Shortcuts vs mouse navigation
- Basic functions: copy, cut, paste
- Presentation and formatting techniques
- Simple formulae and calculations
- AutoSum and editing existing formulas
- Absolute vs relative cell referencing
- Sorting and filtering
- Logical statements: IF()Creating basic charts and graphs
- Printing and saving workbooks
- Practical exercise to apply learning
Key information
Duration
- Part-time
- 1 days
Start dates & application deadlines
- StartingApply 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?
- This course has been developed for those who are relatively new to Microsoft Excel and need an introduction to the basic functionality.
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-residents738 GBP / full≈ 738 GBP / full -
Domestic Applies to you
Applies to youCitizens or residents738 GBP / full≈ 738 GBP / full
Funding
Improve page content