COURSE HIGHLIGHTS
• Building Financial Models
• Financial Statement Modelling
• Excel Financial Functions Overview
• Investment Modelling
• Sensitivity Analysis Modelling
• Simulation Modelling
• Building Complex Models
• Modelling Application Case Study

METHODOLOGY:
• Hands-On Application • Case Studies • Case Simulation
• Demonstration • Exercises

1 Participant to a Computer

INTRODUCTION

The spreadsheet as a financial tool has been in use in organisations for many years. Many employees are familiar with using the most basic functions in building simple models using the intrinsic functions of Excel. This is exemplified by the common use of macros by users. However, with the constant changes in the business environment being the norm of the day, there is a need to move organisations beyond efficiency.

The objective of the course is to build on the current skill level of the participants to build more complex model using more advanced financial tools and modelling language such as VBA and IFPS. VBA serves to provide a powerful and easy means to integrate Excel into the organisation’s decision support systems. The acquisition and development of corporate models serve as a means to retain organisation’s knowledge and promote knowledge sharing.

This course will teach the Excel users how to harness additional programming power in the context of building powerful, flexible and usable spreadsheet models. The course takes a “hands-on” approach to learning corporate models rather than focusing on the theory.

AFTER ATTENDING THIS COURSE, YOU WILL RETURN TO YOUR JOB…
• Understanding the financial modelling framework and techniques.
• Gaining hands-on experience on Advanced Excel functions and Modelling tools.
• Finding out all the built-in advanced financial functions and Excel add-ins.
• Knowing how to create, records, edit and using Excel macros.
• Applying Excel VBA and its objects in model construction.
• Familiarising yourself with all the Financial Modelling Techniques and Excel Statistics.
• Learning how to create and use VBA custom financial functions in Excel.

WHO SHOULD ATTEND
Experienced Financial users of Excel who now wish to harness the power of VBA
to develop sophisticated Spreadsheet Models:
• Those who are involved in Financial and Accounting related fields
• Business Analysts • Financial Analysts • Financial Officers • Accountants
• Software Developers • Programmers • Analysts • Consultants

LEARN FROM THE BEST

DR. LIM THOU TIN’s work experience includes working in large Singapore companies to MNCs in senior corporate, IT and project management positions. As a management consultant and practitioner, he has facilitated organisational initiatives/projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, India, Indonesia and Thailand. He has also served in positions such as corporate advisor, chief information officer and chief operating officer in start-up companies in Singapore. His area of involvement includes helping organisations to plan their corporate IT to building and management of their financial decision support systems, corporate knowledge and ecommerce portals. His consulting work includes working with both the financial and services industries to help them to develop corporate, financial and knowledge models to address their decision-making needs.

Dr. Lim graduated with a Bachelor of Business Administration degree from the National University of Singapore and holds double masters in Information Systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. Dr. Lim earned his Doctor of Business Administration degree from the Southern Cross University, Australia. He is also a fellow member of American Academy of  Financial Management.

CERTIFICATE OF COMPLETION
A Certificate of Completion will be awarded upon successful completion of each course. This serves as evidence of your personal and professional commitment to you career.

COURSE TIMING
Registration: 8.30 am, Course Begins: 9.00 am, Morning Coffee: 10.30 am,
Lunch: 1.00 pm to 2.00 pm, Tea Break: 3:30 pm, Course Ends: 5.00 pm