1. Handbook
  2. Subjects
  3. Financial Spreadsheeting

Financial Spreadsheeting (FNCE90045)

Graduate courseworkPoints: 12.5On Campus (Parkville)

You’re viewing the 2017 Handbook. View archived Handbooks

Overview

Year of offer2017
Subject levelGraduate coursework
Subject codeFNCE90045
Campus
Parkville
Availability
Semester 1
Semester 2
FeesSubject EFTSL, Level, Discipline & Census Date

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.

Intended learning outcomes

On successful completion of this subject students should be able to:

  • Use all the built-in features of Microsoft Excel;
  • Explain the principles of object-orientated programming;
  • Apply the principles of object-oriented programming to the development of Visual Basic for Applications programs;
  • Integrate various programming structures and concepts to build complex programs;
  • Evaluate strategies for finding and fixing computer programming errors;
  • Design computer programs that implement solutions in an efficient and effective manner.

Generic skills

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

Last updated: 16 August 2017