This workshop is available in Kuala Lumpur (14 and 15 May). This workshop will guide you step by step using simulation approach to manage & report business intelligence of profit & cash flow, investment, budgeting processes & read financial statements in a dashboard manner.
Save 10% when you register online at least 1 month prior to the workshop date
Presenter (s):
Dr Steven Liew
This workshop will guide you step by step using simulation approach to manage & report business intelligence of profit & cash flow, investment, budgeting processes & read financial statements in a dashboard manner. Free practical well tested Financial Modelling - Reports & Dashboard excel templates are provided using pivot table, Goal Seek & Solver
Key topics covered:
Module 1-2: Excel Dashboard for Financial Performance (Simulation exercise)
Module 3: Excel Dashboard for Cash Flow Statement (simulation exercises)
Module 4: What Excel skills are most valuable for finance and accounting?
Module 5: Excel Dashboard for Working Capital Management (Simulation Exercises)
Module 6: Excel dashboard on Financial Ratios Analysis (Simulation on Real Listed Companies Case Studies)
Module 7: Excel Dashboard for Investment Appraisal (simulation Case Study)
Module 8: Excel Dashboard for Budgeting (Simulation Exercises)
Objectives
Manage reports and dashboard for financial performance
Manage reports and dashboard for cash flow statement
To design dashboard for working capital requirement
To plan your budgets and dashboard reporting
Using goal seek to hit management expectations on sales, profit & cash flow
Tp identify Excel skills that are most valuable for finance and accounting
All our workshops are available via in-house training.
Audience
Entrepreneurs, Accountants, Business Managers, Marketing Managers, Treasurers, Supervisors, Executives and Managers and all professionals who are interested in Financial Modelling - Reports & Dashboard
Details
108181448
2 day
System is currently experiencing issues and we are working on a solution. If you encounter an error, please come back shortly and try again.