AccessUTS Short Course Financial Analysis Certificate – using Excel

When:
March 16, 2018 – April 21, 2018 all-day
2018-03-16T00:00:00+11:00
2018-04-22T00:00:00+10:00
Where:
University of Technology Sydney
Building 10/265 Jones St
Ultimo NSW 2007
Australia

The first part of FAC is a fast-paced comprehensive set of tools to tap into the full power of Excel. The second part of the course builds ‘smart’ analytical models, useful applications for more advanced techniques, which are transferable throughout an organisation.

This program is particularly useful for professional staff who need to vastly increase their professional spread-sheeting skills especially in the disciplinary areas of Accounting and Finance.

Program Topics

 

Key Techniques for Improved Model Building such as:

  • Structure and model layout
  • Design rules for good layout
  • Pointing techniques (including cursor movement) to avoid errors
  • Keyboard techniques: non-rodent access to menus, cells etc.
  • Relative, mixed, absolute and 3D addressing
  • Naming ranges, using row and column labels
  • Intersection operator
  • Formula Palette, finding and using built-in functions
  • Working with lists and filling ranges
  • Lookup tables using VLOOKUP, INDEX, MATCH
  • Housekeeping and security
  • Spreadsheet security and distribution of models
  • Developing a planning model including variables and assumptions table
  • Incorporating a plant expansion into the planning model.

Advanced Techniques:

  • Formula Palette, finding and using built-in functions
  • Working with lists and filling ranges
  • Lookup tables using VLOOKUP, INDEX, MATCH
  • Developing a planning model including variables and assumptions table
  • Incorporating a plant expansion into the planning model
  • Advanced cell formatting techniques
  • Custom formatting
  • Conditional formatting
  • Data validation
  • Array functions
  • Price break style lookups and discontinuities
  • Charting tools and techniques
  • Importing and opening non-spreadsheet files
  • Parsing text ranges
  • Transposing ranges
  • Workbook templates
  • Techniques for building consolidated reports by function
  • Techniques for building consolidated reports using Excel tools
  • Working with version data
  • Spreadsheet settings and preferences
  • Toolbar configuration.

Sensitivities:

  • Sensitivity analysis using Data Tables
  • Sensitivity analysis using Scenarios
  • Scenario summary report

Workbook Linking:

  • Building links
  • Building safe links using range names and intersection operator
  • Understanding link resolution
  • Locating and removing invalid links.

View further information here

 

Comment below to have your say on this story.

If you have a news story or tip-off, get in touch at editorial@governmentnews.com.au.  

Sign up to the Government News newsletter

Leave a comment:

Your email address will not be published. All fields are required