TRAINING MICROSOFT EXCEL ADVANCED

4dm1n

TRAINING MICROSOFT EXCEL ADVANCED

Training Penanganan Data

Training Pengenalan Microsoft Excel

training penanganan data murah

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 trainingterbaru Tahun 2023 :

  • 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

Catatan : Jadwal dapat menyesuaikan dengan kebutuhan anda dengan catatan kuota peserta minimum 2 (dua) peserta terpenuhi. training accounting, taxation and auditing at coal for oil and gas industry terupdate

Biaya dan Lokasi Pelatihan : training accounting, taxation and auditing at coal for oil and gas industry terupdate

Lokasi : training akuntansi untuk migas 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 akuntansi pertambangan umum terupdate

Investasi Pelatihan Training Terbaru : training akuntansi untuk migas 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 Terbaru :

  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 .
Post Views: 5