Financial Modelling Essential
weekend 19th & 20th November 2016 Melbourne
Financial Modelling Essential
一直是高级会计课程中最受欢迎的一个科目。
对于会计工作者，无论出于什么阶段，
都能够在这项课程的学习过程中
得到非常有效的新技能。
充分利用 Excel 的优秀数据处理功能，
结合逻辑缜密的会计工作原理，
Financial Model 将为您建立更有效的
会计工作系统。
请详细查看下面课程大纲：
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 CourseFinancial Modelling Introduction
- What is financial modelling- Best practice in financial modelling- Art in an effective Excel modelExcel Skills Needed for Financial Modelling- Absolute & relative cell reference- Switch row & column of chart- 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- How to deal with blank record- How to deal with duplicate records- How to find & replace certain value- How to get data from PDF filesMaintaining Financial Model- Techniques to reduce error- Common Excel error types- How to correct and suppress error- How to set up error checking moduleFinancial 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- 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
报名与咨询方式:
