Jadwal Training Pelatihan Diklat Bimtek Seminar Workshop 2020

Spreadsheet Skills for Planning, Forecasting and Budgeting Training

TCI Training provides a training in Spreadsheet Skills for Planning, Forecasting and Budgeting in Finance , Accounting and Budgeting

Intorduction

This hands-on, practical course will demonstrate how you can develop spreadsheet models to create a forecast, which can then be utilised to generate business plans and operating budgets with the use Excel® as it is used in practice. The applications will be focused on three crucial aspects of business and financial management – strategic planning, intelligent forecasting and realistic budgeting. Delegates will learn how accessible the power of Excel® is to provide realistic forecasts and prepare flexible budgets. The impact on efficiency in planning and control and therefore return on investment for companies and/or divisions will be startling.

This course will feature:

  • Mastery of the power of Excel®
  • What functions to use from the Excel toolkit
  • Principles of strategic planning and budgeting
  • Mathematical forecasting models will be demystified
  • Building financial models enabling “what if” analysis

Objectives

  • Navigate through the features and functions of Excel®
  • Distinguish between data and output in spreadsheet architecture
  • Analyze financial statements in order to plan ahead
  • Build effective financial planning models
  • Use forecasting techniques for budget preparation

Content

 

Introduction to Spreadsheets using Excel®

  • The power of Excel® for building financial models
  • The Ribbons of Excel with their commands and functions
  • Using formulae: Copying, anchoring and special pasting
  • Using functions: financial, statistical and mathematical
  • Review of the financial objectives of business: ROI, ROA, ROE
  • Overview of Financial Statements

Proper Planning

  • Classical strategic planning models
  • Cost-Volume-Profit Analysis and Break-Even as a planning example
  • Economic Order Quantity as a planning example
  • What-if analysis to build scenario’s and test sensitivity
  • Maximizing and optimizing techniques
  • Linear programming and Solver as optimising tools

Fantastic Forecasting

  • Forecasting in perspective – the Past vs. the Future
  • Necessity to apply a range of different forecasting methods:
  • Qualitative Models used in forecasting
  • Quantitative Models focussing on time series and regressions methodology
  • Forecasting growth rates
  • Recording, applying and modifying forecast assumptions

 

Beyond Budgeting

  • The budget process: Timing and Cycles
  • Setting budgeting objectives and tolerance levels
  • Budgeting Techniques
  • “Beyond Budgeting” compared to traditional budgeting principles
  • Operating and Capital budgets
  • Monthly reporting procedures and timely action

 

Putting it together – building the comprehensive model

  • Considering the financing mix in strategy
  • Considering the Return to Shareholder as the primary indicator
  • Build your planning model
  • Build your forecasting model
  • Build your budgeting model
  • Link these together in review

Investasi dan Fasilitas Training

  • Harga : (dilampirkan dalam Brosur penawaran)
  • Fasilitas : Certificate, Training kits, USB 8 GB, Lunch, Coffe Break, Souvenir, City Tour
  • Untuk peserta luar kota disediakan transportasi antar-jemput dari Bandara/Stasiun ke Hotel (berlaku bagi perusahaan yang mengirimkan minimal 2 peserta)
  • Quota minimum Running 2 peserta ( jogja ), 3 Peserta ( Solo, Semarang) Quota minimum Running 3 peserta (Jakarta , Bandung dan Surabaya ) –  ( Untuk Manado, Bali , Batam, Pontianak, Balikpapan dan Lombok Quota minimal 4 peserta)

 

Permintaan Brosur penawaran Training ( Waktu dan Tempat) silahkan Menghubungi kami via :

Mobile : 0823 2326 5005 – 0857 2459 5005

Email : trainingcenterindo@gmail.com / info@jadwaltraining.co.id

Blog : https://informasitrainingdanseminar.wordpress.com

Web: www.informasitraining-indonesia.com

Web www.jadwaltraining.co.id

Jadwal training 2015 | Jadwal training 2016 | Jadwal training 2017 | Jadwal training 2018 | Jadwal training 2019 | Jadwal training 2020

Jadwal training 2015 (Bisa request tanggal selain yang tertera)

07-09 Juli 2015 / 28-30 Juli 2015/ 25-27 Agustus 2015 / 15-17 September 2015 / 27-29 Oktober 2015 / 08-10 November 2015 / 07-09 Desember 2015

Jadwal Training 2016  (Bisa request tanggal selain yang tertera)

19-21 Januari 2016 / 09-11 Februari 2016 / 15-17 Maret 2016 / 05-07 April 2016 / 10-12 Mei 2016 / 07-09 Juni 2016 / 12-14 Juli 2016 / 09-11 Agustus 2016 / 06-08 September 2016 / 11-13 Oktober 2016 / 15-17 November 2016 / 13-15 Desember 2016

Jadwal Training 2017  (Bisa request tanggal selain yang tertera)

17-19 Januari 2017 / 07-09 Februari 2016 / 21-23 Maret 2017 / 11-13 April 2017 / 09-11 Mei 2017 / 06-08 Juni 2017 / 04-06 Juli 2017 / 01-03 Agustus 2017 / 05-07 September 2017 / 17-19 Oktober 2017 / 06-08 November 2017 / 05-07 Desember 2017

Jadwal Training 2018  (Bisa request tanggal selain yang tertera)

23-25 Januari 2018 / 20-22 Februari 2018 / 13-15 Maret 2018 / 10-12 April 2018 / 08-10 Mei 2018 / 05-07 Juni 2018 / 03-05 Juli 2018 / 07-09 Agustus 2018 / 04-06 September 2018 / 02-04 Oktober 2018 / 06-08 November 2018 / 04-06 Desember 2018

Jadwal Training 2019  (Bisa request tanggal selain yang tertera)

22-24 Januari 2019 / 19-21 Februari 2019 / 05-07 Maret 2019 / 09-11 April 2019 / 07-09 Mei 2019 / 04-06 Juni 2019 / 09-11 Juli 2019 / 06-08 Agustus 2019 / 10-12 September 2019 / 08-10 Oktober 2019 / 05-07 November 2019 / 03-05 Desember 2019

Jadwal Training 2020  (Bisa request tanggal selain yang tertera)

28-30 Januari 2020 / 25-27 Februari 2020 / 17-19 Maret 2020 / 14-16 April 2020 / 05-07 Mei 2020 / 09-11 Juni 2020 / 07-09 Juli 2020 / 04-06 Agustus 2020 / 08-10 September 2020 / 06-08 Oktober 2020 / 10-12 November 2020 / 01-03 Desember 2020

Lokasi Training Pilihan : di Yogyakarta, Jakarta, Bandung, Bogor, Surabaya, Malang, Bali, Lombok, Balikpapan, Makassar, Medan, Batam, Riau, Pontianak, Semarang, Solo, Manado. (dengan harga dan minimal kuota yang berbeda)