Course Detail(IT069C : Excel Budgeting Techniques)

SkillsFuture Credit, UTAP Funding

IT069C : Excel Budgeting Techniques

14.00 CPE Hours (Category 5)
Classroom

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

19 Apr 2024 (9:00 AM - 5:00 PM)
22 Apr 2024 (9:00 AM - 5:00 PM)

Registration is closed

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

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.


Upcoming Schedule

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