marcusevans pan asia conferences

Mastering Financial Modeling using Microsoft Excel: Applications and Analysis

Optimisation of hands-on Excel skills parallel to business logic to develop financial models capable of generating accurate and scenario based data

1-2 Aug 2016
Parkroyal Hotel, Kuala Lumpur, Malaysia

Why You Should Attend

Mastering Financial Modeling using Microsoft Excel: Applications and Analysis

The ever changing landscape of financial management demands that professionals entrusted with such duties equip themselves with advanced working knowledge of financial models as a means of facilitating smoother financial analysis, forecasting and scenario analysis. Such models are the cornerstone of both short term and long term business decisions that dictate a company's financial future.

Although the use of Excel spreadsheets for designing financial models is widespread, many users are not aware of, or do not optimise, their use of the features built into Excel. This leads to costly errors: undetected errors in worksheets that have a negative impact and decisions that could be based on scant information which has not been fully or properly analysed.

 This practical 2 day course is designed to provide equal attention to all areas of financial management, forecasting and scenario management that will benefit from well designed financial models. The programme caters for the specific levels of financial modelling knowledge as well as Excel proficiency in financial modelling. The course is designed to provide delegates with extensive hands on practice to correlate the lecture substance with real life scenarios by using case studies.


Key Topics

  • Reviewing the Financial Modelling Theory and Best Practices
  • Improving Financial Model Sensitivity and Accuracy by Proper Application of Data Tables: Finding Information in Excel
  • Integrating Financial Logic with Hands on Approach to Design Effective Budgeting and Forecasting Models
  • Testing Financial Models Variables through Sensitivity Analysis to Reduce Possible Future Risks: Financial Planning and Forecasting
  • Developing Proper Methodology for Time Value of Money Decisions

  • Why Choose marcus evans?

    marcus evans specialises in the research and development of strategic events for senior business executives. From our international network of 63 offices, marcus evans produces over 1000 event days a year on strategic issues in corporate finance, telecommunications, technology, health, transportation, capital markets, human resources and business improvement.

    Above all, marcus evans provides clients with business information and knowledge which enables them to sustain a valuable competitive advantage and makes a positive contribution to their success.

    Voice of Our Customers
    • Very well organised with approachable staff. Citibank Berhad, Malaysia
    • Exercise and practice – Trainer gave lots of material for practice. Sterling Investment Bank
    • The course was very practical and applicable to finance managers. Materials provided are excellent. Ultravetis EA Ltd
    • Very practical and awesome! CMA Philippines
    • The course is a very good programme for engineers handling projects. Carigali – PTTEPI Operating Co Sdn Bhd
    Join the Discussion

    Follow on LinkedIn

    Event Contact

    For all enquiries regarding speaking, sponsoring and attending this conference contact:

    Miss Bernardine Michael - Marketing Director (Asia Pacific, Middle East and Africa)

    marcus evans Kuala Lumpur , Suite A-20-1, Level 20
    Hampshire Place Office, 157 Hampshire, 1, Jalan Mayang Sari
    50250 Kuala Lumpur

    Fax: 0060327236699