| MARKSHARE TRAINING PEOPLE DEVELOPMENT Telp. 021. 5793 2035 / 0858 9026 0140 ( SARI ) sari@marksharetraining.co.id / d.sari131282@gmail.com
|
| Microsoft Excel 2010/2013 Visual Basic for Application Hotel Oria Jakarta , 13 – 14 Oktober 2016
Deskripsi Microsoft® Excel Macro adalah fasilitas Excel yang dapat membuat pekerjaan menjadi lebih mudah untuk ditangani, di share, dan dibaca. Fungsi utama bahasa Macro untuk mengefesiensikan langkah dalam pembuatan report di MS Excel hingga cukup dengan satu klik saja atau dapat juga digunakan untuk tujuan otomatisasi lainnya. Macro ditunjang oleh VBA , Visual Basic Application (VBA) merupakan bahasa yang powerful untuk mempermudah proses kerja dari awalnya terdiri beberapa langkah menjadi cukup satu langkah saja. Sekarang Anda tidak lagi frustrasi dalam membuat dokumen, reports, kalkulasi dan juga project. Secara garis besar peserta dalam training Macro and VBA for Excel course akan belajar mengenai : 1. Pengenalan Konsep Macro and VBA 2. Record, Store and Run a Macro 3. Looping And Flow Control 4. Event Programming Handling Errors 5. Form Control & Active X Control 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 Full Fare : Rp. 4.500.000,-/Peserta Group ( 3 orang ) : Rp. 4.000.000/peserta
|
| Untuk pendaftaran atau informasi lebih lengkap, silahkan hubungi : Sdri. SARI Telp. 021.5793 2035 / 0858 9026 0140 E-mail : sari@marksharetraining.co.id / d.sari131282@gmail.com If you no longer wish to receive message from us, click here to unsubscribe
|
| NO | TANGGAL | JUDUL TRAINING | Keterangan | |
| 1 | 4- 5 Okt | Basic Accounting | almost running | |
| 2 | 6 - 7 Okt | Maintenance of Building | confirm running | |
| 3 | 5 - 6 Okt | Handling Complaint & Difficult Customer | confirm running | |
| 4 | 10 - 11 Okt | Recruitment & Selection System | almost running | |
| 5 | 10 - 11 Okt | Financial Statement Analyst ( FSA ) | confirm running | |
| 6 | 11 - 12 Okt | Strategi penerapan Compliance & risk management sektor keuangan non Bank | almost running | |
| 7 | 11 - 12 Okt | Corporate Journalism | confirm running | |
| 8 | 13 - 14 Okt | Advanced Selling skill for Maximum profit | almost running | |
| 9 | 13 - 14 Okt | Best practice Warehouse Management | confirm running | |
| 10 | 17 Okt | Business Process Mapping | almost running | |
| 11 | 17 - 18 Okt | General Affairs Development Program ( GA ) | almost running | |
| 12 | 19 Okt | Powerpoint Do More | confirm running | |
| 13 | 18 - 19 Okt | Finance for Finance Executive ( FINON ) | almost running | |
| 14 | 20 - 21 Okt | Effective Communication & Interpersonal Skill | confirm running | |
| 15 | 20 - 21 Okt | Profesional Secretary development Program | almost running | |
| 16 | 25 - 26 Okt | Technical Report Writing ( TRW ) | almost running | |
| 17 | 25 - 26 Okt | Negotiation for Purchasing | confirm running | |
| 18 | 26 - 27 Okt | new product Development ( NPD ) | almost running | |
| 19 | 27 - 28 Okt | Contract & tender management in Procurement | almost running | |
| Luar Kota |
| |||
| 1 | 6 - 7 Okt | Surabaya : Risk Based Internal Audit | confirm running | |
| 2 | 6 - 7 Okt | BALI : Training For Trainers ( TFT ) | almost running | |
| 3 | 6 - 7 Okt | Bandung : Effektif Time Management | almost running | |
| 4 | 13 - 14 Okt | Surabaya : Transisi Workshop ISO 9001 : 2015 | almost running | |
| 5 | 20 - 21 Okt | Surabaya : Risk Management berbasis ISO 31000 | almost running | |
| 6 | 20 - 21 Okt | Bandung :Total Quality Management ( TQM ) | almost running | |
| 7 | 20 - 21 Okt | Batam : Supervisory Skill | almost running | |
| 8 | 20 - 21 Okt | Bandung : Procurement & Supply chain managament | almost running | |
| 9 | 27 - 28 Okt | BALI : Leadership & managerial Skill | almost running | |
| 10 | 27 - 28 Okt | BALI : Talent management | almost running | |
| 11 | 27 - 28 Okt | BALI : Training Needs Analyst ( TNA ) | almost running | |
| 12 | 27 - 28 Okt | Surabaya : Presentation & negotiation Skill | almost running | |
| 12 | 27 - 28 Okt | Surabaya : problem Solving & Decision Making | almost running | |
| For More Info & Registration Call Us : |
| |||
| 021 – 5793 2035 / 0858 9026 0140 ( SARI ) | ||||
| d.sari131282@gmail.com / sari@marksharetraining.co.id | ||||
Tidak ada komentar:
Posting Komentar