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
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 General Brochure
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".
|