MS. EXCEL IMPLEMENTATION WITH VISUAL BASIC (VBA) APPLICATION
Hotel Oria, Jakarta 14 – 15 Desember 2016 (Confirm Running)PROBLEM SOLVING & 
DECISION MAKING
Hotel Oria, 15 – 16 Desember 2016 (Confirm Running)
Call Us :
Eby (Ms.)
08561044530 / 021 – 57932035
e...@marksharetraining.co.id / esbb...@gmail.com
www.marksharetraining.co.id
if you no longer want to receive this emails, click here to unsubscribe
Materi Pelatihan :
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 GeneratorMateri Pelatihan :

1.        Konsep dasar effective problem solving & decision making
2.        Karakteristik Masalah dan Teknik Identifikasi Masalah
3.        Proses Problem Solving dan Decision Making
4.        Group creative problem solving and decision making model: 
Brainstorming, facilitation and mediation, dan process improvement
5.        Management Konflik dan Tipe Konflik dalam manajemen
6.        Hambatan organisasi dan pengelolaan lingkungan yang ‘kreatif’
7.        Psikologi Konflik bagaimana konflik terbentuk dan menular
8.        Kemampuan Mengelola Konflik dan Menjaga Pecapaian Kinerja Yang Baik.
9.        Seni Mempengaruhi dalam konteks kepemimpinan
10.     Teknik berfikir kreatif
11.     Role play dan study kasus



NOTANGGALJUDUL TRAINING
101 - 02 Desember 2016Good Corporate Governance (GCG) Implementation
205 - 06 Desember 2016Financial Statement Analysis (FSA)
305 - 06 Desember 2016Effective Negotiation & Lobyying Skills
407 - 08 Desember 2016Integrated Presentation Management
507 – 08 Desember 2016Powerfull Database Analysis & Dashboard Reporting Using 
Ms. Excel 2007/2010
607 - 08 Desember 2016Effective Shopfloor Leadership
707 - 08 Desember 2016Negotiation Power For Purchasing
814 - 15 Desember 2016Ms. Excel Implementation With VBA Application
914 - 15 Desember 2016Effective Office Management With Kaizen 5S & Filing System
1014 - 15 Desember 2016Problem Solving & Decision Making
1122 - 23 Desember 2016Advanced Secretary Development Program
1222 – 23 Desember 2016Memahami Letter of Credit (L/C) Export Import
1322 - 23 Desember 2016Metode Penyusunan Spesifikasi & Harga Perkiraan Sendiri
1427 - 28 Desember 2016Effective Sparepart Management
1527 - 28 Desember 2016Electronic Filing Implementation With RMS & EFS Method 
Based on Document Regulation
1627 - 28 Desember 2016Creative Thinking Training
1727 - 28 Desember 2016Accurate Inventory Planning & Stock Control

Reply via email to