Financial Spreadsheeting

Subject 333-668 (2008)

Note: This is an archived Handbook entry from 2008.Search for this in the current handbook

Credit Points: 6.250
Level: Graduate/Postgraduate
Dates & Locations:

This subject has the following teaching availabilities in 2008:

Semester 1, - Taught on campus.
Pre-teaching Period Start not applicable
Teaching Period not applicable
Assessment Period End not applicable
Last date to Self-Enrol not applicable
Census Date not applicable
Last date to Withdraw without fail not applicable

Semester 2, - Taught on campus.
Pre-teaching Period Start not applicable
Teaching Period not applicable
Assessment Period End not applicable
Last date to Self-Enrol not applicable
Census Date not applicable
Last date to Withdraw without fail not applicable


Timetable can be viewed here. For information about these dates, click here.
Time Commitment: Contact Hours: 18 hours per semester (Semester 1, Semester 2).
Total Time Commitment: Not available
Prerequisites: 333-661 Principles of Finance, 333-662 Derivative Securities. This subject is only available to those students that would satisfy the entry criteria for the Master of Applied Finance.
Corequisites: None
Recommended Background Knowledge: None
Non Allowed Subjects: None
Core Participation Requirements:

For the purposes of considering request for Reasonable Adjustments under the Disability Standards for Education (Cwth 2005), and Student Support and Engagement Policy, academic requirements for this subject are articulated in the Subject Overview, Learning Outcomes, Assessment and Generic Skills sections of this entry.

It is University policy to take all reasonable steps to minimise the impact of disability upon academic study, and reasonable adjustments will be made to enhance a student's participation in the University's programs. Students who feel their disability may impact on meeting the requirements of this subject are encouraged to discuss this matter with a Faculty Student Adviser and Student Equity and Disability Support: http://services.unimelb.edu.au/disability
Subject Overview: MS Excel features including formulae and ranges, altering worksheet appearance, workbook management, transferring data, analysis and manipulation tools. Visual Basic for Applications including user defined functions and macros. Application of programming to a range of financial problems.
Assessment: One 2-hour end-of-semester examination (50%) and computer oriented assignments (50%).
Prescribed Texts: None
Breadth Options:

This subject is not available as a breadth subject.
Fees Information: Subject EFTSL, Level, Discipline & Census Date
Generic Skills: On successful completion of this subject students should be able to:
  • Use many of the advanced, built-in features of Microsoft Excel.
  • Explain the principles of object orientated programming.
  • Integrate various programming structures and concepts to build complex programs.
  • Design computer programs that implement solutions in an efficient and effective manner.
  • Apply financial modelling techniques to a variety of problems in finance.
  • Implement various finance modelling algorithms in the form of Visual Basic for Applications programs.

On successful completion of this subject, students should have improved the following generic skills:

  • Oral communication
  • Written communication
  • Collaborative learning
  • Problem solving
  • Team work
  • Statistical reasoning
  • Application of theory to practice
  • Interpretation & analysis
  • Critical thinking
  • Synthesis of data and other information
  • Evaluation of data and other information
  • Using computer software
  • Accessing data and other information from a range of sources
Related Course(s): Master of Applied Finance

Download PDF version.