TRAINING ADVANCED MICROSOFT EXCEL
TRAINING CONDITIONAL FORMATTING
TRAINING DATA HANDLING
Data Handling
* Entering and editing data
* Data types
* Entering and editing formulas
* Absolute and relative call referencing
* Formulas evaluation and editing
Working with a worksheet
* Moving and copying data across sheets
* Copy and paste (including paste special)
* Copying formulas using Auto Fill
* Formula anchoring
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
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:
Prihandoko, S.Pd.
JADWAL TRAINING TAHUN 2026
03 – 04 Januari 2026 | 16 – 17 Januari 2026
06 – 07 Februari 2026 | 20 – 21 Februari 2026
05 – 06 Maret 2026 | 19 – 20 Maret 2026
03 – 04 April 2026 | 23 – 24 April 2026
07 – 08 Mei 2026 | 21 – 22 Mei 2026
05 – 06 Juni 2026 | 25 – 26 Juni 2026
09 – 10 Juli 2026 | 23 – 24 Juli 2026
06 – 07 Agustus 2026 | 20 – 21 Agustus 2026
04 – 05 September 2026 | 18 – 19 September 2026
08 – 09 Oktober 2026 | 22 – 23 Oktober 2026
06 – 07 November 2026 | 26 – 27 November 2026
04 – 05 Desember 2026 | 18 – 19 Desember 2026
Metode Training
- Tatap Muka/offline
- Online via zoom
Kota Penyelenggaraan jika offline :
- Bandung
- Jogjakarta
- Surabaya
- Jakarta
fasilitas yang didapatkan
- Training Kit Eksklusif
- Tas
- Name Tag
- Modul
- Flash disk
- Ballpoint
- Block Note
- Souvenir
- Harga yang Reliable
- Trainer Kompeten di bidangnya
- Pelayanan Maksimal untuk peserta
- Penjemputan dari dan ke bandara
Investasi :
Public training : Rp. 4.500.000 (minimum 3 pax)
In House Training : on Call