TRAINING MICROSOFT EXCEL ADVANCED
Training Penanganan Data
Training Pengenalan Microsoft Excel
Materi Pelatihan Microsoft Excel Advanced
1. Data Handling
+ Entering and editing data
+ Data types
+ Entering and editing formulas
+ Absolute and relative call referencing
+ Formulas evaluation and editing
2. Working with a worksheet
+ Moving and copying data across sheets
+ Copy and paste (including paste special)
+ Copying formulas using Auto Fill
+ Formula anchoring
3. Working with functions
+ Basic structure of functions
+ SUMIFs, COUNTIFs and SUMPRODUCTs
+ IF and nested Ifs
+ Conditional Formatting
4. Data validation and creating drop down lists
+ VLOOKUP and HLOOKUP
+ INDEX and MATCH
+ Data table & sensitivity analysis
+ NPV and IRR
+ Time Value of money functions
+ Advanced Functions
+ Working with large data sets (sorting, sub totals, filtering, track changes
+ Pivot tables, slicer, dashboard
+ Goal Seek
+ Scenario
+ Chart, solver, sparklines
Metode Pelatihan: pembahasan konsep materi dan latihan praktek
Pembicara Pelatihan Microsoft Excel Advanced
Prihandoko, S.Pd.
Jadwal Pelatihan Galeri Training 2023 training microsoft excel advanced terbaru :
- Batch 1 : 7 – 8 Januari 2026
- Batch 2 : 11 – 12 Februari 2026
- Batch 3 : 4 – 5 Maret 2026
- Batch 4 : 8 – 9 April 2026
- Batch 5 : 6 – 7 Mei 2026
- Batch 6 : 10 – 11 Juni 2026
- Batch 7 : 8 – 9 Juli 2026
- Batch 8 : 5 – 6 Agustus 2026
- Batch 9 : 9 – 10 September 2026
- Batch 10 : 14 – 15 Oktober 2026
- Batch 11 : 4 – 5 November 2026
- Batch 12 : 2 – 3 Desember 2026
Catatan : Jadwal dapat menyesuaikan dengan kebutuhan anda dengan catatan kuota peserta minimum 2 (dua) peserta terpenuhi.
Biaya dan Lokasi training microsoft excel advanced terupdate :
Lokasi :
· 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.
Investasi training pengenalan microsoft excel murah :
Investasi pelatihan selama tiga hari tersebut menyesuaikan dengan jumlah peserta (on call). *Please feel free to contact us.
Apabila perusahaan membutuhkan paket in house training, anggaran investasi pelatihan dapat menyesuaikan dengan anggaran perusahaan.
Fasilitas training konsep pengolahan data murah :
1. FREE Airport pickup service (Gratis Antar jemput Hotel/Bandara)
2. FREE Akomodasi Peserta ke tempat pelatihan .
3. Module / Handout training penanganan data terupdate .
4. FREE Flashdisk .
5. Sertifikat training microsoft excel advanced terupdate .
6. FREE Bag or bagpackers (Tas Training) .
7. Training Kit (Dokumentasi photo, Blocknote, ATK, etc) training pengenalan microsoft excel terbaru .
8. 2xCoffe Break & 1 Lunch, Dinner.
9. Souvenir .