top of page
Advanced Practice Course
Financial Modelling and Dashboard

Course Overview

This course is a high-level upgrade course for corporate accounting

in North America.

Day 1:

• 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

 

Day 2:


• 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

$900

4 Hours * 4 Sessions

Corporate Accountant Development Package:

Advanced BA/MA+EXCEL Advanced+SAP for BA/MA+Two-hour One-to-one Service

(Bonus: 50%Off Workshop Voucher)

$2700

Save $400

Course Length

1 weekend study, 16 hours in total

icon-4weeks.png
icon-acc-fun-2.png
icon-16hours.png

Further Information

The course is designed for

• The people who have 1-2 years local working experience in North America

(commercial and industry field), eager to improve professional skills.
• Previous EcareCareers Assistant Accountant students,

who have knowledge of business process and procedure.

Financial Management Accountant | Cost Accountant | Senior Financial Accountant

| Finance Analyst | Business Analyst

More Success Stories

FOLLOW US
  • LinkedIn Social Icon
  • YouTube
  • Instagram Social Icon
FIND US ON WECHAT
SYDNEY OFFICE

Suite 1405,Level14, 

109 Pitt St, Sydney, NSW, 2000, Australia

+61 2 8068 3982

+61 4 1226 9477

MELBOURNE OFFICE

Suite 204, Level 2, 546 Collins St,

Melbourne, VIC, 3000,Australia

+61 4 2366 1292

+61 3 9939 4134

NEW YORK OFFICE

Suite 4000, 17 State Street,

New York, NY 10004 U.S.A.

+1 212 739 0478

HONG KONG OFFICE

Level 12, One Peking, No. 1,

Peking Road, Tsim Sha Tsui,

Kowloon, Hong Kong

+852 3552 2953

QR4_canberraQueenslandsouthwestTas.jpg
NEW YORK
USA QRcode.jpg
melbourneQRcode2.jpg
QR1_sydneyQRcode_edited.jpg
SYDNEY
QLD & WA & TAS &
NT Southern Australia
MELBOURNE
COPYRIGHT © 2013-2019 ECARE CAREERS. ALL RIGHTS RESERVED.
bottom of page