Teaching Responsibility
LJMU Schools involved in Delivery:
Liverpool Business School
Learning Methods
Online
Workshop
Module Offerings
5103LBSAF-JAN-MTP
Aims
This module will equip students with the technical skills to be able to accurately perform data modelling using appropriate software.
Learning Outcomes
1.
Create and analyse data models using Microsoft Excel.
2.
Effectively use a selection of advanced Microsoft Excel tools.
3.
Analyse and evaluate the results of the data models and make recommendations.
4.
Effectively communicate the results of the evaluation and recommendations to finance and non-finance managers.
Module Content
Outline Syllabus:Basic Microsoft Excel functions including but not exclusively;
data entry, formatting, charts and graphs and formulae.
Advanced Microsoft Excel functions including but not exclusively;
conditional formatting, pivot tables, input tables, what ifs.
Use of Microsoft Excel for accounting purposes, for example, statistical analysis, calculating variances, sorting and filtering data, discount rates, comparison of interest rates, accounting ratios.
An understanding of big data and current technical issues in accounting and finance.
Module Overview:
This module has been designed to equip students with the technical skills to be able to accurately perform data modelling using appropriate software.
This module has been designed to equip students with the technical skills to be able to accurately perform data modelling using appropriate software.
Additional Information:This is a practically focused module developed in consultation with employers highlighting the skills necessary for accounting and finance students.