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! Quickly analyse data in excel and make sense of large amounts of information


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

Other items

  • Using Sorting and filtering techniques including advanced filtering
  • Database Functions in Excel to SUM and analyse data
  • Using Lookup functions – VLOOKUP, HLOOKUP
  • Grouping and Outlining a Worksheet
  • Linking and importing data with ODBC
  • Exporting data from applications
  • Using Solver
  • Using Scenario’s
  • 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. 




Admin   Terms   Contact