Teaching Responsibility
LJMU Schools involved in Delivery:
LJMU Partner Taught
Learning Methods
Online
Module Offerings
5603AFYPC-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.
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.
Additional Information:
This is a practically focused module developed in consultation with employers highlighting the skills necessary for accounting and finance students.
This is a practically focused module developed in consultation with employers highlighting the skills necessary for accounting and finance students.