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 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
–
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
- 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 Pelatihan di Jakarta Training: Training Afe Budget Preparation Skills Of Oil & Gas Projects Di Jakarta Murah
-
- Hotel
- Module / Handout
- FREE Flashdisk
- Sertifikat
- FREE Bag or bagpackers (Tas Training)
- Training Kit (Dokumentasi photo, Blocknote, ATK, etc)
- 2xCoffe Break & 1 Lunch, Dinner
- FREE Souvenir Exclusive
- 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