weekend 25th & 26th March 2017 Melbourne (face-to-face)
Most of accountants were trained how to use Accounting Systems / Excel, but seldom be trained logically how to build a financial model. This course would guide you to explore the fundamental and concept behind financial model. You will learn the essential techniques during different phases: designing, modelling, prototype and testing. And you will also learn how to use models in accounting daily jobs. Key Modules Covered in the Course Financial Modelling Introduction - What is financial modelling- Best practice in financial modelling- Art in an effective Excel model Excel Skills Needed for Financial Modelling - Conditional format- Absolute & relative cell reference- Switch row & column of chart- Set up secondary axis- Group data in pivot table- What-if analysis skills- Formula dimension to deal with nested if statement- How to apply an effective model in Excel- How to escape from “excel hell” Steps to Building the Financial Models- Where to start to build a model- Financial models – logical structure design- Financial models – data input- Case: Convert data table to data list- Financial models – process/calculation- Case: Consistent formulas in one area- Case: Avoid hard code in formula- Case: Running total calculation- Financial models – output- Case: Report format design Data Cleansing Skills - How to deal with blank record- How to deal with duplicate records- How to deal with text- How to find & replace certain value- How to get data from PDF files Maintaining Financial Model - Techniques to reduce error- Common Excel error types- How to correct and suppress error- How to set up error checking module Financial Models for FA daily tasks - How to use financial models in accounting jobs- Decode accounting system logic- Sales & accounts receivable procedure- Case: Accounts receivable aging report- Case: Bad debt provision- Purchase & accounts payable procedure- Case: Cash reimbursement form- Case: Rebuild an inherited model- Payroll procedure- Case: Time sheet calculation & accrual treatment- Cash management procedure- Case: Accrued interest income model- Fixed asset management procedure- Case: FA & Depreciation model with variety asset categories- How to design simple, clear, and readable model to deal with complex business tasks- Project accounting procedure- Case: Project review model过往学员反馈：
职场上遇事不决，应该刨根问底，还是使用量子力学的玄学？ 
收藏丨最全最贴心的澳洲实习干货 
