Description
For REP’s, Member staff and Group (3+) registrations, complete & email registration form to cpd.malaysia@cpaaustralia.com.au
Download brochure & registration form
Presenter:
Ms Shireen Ng
This workshop will teach you to build, communicate, understand or audit robust financial models, quicker. Make the spread sheet more useful by using the full capabilities of Excel to enhance the financial management in your company.
Pre-requisite
1) Must possessed at least Intermediate Excel and basic financial knowledge
2) Software Version: MS Excel 2010
3) Laptop: Participants are required to bring their own laptop
Key topics covered:
- Working smart with Excel
- Building easy monthly, year-to-date update report model
- Creating, managing and analysing data tables
- Making decisions with limiting constraints
- Using charts for decision making
- The cost of capital and analysing capital investment projects
- Analysing budgeting models
- Dealing with tables of data
Learning objectives
At the end of the workshop, participants will be able to:
- understand the dos and don’ts in building various financial models using Excel
- deal and analyse with large amounts of data by leveraging on powerful Excel functions
- make better financial decisions with solver
- prepare financial charts for better decision making
All our workshops are available via in-house training.
Audience
Accountants, finance managers, accounts supervisors, accounting staff and anyone who want to learn more how Excel can be used to create finance models effectively.