Course Detail(IT023C : Business Analysis and Planning: Using Excel What-If Analysis)

SDF Funding, SkillsFuture Credit

IT023C : Business Analysis and Planning: Using Excel What-If Analysis

7.00 CPE Hours (Others)
Classroom


Notice
 
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
 
You may opt to bring along your laptop if you wish to use Excel 2013.
 
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

Others = 7.00 Hours

Schedule & Fees

Date & Time

06 May 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 331.70
For Non-Members: $ 406.60

Programme Facilitator(s)

Jasmine Ng

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

22 Jul 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 331.70
For Non-Members: $ 406.60

Programme Facilitator(s)

Jasmine Ng

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

16 Sep 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 331.70
For Non-Members: $ 406.60

Programme Facilitator(s)

Jasmine Ng

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

03 Nov 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 331.70
For Non-Members: $ 406.60

Programme Facilitator(s)

Jasmine Ng

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

05 Feb 2020 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Jasmine Ng

Date & Time

02 Dec 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Jasmine Ng

Date & Time

09 Oct 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Jasmine Ng

Testimonial

Funding

1] SkillsFuture Credit (SFC)
Funding Period: Until 10 March 2020
Course Ref No.: CRS-N-0025759

All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. The credits will not expire and periodic top-ups will be provided by the government. SFC may be accumulated to pay for skills related course fees. You may wish to use your SFC to pay for partial/full ISCA course fees.  (For more information on the SFC scheme, please visit http://www.skillsfuture.sg/credit)

If you wish to enrol for the course with SFC Funding, please proceed with the following steps:

  • Step 1: Register for the course online via ISCA Portal. Upon adding to cart, the system will prompt a question “Do you wish to apply for SkillsFuture Credit?”, click “Yes” and input all required information. At the Cart page, please ensure that SFC funding is applied before clicking “Checkout”.
  • Step 2: After successful enrolment, please proceed to submit SFC claim on Skillsfuture Portal within 60 days before the course start date and obtain the necessary approval. Please submit SFC claim via SFC portal here: http://www.skillsfuture.sg/credit.

Failure to submit claim application and obtain necessary approval before the course start date will result in topping up of the SFC indicated for use. Please note that there will be an administrative fee of $42.80 for any revision of invoice.


2] WDA Training Grant - SDF Funding
This course is approved for SDF funding ($2 per training hour) for Company-sponsored participants only (Eligibility criteria apply). 

Funding Period: Until 10 March 2020
Funded Hours: 7 hours
Course Ref No.: CRS-N-0025759

If you wish to enrol participants with SDF Funding, please proceed with the following steps (For Corporate enrolments only) :

  • Step 1: Register for the course online via ISCA Portal. Upon adding to cart, the system will prompt a question “Do you wish to apply for WDA Funding?”, click Yes and input all required information. At the Cart page, please ensure that SDF funding is applied before clicking “Checkout”.
     
  • Step 2: After successful enrolment, please proceed to submit the Training Grant application via SkillsConnect Portal here: https://www.skillsconnect.gov.sg/

 

Employers of company-sponsored participants must submit training grant via SkillsConnect system to obtain training grant for course fees. You may submit the Training Grant application within the period from 30 days before the course start date to 30 days after course start date. Please note that there will be an administrative fee of $42.80 for any revision of invoice.

 

Eligibility Criteria:

  • Company must be registered or incorporated in Singapore and;
  • Applicant is taking the course for the first time.
  • Applicant must be employed, and is either Singapore Citizen or Permanent Resident of Singapore and;
  • Applicant must achieve at least 75% attendance, and pass all examinations /assessments and;
  • Applicant must be fully sponsored by the Company for all costs associated with the training and;
  • Payment has to be made via corporate means (e.g. corporate cheque, corporate GIRO, corporate credit card).

 

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
 
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
 
You may opt to bring along your laptop if you wish to use Excel 2013.
 
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

Others = 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.
 


Upcoming Schedule

Date & Time

06 May 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 331.70
For Non-Members: $ 406.60

Programme Facilitator(s)

Jasmine Ng

Venue

60 Cecil Street
ISCA House
Singapore 049709