TRAINING MICROSOFT EXCEL ADVANCED

PELATIHAN MICROSOFT EXCEL ADVANCED

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 MICROSOFT EXCEL ADVANCED :

pembahasan konsep materi dan latihan praktek.

Instructor

Prihandoko, S.Pd.

Jadwal Pelatihan Jakarta Training 2026 :

Batch 1 : 05-06 Januari 2026 | 19-20 Januari 2026 || Batch 2 : 02-03 Februari 2026 | 18-19 Februari 2026

Batch 3 : 05 – 06 Maret 2024 | 19 – 20 Maret 2024 || Batch 4 : 03 – 04 April 2024 | 23 – 24 April 2024

atch 5 : 07 – 08 Mei 2024 | 21 – 22 Mei 2024 || Batch 6 : 05 – 06 Juni 2024 | 25 – 26 Juni 2024

Batch 7 : 06-07 Juli 2026 | 20-21 Juli 2026 || Batch 8 : 03-04 Agustus 2026 | 19-20 Agustus 2026

Batch 9 : 07-08 September 2026 | 21-22 September 2026 || Batch 10 : 05-06 Oktober 2026 | 19-20 Oktober 2026

Batch 11 : 02-03 November 2026 | 16-17 November 2026 || Batch 12 : 07-08 Desember 2026 | 14-15 Desember 2026

–

Catatan:  Jadwal tersebut dapat disesuaikan dengan kebutuhan calon peserta.Training Afe Budget Migas Jakarta Fixed Running

Biaya dan Lokasi Pelatihan : Pelatihan Estimasi Biaya Proyek Afe Di Jakarta

Training Efe Project Pasti Jalan

• Yogyakarta, Hotel Dafam Malioboro
• Jakarta, Hotel Amaris Tendean
• Bandung, Hotel Golden Flower
• Bali, Hotel Ibis Kuta

Catatan :Biaya diatas belum termasuk akomodasi/penginapan.Training Estimasi Biaya Proyek Afe Jakarta Pasti Running

Investasi Pelatihan Jakarta Training: Pelatihan Efe Project Di Jakarta

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 di Jakarta Training: Training Afe Budget Preparation Skills Of Oil & Gas Projects Di Jakarta Murah

1. 1. Hotel
   2. Module / Handout
   3. FREE Flashdisk
   4. Sertifikat
   5. FREE Bag or bagpackers (Tas Training)
   6. Training Kit (Dokumentasi photo, Blocknote, ATK, etc)
   7. 2xCoffe Break & 1 Lunch, Dinner
   8. FREE Souvenir Exclusive
   9. Training room full AC and Multimedia

Technorati Tags: training afe budget preparation skills of oil & gas projects di jakarta,training afe budget migas di jakarta,training estimasi biaya proyek afe di jakarta,training efe project di jakarta,pelatihan afe budget preparation skills of oil & gas projects di jakarta