This module is not currently running in 2024 to 2025.
This module will develop core understanding and skills of using Microsoft Excel, a market leading analytical tool and software package. It covers the way in which enterprises such as businesses, not-for-profit organisations and governments utilise quantitative data to obtain insights for decision-making. Techniques will be taught and delivered with case studies and simulated datasets.
Topics to be covered include:
• Microsoft Excel functions and formulae: Nested functions, filters, lookup functions, and logical functions
• Data visualisation: Graphic operations
• Data analysis and statistical analysis: conditional formatting, Solver, Add-ins and Trend analysis
• Excel Macros: defining, recording, assigning, running and storing, etc.
Total contact hours: 21
Private study hours: 129
Total study hours: 150
Main assessment methods:
Individual Excel Project (60%)
Individual Report (40%)
Reassessment method:
100% coursework
Essential Reading:
Etheridge, D. (2010) Excel Data Analysis: Your Visual Blueprint for Analyzing Data, Charts, and Pivot Tables (3rd Ed.), Chichester: John Wiley & Sons.
Background Reading:
Davis, G. and Pecar, B. (2013) Business Statistics Using Excel, Second edition, Oxford: OUP.
Swift, L. and Piff, S. (2014) Quantitative Methods for Business, Management and Finance, Basingstoke, Palgrave Macmillan.
See the library reading list for this module (Medway)
The intended subject specific learning outcomes.
On successfully completing the module students will be able to:
- Identify and apply a range of quantitative tools, including data collection and analysis, interpretation and extrapolation.
- Select appropriate quantitative methods to assist in the solving of business problems.
- Construct and apply quantitative models to describe and predict business scenarios using Excel spreadsheets.
- Demonstrate the application of Information and Communication Technology (ICT) appropriately and effectively in typical business applications.
The intended generic learning outcomes.
On successfully completing the module students will be able to:
- Retrieve information from a variety of sources.
- Undertake independent and self-managed learning.
- Apply numerical skills and techniques in practical scenarios.
- Communicate accurately and reliably in a variety of forms the results of business analysis.
University of Kent makes every effort to ensure that module information is accurate for the relevant academic session and to provide educational services as described. However, courses, services and other matters may be subject to change. Please read our full disclaimer.
