Financial Analysis Systems Certificate
The Financial Analysis Systems Certificate (FAS) is a 48-hour hands-on introduction to
Visual Basic for Applications (VBA) programming in Excel specifically for in-class
presentation which is designed for finance professionals who need to automate their models and applications, add
custom functions or extend the user interface.
The FAS assumes no prior knowledge of VBA but does assume that the student has
above average knowledge and expertise in Excel, its functions, tools and features. Similar knowledge
to that gained by students of the Financial Analysis Certificate (FAC) is assumed, including a deep
understanding of worksheet functions, custom numeric formatting, names, array formulas, logical expressions
and range, mathematical and logical operators. It is also assumed that the student has the
aptitudes for the analysis of business applications and the design and development of business solutions.
This is not just a more advanced form of Excel training which is the natural
step for everyone, rather it is a more challenging discipline which is in some ways parallel to the body of
knowledge presented in the Financial Analysis Certificate (FAC). If you are unsure whether the
FAS or FAC is the appropriate course for you, we would be happy to discuss your needs and assist you in
selecting the appropriate training.
It aims to take an experienced Excel user and introduce them to all the core features of the programming language,
the programming environment and to demonstrate essential development methodologies for use in developing Excel-based solutions.
The courseware includes a 170+ page text together with a CD-ROM which includes the
sample files, worked solutions for most problems and some reference documents.
A detailed course outline is included in the course brochure, a link to which is
included at the bottom of this page.
This course is available for in-class teaching publicly from Clarkson ITT and privately through Clarkson ITT
and University of Technology, Sydney (UTS), see Public Courses and
Private Courses web pages.
The Financial Analysis Systems Certificate will be offerred in Adelaide, Brisbane, Perth and Melbourne during 2011.
The Financial Analysis Certificate Extension Program is a specially designed
distance learning variant of this course. It is available for non-Sydney residents as the
Financial Analysis Certificate by Distance Learning Extension Program (FADLEP) through UTS, see Public Courses web page.
FAS Sydney November 18, 2010
VBA is the programming language provided by Microsoft to enhance and extend the functionality of
Office applications, including Excel and the workbooks and models created with it. The routines and programs
created with VBA are often referred to as "macros".
|