TRAINING EXCEL VBA (EXCEL PROGRAMMING)

Training Pengenalan Excel Vba

Training Konsep Excel Vba

Pembicara / Fasilitator
Mr. Mugilen
I have a progressive experience approximately 15 years as IT trainer. Most of my experiences are in lecturing in colleges & Institutes of Higher Learning, conducting corporate trainings and develop training materials. Apart from training , I do involve in web & portal development for commercial.

Materi
Understanding programming in excel
• Started with macros
• Visual basic editor
• Working in the VBA

VBA Object-Oriented
• Variables, data types, and constants
• Objects and collections
• Working with ranges
• Making decisions with vba

WRITING YOUR OWN CODE
• Repeating actions with loops
• Programming formulas
• Working with arrays
• Automating procedures with worksheet events
• Automating procedures with workbook events
• Handling duplicate items and records
• Using embedded controls
• Programming charts
• User-defined functions
• Debugging your code

ADVANCED PROGRAMMING TECHNIQUES
• Creating userforms
• Userform controls and their functions
• Advanced userforms
• Class modules
• Data access with activex data objects
• Add-ins

Jadwal Pelatihan agendatraining Tahun 2023 :

• batch 1 : 24 – 26 Januari 2023
• batch 2 : 14 – 16 Februari 2023
• batch 3 : 20 – 23 Maret 2023
• batch 4 : 4 – 6 April 2023
• batch 5 : 15 – 17 Mei 2023
• batch 6 : 26 – 28 Juni 2023
• batch 7 : 17 – 19 Juli 2023
• batch 8 : 14 – 16 Agustus 2023
• batch 9 : 25 – 27 September 2023
• batch 10 : 10 – 12 Oktober 2023
• batch 11 : 7 – 9 November 2023
• batch 12 : 5 – 7 Desember 2023

Catatan : Jadwal dapat menyesuaikan dengan kebutuhan anda dengan catatan kuota peserta minimum 2 (dua) peserta terpenuhi. agenda pelatihan excel vba (excel programming)

Biaya dan Lokasi Pelatihan : agenda training pengenalan excel vba terbaru

Lokasi : agenda training konsep excel vba terbaru

· Jakarta : Hotel Amaris Kemang, Amaris Tendean,Trinity Hotel, Ibis Budget.

· Bandung : Hotel Santika, Hay Hotel,Ibis Style, Novotel Hotel, Golden Flower Hotel, 1O1 Hotel, Grand Tjokro Hotel, Tune Hotel, Four Point by Sheraton Hotel.

· Yogyakarta : Hotel NEO+ Awana, Cordela Hotel,Ibis Style, Boutique Hotel, Cavinton Hotel, Mutiara Hotel, Dafam Malioboro Hotel, Prima Inn Hotel .

· Surabaya : Novotel Hotel, Ibis Center Hotel, HARRIS Hotel, Favehotel, Alana Hotel .

· Malang : Amaris Hotel, The 1O1 Hotel, Ibis Style Hotel, El Hotel, Whiz Prime Hotel .

· Bali : Ibis Kuta, Fontana Hotel, HARRIS Hotel & Conventions .

· Lombok : Favehotel, Novotel Lombok, D Praya Hotel .

Catatan : Biaya diatas belum termasuk akomodasi/penginapan. agenda pelatihan pengenalan excel vba

Investasi Pelatihan Agenda Training : agenda training konsep excel vba

1. Investasi pelatihan selama tiga hari tersebut menyesuaikan dengan jumlah peserta (on call). *Please feel free to contact us.

2. Apabila perusahaan membutuhkan paket in house training, anggaran investasi pelatihan dapat menyesuaikan dengan anggaran perusahaan.

Fasilitas Pelatihan Agenda Training : agenda training programing formula

1. FREE Airport pickup service (Gratis Antar jemput Hotel/Bandara)

2. FREE Akomodasi Peserta ke tempat pelatihan .

3. Module / Handout

4. FREE Flashdisk .

5. Sertifikat

6. FREE Bag or bagpackers (Tas Training) .

7. Training Kit (Dokumentasi photo, Blocknote, ATK, etc)

8. 2xCoffe Break & 1 Lunch, Dinner.

9. Souvenir .