Training Optimalisasi Metode Penganggaran dengan Ms. Excel
Optimalisasi Metode Penganggaran dengan Ms. Excel – terkait trik dan cara-cara yang efektif dan komprehensif guna memberikan metode yang tepat untuk optimalisasi metode penggagaran.
Deskripsi Pelatihan
Di dalam pelatihan ini peserta diberikan pemahaman secara komprehensif terkait Budgeting Cycle and Pro-forma Financial Statement,Planning Activities and Developing Budget Number,Budgeting Cycle,Output and report of Budgeting,Microsoft Excel – Spreadsheet,Basic Purpose Of A Spreadsheet Program,Various Components Of The Excel,Purpose And Usage Of Excel’s Built-In Functions And Macro Functions,Capital Budgeting,Relevant cash flows in capital budgeting, Calculating the after-tax cash flows used as inputs to the various decision making techniques, payback period, discounted payback, NPV, PI, IRR, and MIRR, Scenario analysis in Excel, Excel’s Solver to determine optimal capital budget under capital rationing, dll.
Materi Pelatihan
- Budgeting Cycle and Pro-forma Financial Statement
- Planning Activities and Developing Budget Number
- Budgeting Cycle
- Output and report of Budgeting
- Microsoft Excel – Spreadsheet
- Basic Purpose Of A Spreadsheet Program
- Various Components Of The Excel
- Purpose And Usage Of Excel’s Built-In Functions And Macro Functions
- Capital Budgeting
- Relevant cash flows in capital budgeting.
- Calculating the after-tax cash flows used as inputs to the various decision making techniques.
- payback period, discounted payback, NPV, PI, IRR, and MIRR
- Scenario analysis in Excel.
- Excel’s Solver to determine optimal capital budget under capital rationing
- Forecasting Techniques
- Percent of sales method is used to develop pro-forma
- Financial Statements , and how to construct such statements in Excel.
- TREND function for forecasting sales or any other trending variables.
- Regression analysis with Excel’s built-in regression tools.
- Optimizing Usage of Excel
- Workbook and Worksheet Tricks
- Data Analysis Tricks
- Chart Tricks
- Cash Budget With Excel
- Calculate total cash collections and disbursements
- Calculate expected ending cash balance and short-term borrowing needs.
- Determine the optimal timing of major cash expenditures.
- Developing Pro-forma Financial Statement
- Understanding Macro Function
- Developing Report
- Case Study
Tujuan dan Manfaat Pelatihan
Setelah mengikuti training ini, peserta diharapkan mampu untuk:
- Memahami budgeting cycle
- Mengetahui dan memahami teknik mengoptimalkan fasilitas yang terdapat dalam Excel
- Mengetahui dan memahami teknik pembuatan budget mulai dari cash budget, capital budget hingga membangun pro-forma financial statement
- Mengetahui dan memahami teknik menggunakan fasilitas makro, dan what if analysis (scenario dan goal seek)
- Mengetahui dan memahami teknik optimalisasi fasilitas excel dalam membuat report
- Mengetahui dan memahami aplikasi dalam menggunakan Excel Spreadsheet guna pembuatan budget, optimalisasi fasilitas excel yang sudah ada dan tekniknya.
Baca juga : https://takaartaguna.co.id/training-effective-inventory-control-warehousing-and-asset-management/
Jadwal dan Tempat Pelatihan
| Bulan | Minggu I
Bandung |
Minggu II
Jakarta |
Minggu III
Bandung |
MInggu IV
Yogyakarta |
Minggu V
Denpasar |
| Januari | 2-4 | 9-11 | 16-18 | 23-25 | 29-31 |
| Februari | 5-7 | 13-15 | 20-22 | 27-29 | |
| Maret | 5-7 | 12-14 | 19-21 | 26-28 | |
| April | 2-4 | 8-9 | 16-18 | 23-25 | 29-30 |
| Mei | 6-8 | 14-16 | 20-22 | 28-30 | |
| Juni | 4-6 | 11-13 | 18-20 | 25-27 | |
| Juli | 2-4 | 9-11 | 16-18 | 23-25 | 29-31 |
| Agustus | 6-8 | 13-15 | 20-22 | 27-29 | |
| September | 3-5 | 10-12 | 17-19 | 24-26 | |
| Oktober | 1-3 | 8-10 | 15-17 | 22-24 | 29-31 |
| November | 5-7 | 12-14 | 19-21 | 26-28 | |
| Desmber | 3-5 | 10-12 | 17-19 | 23-24 |
Harga Pelatihan
Offline
- Public Training mulai dari 5.000.000 – 7.000.000 perorang
- Inhouse Training mulai dari 850.000 perorang
Online
- Public Training mulai dari 1.200.000 perorang
- Inhouse Training mulai dari 600.000 perorang
Fasilitas Pelatihan
- Sertifikat pelatihan
- Expert Trainer
- Coffee Break 2x
- Lunch
- Tempat training: minimal hotel bintang 3
- Materi pelatihan dalam bentuk hard copy dan juga soft copy
- ATK
- Backpack exclusive
- Jaket eksklusif (souvenir)
- Dokumentasi
Instagram kami : https://www.instagram.com/takaartaguna/
Views: 2