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 2023
17 – 18 Januari 2023
14 – 15 Februari 2023
20 – 21 Maret 2023
4 – 5 April 2023
16 – 17 Mei 2023
20 – 21 Juni 2023
17 – 18 Juli 2023
15 – 16 Agustus 2023
25 – 26 September 2023
17 – 18 Oktober 2023
21 – 22 November 2023
27 – 28 Desember 2023
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