Confirm Running (1) Applied Finance For Non Finance Executive (2) Ms. Excel With BBA Macro

MARKSHARE Training We Provide Workshop & Training Call Us : Eby (Ms.) 08561044530 / 021 – 5793 2035 eby@marksharetraining.co.id / eby.markshare@gmail.com / ask@marksharetraining.co.id www.marksharetraining.co.id for unsubscribe, click here
“ Applied Finance For Non Finance Executive ” Hotel Aryaduta Semanggi, 02 - 03 Agustus 2018 “ Microsoft Excel 2010 / 2013 Implementation With Visual Basic Application (Vba Macro) “ Hotel Aryaduta Semanggi, 02 - 03 Agustus 2018 AGENDA TRAINING   Sesi 1 : Dasar-Dasar Keuangan Bagi Eksekutif Non Keuangan - Aspek Eksternal dan Internal. ·         Topik dalam perusahaan yang dipengaruhi isu keuangan. ·         Pentingnya laporan keuangan bagi stakeholders. ·         Manfaat informasi keuangan bagi internal dan eksternal dan metode pelaporannya. ·         Memahami value of company dari laporan keuangan.    Sesi 2 : Nilai Waktu Uang ·         Prinsip dasar nilai waktu uang ·         Perbandingan nilai masa lampau, sekarang, dan masa depan. ·         Perbandingan metode sederhana, bunga majemuk dan anuitas.    Sesi 3 : Proses dan Siklus Pembuatan Laporan Keuangan. ·         Dasar-dasar persamaan dan siklus akuntansi. ·         Pengenalan terhadap Pembukuan berpasangan (Double entry bookkeeping) ·         Penyusunan Laporan Keuangan (Neraca dan Laporan Laba/Rugi) ·         Pemahaman pembedaan pencatatan untuk Cash Basis dan Accrual Basis yang berpengaruh terhadap laporan pendapatan dan biaya perusahaan.    Sesi 4 & 5 : Analisa Laporan Keuangan dan Analisa Arus Kas ·         Analisa Laporan Keuangan: o   Common Size Financial Statements o   Percentage Change Statements o   Critical Financial Ratios: §  Analisa Rasio Profitabilitas. §  Analisa Rasio Likuiditas. §  Analisa Rasio Aktivitas. §  Analisa Rasio Solvabilitas. ·         Tips membaca dan menganalisa Neraca ·         Apa saja yang terdapat dalam laporan Arus Kas...? ·         Analisa arus kas operasional ·         Analisa arus kas investasi ·         Analisa arus kas pendanaan ·         Diskusi dan kasus.    Sesi 6 : Manajemen Modal Kerja. §  Modal Kerja sebagai alat Perencanaan Likuiditas & Profitabilitas. §  Kegiatan Operasional sebagai unsur Penentu Kebutuhan Modal Kerja. §  Keterlibatan seluruh Manajer dalam penentuan Modal Kerja. Sesi 7 : Metode Penilaian Investasi. §  Penggunaan metode payback period (waktu pulang pokok). §  Penggunaan metode net present value / NPV (Nilai Sekarang Bersih). §  Penggunaan metode Internal Rate of Return / IRR. §  Diskusi dan kasus. Sesi 8 : Pengukuran Kinerja terhadap Budget. §  ? Memahami & menggunakan teknik variance analysis. §  ? Teknik menganalisa production budget, sales budget, direct labour & factory overhead budget. §  ? Pemahaman terhadap cash budget dan pengendaliannya. §  ? Diskusi dan kasus.   AGENDA TRAINING 1.       Overview Of Excel Advance Formula and features ·         H/Vlookup , Dsum , SumIf, IF , Goal Seek, Conditional Formating , Data validation , Pivot Table ,Excel Protection, Case studies. 2.       Introduction To Macro & VBA Overview ·         Macro & VBA definition ·         Toolbars & VBE ·         Macro execution (record, store and run macro) ·         Basic versus VBA ·         Examining recoded macro code ·         Debugging tools ·         Object, Methods and Properties 3.       Referring To Ranges The range object ·         Select specify range ·         Referring cells in other sheet ·         Referring a relative range to another range ·         Using Properties 4.       Looping And Flow Control Using variables for statement ·         Using while . . . wend loop ·         The VBA loop: For . . .Each ·         Flow control If . . then . . else ·         Using Select Case 5.       Names Global versus Local names ·         Adding names ·         Deleting names ·         Type of names ·         Hiding names ·         Checking for the existence of a name 6.       Event Programming Level of events ·         Using events ·         Workbook events 7.       More with VBA Macro ·         Using Visual Basic Subroutines and Creating Functions ·         Creating Interactive Macros           ·         Using Macros to Format Cells        ·         Using Variables in Macros             ·         Creating If/Then/Else Routines                      ·         Adding Form Controls & Active X Control to Your Worksheets (Form, Listbox, Textbox, Buttons) ·         Optimizing Chart and Pivot Table using VBA Macro 8.       Handling Errors Basic error handling: on error go to ·         Generic error handlers ·         Customize error handlers 9.       Excel VBA Study Case ·         Building Automatic Excel Report Generator ·         Automatic Cash Flow Generator Untuk topic lainnya dan In house Training, silahkan sampaikan kebutuhan dan request anda dengan cara : >> [[ Klik Disini Untuk Request Inhouse ]] << improve the quality of human resources by Inhouse training, scale UP your Business !

Another Following Schedule :

 

NO	TANGGAL	JUDUL TRAINING	LOKASI
1	30-31 Juli	Creatice Cashflow & Treasury Management	Jakarta
2	30-31  Juli	Successfully Managing People	Jakarta
3	23 - 24 Juli	Project Management using Ms. Project Application	Jakarta
6	23 - 24 Juli	Human Resources Management Development Program (HRMDP)	Jakarta
10	23 - 24 Juli	Corporate Journalism	Jakarta
11	23 -24 Juli	Enterprise Risk Management	Jakarta
12	23 - 24 Juli	Effective Technical Report Writing	Jakarta
13	24 - 25 Juli	Effective General Affair Management	Jakarta
14	26 - 27 Juli	Bali : Refreshment & Personality Program For Secretary	Bali
15	26 - 27 Juli	Bali : Transformational Leadership	Bali
16	26 - 27 Juli	Budgeting Profit Planning & Cost Control	Jakarta
17	26 - 27 Juli	Workload Analysis Implementation With MS. Excel For HR & Non HR	Jakarta
18	26 - 27 Juli	Electronic Filing Management System	Jakarta
19	30 - 31 Juli	Effective Presentation Skill	Jakarta
20	30 - 31 Juli	Productivity & Effective Time Management	Jakarta
21	30 - 31 Juli	Personal Development & Generational Diversity In The Workplace	Jakarta
22	30 - 31 Juli	Public Relation Management	Jakarta

 

Agustus 2018

 

NO	TANGGAL	JUDUL TRAINING	LOKASI
1	1 - 2 Agustus	Behavioral Event Interview	Jakarta
2	02 - 03 Agustus	Applied Finance For Non Finance	Jakarta
3	02 - 03 Agustus	Ms. Excel VBA	Jakarta
4	8 - 9 Agustus	Advanced Secretary Development Program	Jakarta
5	7 - 8 Agustus	Best Practice Warehouse Operation Management	Jakarta
6	8 Agustus	Infographic Powerpoint	Jakarta
7	8 - 9 Agustus	Productivity & Effective Time Management	Jakarta
8	9 - 10 Agustus	Training Needs Analysis	Jakarta
9	13 - 14 Agustus	Basic Marketing & Customer Relationship Management	Jakarta
10	14  - 15 Agustus	Effective General Affair Management Development Program	Jakarta
11	15 - 16 Agustus	Succesfully Managing People	Bali
12	15 - 16 Agustus	Electronic Filing Management Development Program	Jakarta
13	20 - 21 Agustus	Procurement Negotiation & Contracting Strategy	Jakarta
14	20 - 21 Agustus	Metode Penyusunan Spesifikasi & Harga Perkiraan Sendiri	Jakarta
15	23 - 24 Agustus	Project Management Using Ms. Project Application	Jakarta
16	23 - 24 Agustus	Managing Difficult Customer & Handling Complaint Professionaly	Bandung
17	27 - 28 Agustus	Account Receivable & Collection Management	Jakarta
18	28 - 29  Agustus	Public Relation Management	Jakarta
19	29 - 30 Agustus	Effective Business Communication & Business Ettiquette	Jakarta
20	30 - 31 Agustus	Good Corporate Governance Implementation	Jakarta
21	30 - 31 Agustus	Business Development & Marketing Strategy	Jakarta