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
In any organization the budget is a central aspect of the planning and control systems utilized by the organization. Regardless of the organization’s size or complexity, or the product, the market or the service provided by the enterprise, a budget will always feature as a key aspect of financial planning.
This programme is dedicated to solving the problems managers face when preparing budgets and forecasts. It combines accounting, budgeting, and forecasting issues with Excel to provide accountants with practical guidance on how to prepare more accurate budgets and forecasts with less time and effort. By combining both traditional budgeting and forecasting concepts with the power and flexibility of Excel, participants are given the tools and techniques needed to meet the ever increasing demands of management, banks, regulators, and investors.
To enable participants to:
- Apply decision logic to building of complex budgetary model
- Use data functions for what-if analysis - data consolidation, data query, data tables, data import tricks
- Use Excel solver for linear programming
- Standardize spreadsheet design and review to make budgets and forecasts easier create and update
- Use custom views and report manager to automate the report preparation process
- Work with financial functions
- Understand the approach in the preparation of cash and capital budget using spreadsheets
- Apply spreadsheet techniques specific to building of a complete budgetary model.
Programme Outline
- Budgeting Overview
- Budgeting preparation
- Preparing the master budget
- Cash & capital budgeting
- Budgeting case discussions
- Forecasting Techniques
- Forecasting & corporate strategy
- Forecasting financial requirements
- Forecasting case discussions
- Application of Spreadsheet Techniques to Budgeting (I)
- Using decision logic and what-if analysis
- Format of cashflow budget
- Hands-on cash flow analysis case exercise
- Application of Spreadsheet Techniques to Budgeting (II)
- Using time series and regression analysis
- Using Excel solver for linear programming
- Hands-on sales forecasting case exercise
- Application of Spreadsheet Techniques to Budgeting (III)
- Capital budgeting techniques
- Working with financial functions
- Hands-on capital budgeting case exercise
- Application of Spreadsheet Techniques to Budgeting (IV)
- Standardizing spreadsheet design
- Constructing a profit-planning model
- Using simulation in cash budgeting
- Hands-on budgetary model case exercise
To view our full list of Infocomm courses, please click here. Training Methodology
Lecture style, with computer hands-on Exercises
Closing Date for Registration
1 week before programme or until full enrolment
Intended For
Professionals who prepare budgets and forecasts using Excel and want to save time, and do a better job. Users of Excel 2013 or any latest version are welcomed.
Competency Mapping
Category 5 = 14.00 Hours
Schedule & Fees
Date & Time
17 Oct 2024 (9:00 AM - 5:00 PM)
18 Oct 2024 (9:00 AM - 5:00 PM)
Fee (inclusive of GST)
For Members:
$ 756.46
For Non-Members:
$ 898.16
Programme Facilitator(s)
Dr Lim Thou Tin
Venue
60 Cecil Street
ISCA House
Singapore 049709
Testimonial
A very good eye opening learning experience. Learn a lot of relevant skill to support our works.
Lily Ong
Is a very powerful class. I learnt a lot of new excel tools which seldom apply in my workplace. I believe, the knowledge I learnt from the class will be useful to my working life in future.
Teng Leng Leng
Good learning journey for me as there were so many function and formulas being taught to us which can be applicable to our work. Since we are moving into digitalization, with the new learning skill, it will definitely help us to be more efficient in our work.
Lynn Loh Mei Ling
ISCA did a good job in organising the training, namely the venue, the facilities, selection of good trainers and applicability of training to our work. Dr Lim is one of the best excel trainers I have met and learnt from. I'll send my staff to learn for future Excel training courses with ISCA and Dr Lim.
Darren Ku
trainer is very knowledgeable on the function of the excel techniques and it is useful in daily work
Past Participant
I have gained a lot of knowledge and techniques in excel budgeting.
Past Participant
Funding
1] SkillsFuture Credit (SFC)
Funding Period: Until 31 Dec 2024
Course Reference Number: TGS-2020500276
All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. You may wish to use your SFC to pay for partial/full ISCA course fees.
On 1 Oct 2020, the Government provided a one-off SkillsFuture Credit Top-up of $500 for all eligible Singaporeans aged 25 or above by 31 Dec 2020. Singaporeans aged 40 to 60 by 31 Dec 2020 will also receive an Additional SkillsFuture Credit (Mid-Career Support) of $500 which can be used for courses under: (i) SGUnited Skills Programme, (ii) SGUnited Mid-Career Pathways Programme – Company Training, and (iii) Career Transition Programmes. This additional SFC (Mid-Career Support) is NOT applicable for use on ISCA courses. (For more information on the SFC scheme, please visit https://www.skillsfuture.gov.sg/)
If you wish to enrol for the course with SFC Funding, please proceed with the following steps:
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 $43.20 for any revision of invoice.
2] NTUC Union Training Assistance Programme (UTAP)
UTAP (Union Training Assistance Programme) is an individual skills upgrading account for NTUC members.
To find out more on the UTAP funding and support validity period please click here.
Should you have queries on the funding scheme, you can email to UTAP@e2i.com.sg or call NTUC Membership Hotline at 6213-8008
Programme Facilitator(s)
Dr Lim Thou Tin, DACE
Dr Lim Thou Tin is a business graduate with the National University of Singapore. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He has a doctor of business administration from Southern Cross University with current research interests in information systems and business modelling.
His 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 organizational initiatives/projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, China, India, Indonesia, and Thailand.
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
In any organization the budget is a central aspect of the planning and control systems utilized by the organization. Regardless of the organization’s size or complexity, or the product, the market or the service provided by the enterprise, a budget will always feature as a key aspect of financial planning.
This programme is dedicated to solving the problems managers face when preparing budgets and forecasts. It combines accounting, budgeting, and forecasting issues with Excel to provide accountants with practical guidance on how to prepare more accurate budgets and forecasts with less time and effort. By combining both traditional budgeting and forecasting concepts with the power and flexibility of Excel, participants are given the tools and techniques needed to meet the ever increasing demands of management, banks, regulators, and investors.
To enable participants to:
- Apply decision logic to building of complex budgetary model
- Use data functions for what-if analysis - data consolidation, data query, data tables, data import tricks
- Use Excel solver for linear programming
- Standardize spreadsheet design and review to make budgets and forecasts easier create and update
- Use custom views and report manager to automate the report preparation process
- Work with financial functions
- Understand the approach in the preparation of cash and capital budget using spreadsheets
- Apply spreadsheet techniques specific to building of a complete budgetary model.
Programme Outline
- Budgeting Overview
- Budgeting preparation
- Preparing the master budget
- Cash & capital budgeting
- Budgeting case discussions
- Forecasting Techniques
- Forecasting & corporate strategy
- Forecasting financial requirements
- Forecasting case discussions
- Application of Spreadsheet Techniques to Budgeting (I)
- Using decision logic and what-if analysis
- Format of cashflow budget
- Hands-on cash flow analysis case exercise
- Application of Spreadsheet Techniques to Budgeting (II)
- Using time series and regression analysis
- Using Excel solver for linear programming
- Hands-on sales forecasting case exercise
- Application of Spreadsheet Techniques to Budgeting (III)
- Capital budgeting techniques
- Working with financial functions
- Hands-on capital budgeting case exercise
- Application of Spreadsheet Techniques to Budgeting (IV)
- Standardizing spreadsheet design
- Constructing a profit-planning model
- Using simulation in cash budgeting
- Hands-on budgetary model case exercise
To view our full list of Infocomm courses, please click here. Training Methodology
Lecture style, with computer hands-on Exercises
Closing Date for Registration
1 week before programme or until full enrolment
Intended For
Professionals who prepare budgets and forecasts using Excel and want to save time, and do a better job. Users of Excel 2013 or any latest version are welcomed.
Competency Mapping
Category 5 = 14.00 Hours
Programme Facilitator(s)
Dr Lim Thou Tin, DACE
Dr Lim Thou Tin is a business graduate with the National University of Singapore. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He has a doctor of business administration from Southern Cross University with current research interests in information systems and business modelling.
His 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 organizational initiatives/projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, China, India, Indonesia, and Thailand.