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 Training Pasti Jalan 2019: training excel vba (excel programming)
Jadwal Pelatihan trainingpastijalan Tahun 2024 :
- Batch 1 : 23 – 25 Januari 2024
- Batch 2 : 6 – 8 Februari 2024
- Batch 3 : 5 – 7 Maret 2024
- Batch 4 : 23 – 25 April 2024
- Batch 5 : 6 – 8 Mei 2024 || 20 – 22 Mei 2024
- Batch 6 : 11 – 13 Juni 2024
- Batch 7 : 16 – 18 Juli 2024
- Batch 8 : 20 – 22 Agustus 2024
- Batch 9 : 17 – 19 September 2024
- Batch 10 : 8 – 10 Oktober 2024 || 22 – 24 Oktober 2024
- Batch 11 : 5 – 7 November 2024 || 19 – 21 November 2024
- Batch 12 : 10 – 12 Desember 2024
21 sd 20 November 2019
Catatan : Jadwal dapat menyesuaikan dengan kebutuhan anda dengan catatan kuota peserta minimum 2 (dua) peserta terpenuhi. training excel vba (excel programming) terupdate
Biaya dan Lokasi Pelatihan : training excel vba (excel programming) terupdate
Lokasi : 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. training pengenalan excel vba terupdate
Investasi Pelatihan Training Pasti Jalan : training konsep excel vba mura
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 Training Pasti Jalan : training programing formula murah
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 .