Microsoft Excel Financial Spreadsheets 

This course is designed for those wanting to extend their knowledge beyond the basics of excel. With a particular emphasis on accounting related issues this will get you implementing new methods to problem solve and analyse data. Plenty of hands on examples with working spreadsheets to take away with you on the day!


» Course Outline

    Investment Analysis using the Time Value of Money (Including Charting Results)
            Future Value, Present Value
            Annuities
            NPV
            IRR
            Effective Rates
            Loan Amortisation Schedules

    What If Analysis
            Lease or Buy?
            Using Goal Seek
            Using Solver to find optimal  results
            Forecasting using linear, non linear and time models
            Using Pivot Tables to analyse data Saving

    Budgeting & Reporting
            Different ways to consolidate data
            Use ROUND, IF, LOOKUP and Database Functions
            Charting

    Fixed Asset Register
            Depreciation Schedules
            Working with Date and Time Calculations
            Visual Basic
            Introduction to recording and editing Macros in VBA
            Creating custom functions using VBA
            Function Procedure Basics


» Prerequisites
None

» Assessment
On completion of this course, attendees will be provided with a Certificate of Participation.

» Duration
1 Day - 9:00am to 4:00pm.

» Cost
$399.00 (Inc GST) per person.

» Dates
Please click on Timetable menu above to view the current dates

» Registration
To register for this course please click here.

» More Infomation
If you require more infomation please don't hesitate to contact us.