ADVANCED MICROSOFT EXCEL

in Computing Courses,Programming

Judul Program:

Advanced Microsoft Excel

 

Jenis Program:

In Class, In-house Training

 

Durasi Program:

2 hari training Pkl. 09.00 – 16.00 WIB

 

Perhari:

2x coffee break @ 15 menit dan 1x lunch break (1 jam)

 

Metode Pelatihan:

pembahasan konsep materi dan latihan praktek

 

Fasilitas

Disediakan oleh Client:

1. Training Venue
2. Konsumsi peserta & trainer (Per hari: 2x coffee break dan 1x lunch)
3. LCD projector, microphone, flipchart dan whiteboard

 

 

Estimasi Jumlah Peserta

10 orang

 

Estimasi Biaya Training

Rp. 16.000.000,-

 

Keterangan

  • Biaya tambahan peserta Rp. 1.500.000,-/orang
  • Biaya sudah termasuk handout, name plate, alat tulis, blocknote, tas training dan sertifikat
  • Biaya belum termasuk PPN 10%

 

MATERI TRAINING

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
• 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

4. Advanced Functions

• Working with large data sets (sorting, sub totals, filtering, track changes)
• Pivot tables, slicer, dashboard
• Goal Seek
• Scenario
• Chart, solver, sparklines

Jadwal Training Public

Formulir Permintaan Proposal In-House Training
  1. (required)
  2. (valid email required)
  3. Keterangan Perusahaan
  4. (required)
  5. (required)
  6. (required)
  7. Penanggung Jawab Training di Perusahaan
  8. (required)
  9. (required)
  10. (valid email required)
  11. (valid email required)
  12. (required)
  13. (required)
  14. (required)
  15. Kebutuhan Ringkas Tentang In House Training:
  16. (required)
  17. (required)
  18. (required)
  19. (required)
  20. (required)
  21. (required)
  22. (required)
  23. Apakah Anda ingin proposal pembanding untuk topik ini?
  24. Kami berhak mengabaikan permintaan proposal In-house Training bila data yang dikirimkan tidak lengkap / akurat.
  25. Pencantuman No. handphone sangat mempermudah kami menghubungi Anda.
  26. Pemakaian alamat email gratisan tidak kami sarankan
  27. Bila Anda kesulitan mengirim data Anda melalui formulir ini, silakan menghubungi kami di: 081382666322 atau 021-80280282 atau 021-8-555-222-0
 

cforms contact form by delicious:days

 

Leave a Comment

Copyright by Kreasi Training 2009
online counter
TopOfBlogs