ACC40900 Accounting Analytics 1

Academic Year 2020/2021

This module provides students with an ability to build sophisticated financial models in Excel using advanced functions and techniques.

Show/hide contentOpenClose All

Curricular information is subject to change

Learning Outcomes:

After completing this module students should be able to:
- construct, de-bug and analyse complex formulas in excel.
- use range names, scenarios and data tables.
- read/parse data from multiple sources.
- normalise data and perform share simulations
- sort, search, subtotal, group and use data validation.
- query data using multiple criteria.
- use Pivot tables and slicers.
- match data to other data sources and lookup tables.
- visualize data using appropriate graphs and graphics.
- use conditional formatting.
- construct VBA macros and activex controls.
- write user-defined functions.
- link and manage multiple spreadsheets.
- design dashboards and use camera.
- protect cells, files and share data in a secure way.
- use relationships between files and run PowerQueries.
- use Microsoft PowerBI.

Student Effort Type Hours


Small Group


Computer Aided Lab


Autonomous Student Learning




Requirements, Exclusions and Recommendations

Not applicable to this module.

Module Requisites and Incompatibles
Not applicable to this module.
Assessment Strategy  
Description Timing Open Book Exam Component Scale Must Pass Component % of Final Grade
Continuous Assessment: A comprehensive practical exercise must be completed and this is graded Throughout the Trimester n/a Alternative non-linear conversion grade scale 50% No


Carry forward of passed components
Resit In Terminal Exam
Summer No
Feedback Strategy/Strategies

• Feedback individually to students, post-assessment

How will my Feedback be Delivered?

Individual meetings and student reps forum

Lecture Offering 1 Week(s) - 2, 3, 4, 5, 7, 8, 9 Mon 14:30 - 17:20
Lecture Offering 1 Week(s) - 2, 3, 4, 5, 6, 7, 9 Thurs 14:30 - 17:20
Lecture Offering 1 Week(s) - 6 Tues 14:30 - 17:20

Discover our Rankings and Accreditations