IT

TRAINING MICROSOFT EXCEL ADVANCED

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 trainingpastijalan Tahun 2021 :

  • 19-20 Januari 2021
  • 16-17 Februari 2021
  • 16-17 Maret 2021
  • 20-21 April 2021
  • 18-19 Mei 2021
  • 15-16 Juni 2021
  • 20-21 Juli 2021
  • 17-18 Agustus 2021
  • 21-22 September 2021
  • 19-20 Oktober 2021
  • 16-17 November 2021 | 21-22 Desember 2021

Catatan : Jadwal dapat menyesuaikan dengan kebutuhan anda dengan catatan kuota peserta minimum 2 (dua) peserta terpenuhi. training microsoft excel advanced terupdate

Biaya dan Lokasi Pelatihan : training microsoft excel advanced terupdate

Lokasi : training pengenalan microsoft excel 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 penanganan data terupdate

Investasi Pelatihan Training Pasti Jalan : training pengenalan microsoft excel 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 Pasti Jalan : 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

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 .

Leave a Reply

Your email address will not be published. Required fields are marked *

Tanyakan pada kami ?

Kami di sini untuk membantu Anda! Jangan ragu untuk menanyakan apapun kepada kami. Klik di bawah untuk memulai obrolan.

Marketing

Dina

Online

Dina

Hai, tanyakan pada kami ? 00.00