TRAINING ONLINE MICROSOFT EXCEL ADVANCED

TRAINING ONLINE MICROSOFT EXCEL ADVANCED

TRAINING WEBINAR DATA HANDLING

TRAINING EXCEL ADVANCED UNTUK PRAKERJA

1. Data Handling pelatihan Microsoft Excel online

·    Entering and editing data
·    Data types
·    Entering and editing formulas
·    Absolute and relative call referencing
·    Formulas evaluation and editing
2. Working with a worksheet training Data Handling offline

·     Moving and copying data across sheets
·    Copy and paste (including paste special)
·    Copying formulas using Auto Fill
·    Formula anchoring
3. Working with functions training Microsoft Excel offline

·     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
  Metode Pelatihan: pembahasan konsep materi dan latihan praktek

Jadwal Pelatihan sinaran-training tahun 2023

Batch 1 : 18 – 19 Januari 2023

Batch 2 : 8 – 9 Februari 2023

Batch 3 : 15 – 16 Maret 2023

Batch 4 : 19 – 20 April 2023

Batch 5 : 16 – 17 Mei 2023

Batch 6 : 13 – 14 Juni 2023

Batch 7 : 12 – 13 Juli 2023

Batch 8 : 9 – 10 Agustus 2023

Batch 9 : 13 – 14 September 2023

Batch 10 : 11 – 12 Oktober 2023

Batch 11 : 15 – 16 November 2023

Batch 12 : 13 – 14 Desember 2023

Jadwal tersebut dapat disesuaikan dengan kebutuhan calon peserta

Lokasi Pelatihan Tahun 2023

Yogyakarta, Hotel Dafam Seturan(7.300.000 IDR / participant)

Jakarta, Hotel Amaris Tendean (7.900.000 IDR / participant)

Bandung, Hotel Golden Flower (7.800.000 IDR / participant)

Bali, Hotel Ibis Kuta (8.500.000 IDR / participant)

Lombok, Hotel Jayakarta (8.750.000 IDR / participant)

Catatan

• Waktu pelatihan Dua+1* hari dengan Biaya tersedia untuk Perorangan, Group, dan Inhouse Training, belum termasuk akomodasi/penginapan.
• Untuk biaya dan jadwal training harap menghubungi marketing kembali

Investasi training

Investasi pelatihan selama dua 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 training:

Free Penjemputan dari bandara ke hotel*.

Modul / Handout.

Flashdisk*.

Certificate of attendance.

FREE Bag or bagpacker.