课程总览  |  初级  |  中级AA  |  高级BA/MA  |  高级TAX  |  高级SMSF  |  软件技能  |  高级财务建模
ECARE企业会计职业发展解决方案
Financial Modelling and Dashboard
高级财务建模

课程概览

第一天课程:


• Advanced chart
• What makes good/bad chart?
• Select the correct chart for your data
• Creating and formatting high-impact charts for business
• Case: Using 100% stacked chart to show development capital movement
• Case: Using waterfall chart for profit analysis
• Case: Using Bullet chart to evaluate performance against budget
• Case: Using Bubble chart for market analysis
• Case: Using combo chart to show cost and profit trend
• Case: Using column chart to show different source of income
• Case: Using cluster column chart to analyse product sales
• Case: Using bar chart to report sales trend
• Dynamic reporting techniques
• Use form control for interactive report
• Use data validation for interactive report
• Use excel formula Offset, index/match, choose, indirect for dynamic data selection and manipulation

第二天课程:


• What is financial modelling
• Model design
• What makes a good or bad financial model
• Best Practice in Financial Modelling
• Case 1: Corporate Management reporting model
• Cleaning your data
• Build database for dynamic management report
• Format your way to visualizations
• Give user an interactive interface
• Case 2: Project evaluation model
Evaluate project feasibility with IRR (Internal Rate of Return), NPV (Net Present Value) and the payback period

悉尼 | 墨尔本 | 网课

4小时 * 4节课

授课讲师

资深行业专家倾情教授

适用对象

已经有本地会计工作经验(commercial and industry领域)1-2年的人士,想在自己已有的工作基础上进一步提高自己的知识和水平,来提升自己的薪资竞争力。
参加过我们初级班或中级Assistant Accountant班的同学,已经对business process和procedure熟练掌握和应用,为进一步提高自身能力和薪资水平。

择业方向

中型-大型规模公司的
Management Accountant/Business Analyst
Assistant accountant
Financial accountant

课程周期

业余时间学习,周末开班,总课时16小时

更多成功经验分享

查看更多ECARE实战课程详情

查阅最近课程安排及开班日期

更多课程信息欢迎来电或在线垂询

订阅ECARE NEWS实时更新课程资讯

SYDNEY OFFICE

Suite 601, Level 6, 303 Pitt St, 

Sydney, NSW, 2000,Australia

+61 4 1226 9477

+61 2 8018 4717

MELBOURNE OFFICE

Suite 204, Level 2, 546 Collins St,

Melbourne, VIC, 3000,Australia

+61 4 2366 1292

+61 3 9939 4134

FOLLOW US
  • LinkedIn Social Icon
  • YouTube
FIND US ON WECHAT
SYDNEY
QLD & WA & TAS &
NT Southern Australia
MELBOURNE