Confirm Running : Microsoft Excel 2010 / 2013 with Visual Basic for Application ( VBA - Macro )

MARKSHARE Training We Provide Workshop & Training
Microsoft Excel 2010/2013 Visual Basic for Application  (VBA-Macro) Hotel Oria Jakarta , 30 – 31 Januari 2017 Call Us : SARI (Ms.) Mobile: 0858 9026 0140 Phone : 021 – 5793 2035 E-mail : sari@marksharetraining.co.id d.sari131282@gmail.com click here to unsubscribe
Tujuan Training   Ø  Dapat mengoptimalkan pekerjaan dengan Microsoft Excel Ø  Dapat menciptakan advanced report yang dinamis Ø  Membuat otomatisasi dalam pekerjaan di Excel Ø  Menyederhanakan perhitungan dan formula yang kompleks Ø  Menciptakan keamanan yang maksimal di excel Ø  Membuat function sendiri untuk memudahkan perhitungan dan melindungi kerahasiaan rumus Ø  Memaksimalkan grafik dengan VBA Macro   Prasyarat Ø  Memiliki skill dasar dan atau telah menggunakan MS. Excel   Materi Training Ø  Overview Of Excel Advance Formula and features ·         H/Vlookup , Dsum , SumIf, IF , Goal Seek, Conditional Formating , Data validation , Pivot Table ,Excel Protection, Case studies. Ø  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 Ø  Referring To Ranges The range object ·         Select specify range ·         Referring cells in other sheet ·         Referring a relative range to another range ·         Using Properties Ø  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 Ø  Names Global versus Local names ·         Adding names ·         Deleting names ·         Type of names ·         Hiding names ·         Checking for the existence of a name Ø  Event Programming Level of events ·         Using events ·         Workbook events Ø  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 Ø  Handling Errors Basic error handling: on error go to ·         Generic error handlers ·         Customize error handlers Ø  Excel VBA Study Case ·         Building Automatic Excel Report Generator ·         Automatic Cash Flow Generator Investasi Normal Rp. 4.500.000,-/peserta Grup 3 orang Rp. 4.000.000,- /peserta Limited Seat Available  Call us & Register Now 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 !
Click here to  Unsubscribe

 

NO TANGGAL JUDUL TRAINING Lokasi 1 17 - 18 Januari Contract & Tender Management in procurement Jakarta 2 19 - 20 Januari 2016 Leadership & Managerial Skill Jakarta 3 19 - 20 Januari 2016 Financial Statement Analysis Jakarta 4 23 - 24  Januari 2017 Effective Office Management With kaizen 5S & Filing System Jakarta 5 23 - 24  Januari 2017 Powerfull Database Analysis & Dashboard Reporting Using Ms. Excel 2007/2010 Jakarta 6 24 - 25 Januari 2017 Strategic Procurement Management Bandung 7 25 – 26 januari 2017 General Affairs Professional : Concept , Strategy & Implementation Jakarta 8 25 - 26 Januari 2017 Technic Communication & Negotiation Skills Jakarta 9 26 - 27 Januari 2017 Negotiation Power For Purchasing Jakarta 10 26 - 27 Januari 2017 Advanced Secretary Development Program Jakarta 11 26 - 27 Januari 2017 Integrated Presentation Skill Bandung 12 26 - 27 Januari 2017 Creative Analythical Thingking Bandung 13 30 - 31 Januari 2017 Basic Marketing & CRM Management Jakarta 14 30 - 31 Januari 2017 Best Practice Warehouse Management Jakarta 15 30 - 31 Januari 2017 Comprehensive Ms. Excel Training With Visual Basic Application (VBA) Jakarta

NO TANGGAL JUDUL TRAINING Lokasi 1 1 - 2 februari Certified Career & Talent Management Jakarta 2 2 - 3 Februari Risk Based Internal Audit Surabaya 3 6 - 7 Februari Communication & Interpersonal Skill Jakarta 4 7 - 8 Februari Best Practice Warehouse Management Jakarta 5 7 - 8 Februari Win - Win Negotiation Skill Jakarta 6 8 - 9 Februari Total Selling : Advanced Sales program Jakarta 7 8 - 9 Februari Training For Trainers ( TFT ) Jakarta 8 8 - 9 Februari Finance for Non Finance Executive Jakarta 9 9 - 10 Februari Technic Presentation Skill Surabaya 10 9 - 10 Februari Workload Analysis Implementation with Ms.Excel for HR & Non HR Jakarta 11 9 - 10 Februari Metode Penyusunan Spesifikasi & Harga Perkiraan Sendiri ( HPS / Owner Estimasi ) Jakarta 12 9 - 10 Februari Managing Difficult Customer & Handling Complaint Professionaly Jakarta 13 13 - 14 Februari Powerfull Database Analysis & Dashboard Reporting using Ms. Excel 2007 / 2010 Jakarta 14 13 - 14 Februari Good Corporate Governance ( GCG ) Implementation Jakarta 15 17-Feb Infographic Powerpoint Jakarta 16 20-Feb Creating Balancedscoredcard Step by Step Jakarta 17 21 - 22 Februari Clinic Essensial Excel for office data processing System Jakarta 18 21 - 22 Februari Business Ettiquette & Protokoler Jakarta 19 22 - 23 Februari Secretary Development Program Jakarta 20 22 - 23 februari Project Management using MS Project Jakarta 21 23 - 24 Februari Strategic Sourcing & vendor Management Bandung 22 23 - 24 Februari Total Quality Management ( TQM ) Bandung 23 23 - 24 Februari Comprehensive Supervisory Skill Jakarta 24 27 - 28 Februari How To Identify Training Need ( TNA ) Jakarta 25 27 - 28 Februari Technical Report Writing Jakarta For More Info & Registration Call Us :   021 – 5793 2035  / 0858 9026 0140 ( SARI ) d.sari131282@gmail.com / sari@marksharetraining.co.id