PELATIHAN MICROSOFT EXCEL ADVANCED

PELATIHAN MICROSOFT EXCEL ADVANCED

TRAINING MICROSOFT EXCEL ADVANCED

PELATIHAN 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 2023 :

 

Batch 1 : 03 – 04 Januari 2024 | 16 – 17 Januari 2024 || Batch 2 : 06 – 07 Februari 2024 | 20 – 21 Februari 2024

Batch 2 : 4 – 6 April 2023

Batch 3 : 26 – 28 Juni 2023

Batch 4 : 14 – 16 Agustus 2023

Batch 5 : 10 – 12 Oktober 2023

Batch 6 : 5 – 7 Desember 2023

CatatanJadwal 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. 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