Note: This is an archived Handbook entry from 2011.
|Dates & Locations:|| |
This subject has the following teaching availabilities in 2011:Semester 2, Parkville - Taught on campus.
Timetable can be viewed here. For information about these dates, click here.
|Time Commitment:||Contact Hours: One 3-hour class per week |
Total Time Commitment: Estimated total time commitment of 120 hours per semester
|Prerequisites:|| This subject is only available to students enrolled in the Postgraduate Diploma in Finance, the Master of Finance (or the Master of Financial Management), or the Master of Accounting, and for students enrolled in the Master of Management who have completed FNCE90018 Corporate Financial Policy and FNCE90056 Investment Management. |
Study Period Commencement:
Semester 1, Semester 2
Semester 1, Semester 2
|Recommended Background Knowledge:||None|
|Non Allowed Subjects:||None|
|Core Participation Requirements:||
For the purposes of considering requests for Reasonable Adjustments under the Disability Standards for Education (Cwth 2005), and Students Experiencing Academic Disadvantage Policy, academic requirements for this subject are articulated in the Subject Description, Subject Objectives, Generic Skills and Assessment Requirements for this entry.
The University is dedicated to provide support to those with special requirements. Further details on the disability support scheme can be found at the Disability Liaison Unit website: http://www.services.unimelb.edu.au/disability/
CoordinatorDr Ian O'Connor
ContactGraduate School of Business and Economics
Level 4, 198 Berkeley Street
Telephone: +61 3 8344 1670
|Subject Overview:||The following topics will be covered: Financial Applications using Excel: basic spreadsheeting skills, functions and the function wizard, worksheet formatting and graphics. Financial problem solving tools: Solver, Goalseek and the Analysis Toolpak. Data management tools, subtotalling, consolidation, sorting filtering and pivot tables. Programming principles with applications to finance: object orientated programming, variable and control structures, writing Excel financial functions and subroutines, and creating add-ins. Communicating with the user of financial applications through message boxes, input boxes and dialogue boxes.|
|Objectives:||On successful completion of this subject students should be able to: |
|Prescribed Texts:||You will be advised of prescribed texts by your lecturer.|
|Breadth Options:|| |
This subject is not available as a breadth subject.
|Fees Information:||Subject EFTSL, Level, Discipline & Census Date|
On successful completion of this subject, students should have improved the following generic skills:
Master of Accounting |
Master of Accounting
Master of Finance
Master of Financial Management
Master of Management (Finance)
Postgraduate Diploma in Finance
Download PDF version.