Notice
To reduce the environmental impact and contribute to sustainability efforts, ISCA will contribute our part by eliminating the printing of course materials for selected courses with effect from 2023.
Tips: To make your paperless learning experience more enjoyable, you may bring along a digital device such as a Windows based laptops or tablets to read your online materials during the class. QR code will be provided in the class for you to download the materials in PDF.
Join us and be a Difference Maker! | | 
|
|
Software Installation and Laptop
As this class places strong emphasis on the hands-on experience, you will be working with data for the majority of the time in the class. To optimize the learning experience, it is mandatory for all participants to be equipped with a laptop, pre-installed with Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version.
Programme Objective
Financial models are valuable tools to support management decision making. With globalization and rapid changes, we need to be able to provide top management with quick, useful and up-to-date information and analysis for better decision making. There are a few under-utilized gems in Excel that could very much help you in this aspect of your work.
This application-driven, hands-on practical 1-day programme is designed to help you learn about and master this hidden gem - Excel what-if analysis tools. It allows you to explore different scenarios without changing the values in your worksheets. What-if Analysis tools are particularly useful for finance, economics and management professionals as well as business owners as you could see how different values affect models, formulas and projected profit or cost. In this 1-day programme, you will learn to solve business problems by performing Excel what-if analysis together with Macro and VBA. Develop interactive models for decision making, perform simulations, sensitivity and scenario analysis (best, expected and worst case) for project / investment evaluation and resource planning and allocation. Utilize the Power of Excel to optimize (maximize or minimize) certain business objectives within a specific set of business and/or operation constraints.
At the end of the programme, participants will be able to:- Acquire one of the must-have skills of every business analyst/controller and information worker: One that is efficient and dynamic and leaving them with more time to collaborate with their CEOs and business owners in making better business decisions to propel the business towards greater growth and excellence;
- Develop interactive models for decision making, perform simulations, sensitivity and scenario analysis (best, expected and worst case) for project / investment evaluation and resource planning;
- Utilize the Power of Excel to achieve business goals;
- Build financial model so that last minute sensitivity model can be easily created, analyzed and presented;
- Work with macros and VBA that will save you time and make your work easier.
Programme Outline
This programme is not about teaching you how to use everything about Excel. You should already know how to use the basic features of Excel, such as workbooks, worksheets, cells, formulas, menus and toolbars. The focus is on Excel's hidden gem - Excel what-if analysis tools. It will show you how what-if analysis tools could be utilized in your daily work, using case studies and active discussions.
- Learn how to build effective Financial Model quickly and effectively to meet business needs;
- Develop effective Financial Model to evaluate new product;
- Understand cash flow statement vs. profit and loss statement;
- Understand mathematical relationships between financial variables;
- Identify key drivers and understand risks;
- Calculate DCF and NPV;
- Create Data Table to assess the impact of variables and overcome restrictions in Data Table;
- Handle uncertainty in investment / project evaluation;
- Perform Sensitivity Analysis;
- Create effective charts to present decision-making models;
- Solve business problems with Goal Seek;
- Troubleshooting Goal Seek;
- Explore alternative data sets with scenarios;
- Create, display, edit, add and deleting scenarios;
- Troubleshooting scenarios;
- Use Excel to optimize certain business objectives (maximize profit or minimize costs) within a specific set of constraints (such as capital, manpower, raw material etc);
- Use Excel to determine the optimal product mix, schedule your workforce and for capital budgeting and project management;
To view our full list of Infocomm courses, please click here.
Training Methodology
Lecture style, with computer hands-on Exercises/Case Studies
Closing for Registration
1 week before programme or until full enrolment
Intended For
This programme is designed for CFOs, Finance Directors, Financial Controllers, Business Controllers, Financial / Business Analysts, Finance managers, Accountants, Bankers, Businessmen and Information professionals who want to take advantage of Microsoft Excel What-If Data Analysis Tools to help them in their data analyze and business planning. It is designed for those frustrated and hard-working souls who know they are not dumb, but find that the numerous and ever-changing requests for information and reports from management are making them work late into the nights. Yet they fully understand that good financial information made available to key decision makers at the right time has a significant and beneficial effect on organizational performance.
Competency Mapping
Category 5 = 7.00 Hours
Schedule & Fees
Date & Time
28 Aug 2024 (9:00 AM - 5:00 PM)
Fee (inclusive of GST)
For Members:
$ 394.58
For Non-Members:
$ 470.88
Programme Facilitator(s)
Jasmine Ng
Venue
60 Cecil Street
ISCA House
Singapore 049709
Testimonial
The trainer uses business examples to elaborate the use of what-if, solver, etc functions, which is good to
understand and useful for work.
Past Participant
The course is beneficial to me. I will try to apply in my work
Past Participant
Funding
1] NTUC Union Training Assistance Programme (UTAP)
NTUC members enjoy 50% *unfunded course fee support for up to $250 each year when you sign up for courses supported under UTAP. NTUC members aged 40 and above can enjoy higher funding support up to $500 per individual each year, capped at 50% of unfunded course fees, for courses attended between 1 July 2020 to 31 December 2025.
*Unfunded course fee refers to the balance course fee payable after applicable government subsidies. This excludes material fees, registration fees, misc. fees etc.
This course is approved for UTAP support for intakes conducted between 08 February 2024 – 31 March 2025.
As UTAP is given on calendar year basis, and calculated based on year of training taken, it cannot be accumulated.
- Maintained paid-up NTUC membership before course, throughout course duration and at the point of claim and;
- Course by training provider must be supported under UTAP and training must commence within the supported period and;
- Unfunded course fee must not be fully sponsored by company or other types of funding
- Unfunded course fee must be S$20.00 and above, and;
- Member must achieve a minimum of 75% attendance for each application and sat for all prescribed examination(s), if any and;
- UTAP application must be made within 6 months after course ends.
For more information on UTAP Funding and to submit for UTAP claims, please visit https://www.ntuc.org.sg/uportal/programmes/union-training-assistance-programme. Terms and conditions apply.
Programme Facilitator(s)
Jasmine Ng
CA (Singapore), FCCA, ACTA, DACE
Jasmine Ng is a Fellow member of the Association of Chartered Certified Accountants (ACCA) and a member of the Institute of Singapore Chartered Accountants (ISCA). She has over 18 years of extensive experience in the area of audit, accounting, financial analysis, business controlling, enterprise system implementation and training. She travelled extensively during the course of her work and gain exposure to different culture and work style.
She utilizes her creativity and real-world examples in conducting her training. Jasmine is passionately fond of training and always willing to share with others all that she knows. Her outgoing, pleasant personality and confident disposition have made her training all the more lively, fun and insightful.
Notice
To reduce the environmental impact and contribute to sustainability efforts, ISCA will contribute our part by eliminating the printing of course materials for selected courses with effect from 2023.
Tips: To make your paperless learning experience more enjoyable, you may bring along a digital device such as a Windows based laptops or tablets to read your online materials during the class. QR code will be provided in the class for you to download the materials in PDF.
Join us and be a Difference Maker! | |
|
|
Software Installation and Laptop
As this class places strong emphasis on the hands-on experience, you will be working with data for the majority of the time in the class. To optimize the learning experience, it is mandatory for all participants to be equipped with a laptop, pre-installed with Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version.
Programme Objective
Financial models are valuable tools to support management decision making. With globalization and rapid changes, we need to be able to provide top management with quick, useful and up-to-date information and analysis for better decision making. There are a few under-utilized gems in Excel that could very much help you in this aspect of your work.
This application-driven, hands-on practical 1-day programme is designed to help you learn about and master this hidden gem - Excel what-if analysis tools. It allows you to explore different scenarios without changing the values in your worksheets. What-if Analysis tools are particularly useful for finance, economics and management professionals as well as business owners as you could see how different values affect models, formulas and projected profit or cost. In this 1-day programme, you will learn to solve business problems by performing Excel what-if analysis together with Macro and VBA. Develop interactive models for decision making, perform simulations, sensitivity and scenario analysis (best, expected and worst case) for project / investment evaluation and resource planning and allocation. Utilize the Power of Excel to optimize (maximize or minimize) certain business objectives within a specific set of business and/or operation constraints.
At the end of the programme, participants will be able to:- Acquire one of the must-have skills of every business analyst/controller and information worker: One that is efficient and dynamic and leaving them with more time to collaborate with their CEOs and business owners in making better business decisions to propel the business towards greater growth and excellence;
- Develop interactive models for decision making, perform simulations, sensitivity and scenario analysis (best, expected and worst case) for project / investment evaluation and resource planning;
- Utilize the Power of Excel to achieve business goals;
- Build financial model so that last minute sensitivity model can be easily created, analyzed and presented;
- Work with macros and VBA that will save you time and make your work easier.
Programme Outline
This programme is not about teaching you how to use everything about Excel. You should already know how to use the basic features of Excel, such as workbooks, worksheets, cells, formulas, menus and toolbars. The focus is on Excel's hidden gem - Excel what-if analysis tools. It will show you how what-if analysis tools could be utilized in your daily work, using case studies and active discussions.
- Learn how to build effective Financial Model quickly and effectively to meet business needs;
- Develop effective Financial Model to evaluate new product;
- Understand cash flow statement vs. profit and loss statement;
- Understand mathematical relationships between financial variables;
- Identify key drivers and understand risks;
- Calculate DCF and NPV;
- Create Data Table to assess the impact of variables and overcome restrictions in Data Table;
- Handle uncertainty in investment / project evaluation;
- Perform Sensitivity Analysis;
- Create effective charts to present decision-making models;
- Solve business problems with Goal Seek;
- Troubleshooting Goal Seek;
- Explore alternative data sets with scenarios;
- Create, display, edit, add and deleting scenarios;
- Troubleshooting scenarios;
- Use Excel to optimize certain business objectives (maximize profit or minimize costs) within a specific set of constraints (such as capital, manpower, raw material etc);
- Use Excel to determine the optimal product mix, schedule your workforce and for capital budgeting and project management;
To view our full list of Infocomm courses, please click here.
Training Methodology
Lecture style, with computer hands-on Exercises/Case Studies
Closing for Registration
1 week before programme or until full enrolment
Intended For
This programme is designed for CFOs, Finance Directors, Financial Controllers, Business Controllers, Financial / Business Analysts, Finance managers, Accountants, Bankers, Businessmen and Information professionals who want to take advantage of Microsoft Excel What-If Data Analysis Tools to help them in their data analyze and business planning. It is designed for those frustrated and hard-working souls who know they are not dumb, but find that the numerous and ever-changing requests for information and reports from management are making them work late into the nights. Yet they fully understand that good financial information made available to key decision makers at the right time has a significant and beneficial effect on organizational performance.
Competency Mapping
Category 5 = 7.00 Hours
Programme Facilitator(s)
Jasmine Ng
CA (Singapore), FCCA, ACTA, DACE
Jasmine Ng is a Fellow member of the Association of Chartered Certified Accountants (ACCA) and a member of the Institute of Singapore Chartered Accountants (ISCA). She has over 18 years of extensive experience in the area of audit, accounting, financial analysis, business controlling, enterprise system implementation and training. She travelled extensively during the course of her work and gain exposure to different culture and work style.
She utilizes her creativity and real-world examples in conducting her training. Jasmine is passionately fond of training and always willing to share with others all that she knows. Her outgoing, pleasant personality and confident disposition have made her training all the more lively, fun and insightful.