COURSE HIGHLIGHTS:
• Spreadsheet Concept And Structure
• Building Basic Formulas
• Creating Advanced Formulas
• Spreadsheet Calculation Techniques
• Spreadsheet Consolidation And Linking
• Charting Techniques And Presentation
• Auditing And Debugging

1 Participant to a Computer

COURSE PREREQUISITES:
Participants should have already a basic understanding of Excel

INTRODUCTION
It has been said that the 95/5 rule applies in the Excel spreadsheet world. 95% of the users used only 5% of its power.
Most users realised that they could further harness the power of Excel if they could have a better handle of it’s structure, formulas and functions. This is much complicated by the incomprehensive jargon and procedures.

Nothing is more powerful than having clear and accurate data to make meaningful and useful decisions about your company, business units, product cycles, sales projections and operating requirements in order to forecasts your business futures. This course is directed at the businessperson who needs to use Excel in their everyday job to improve decision-making and productivity.

AFTER ATTENDING THIS COURSE, YOU WILL RETURN TO YOUR JOB…
• Learning how to handle Excel’s structure, formulas and functions effectively.
• Knowing how to build a clear and accurate data.
• Establishing a complex spreadsheet system in the area of finance and business, accounting, banking and insurance.
• Understanding the process of spreadsheet consolidation and linking.
• Knowing how Formulae and Functions work.
• Finding out how to design and create forms using Excel.

METHODOLOGY
• Lectures • Case Exercises • Practical Computer Hands-On Applications

WHO SHOULD ATTEND
This course would be of great benefit to:
• Business Analysts • Financial Modellers • Accountants • Bankers
• Finance Managers • Financial Analysts • Financial Controllers • Financial Advisers
• Others who wish to add spreadsheet design, spreadsheet security and advanced modeling to their skill sets.
• It appeals especially to those who need to build skills and confidence in complex spreadsheet systems in the area of finance and business, accounting, banking, and insurance.

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