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» PrerequisitesNone» AssessmentOn completion of this course, attendees will be provided with a Certificate of Participation.» Duration1 Day - 9:00am to 4:00pm.» Cost$399.00 (Inc GST) per person.» DatesPlease click on Timetable menu above to view the current dates » RegistrationTo register for this course please click here.» More InfomationIf you require more infomation please don't hesitate to contact us.