Individual 2000 words

In-class Test

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 accounting systems.

Data Analysis for Accounting - 5503AFYPC

Data Analysis for Accounting

Analyse and evaluate the results of the data models and make recommendations.

Create and analyse data models using Microsoft Excel.

Effectively use a selection of advanced Microsoft Excel tools.

Effectively communicate the results of the evaluation and recommendations to finance and non-finance managers.