Nama Kursus
Advanced Microsoft Excel
| MIN. EDUKASI: | - |
| MAX. EDUKASI: | - |
| MIN. UMUR: | |
| MAX. UMUR: |
Jadwal Kursus
Tentang Kursus
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
Tanggal: 11-12 Desember 2018
Jam Pelaksanaan:
09.00 - 16.00 WIB
Tempat:
Graha Mustika Ratu Lt 6
Jln. Gatot Subroto Kav.74-75
Jakarta 12870
Lokasi:
Penyelenggara Kursus
C&G Training Network
Sejak berdiri pada tahun 2000, C&G Training Network bekerja dalam worldwide network, antara lain sebagai anggota Asean Training Network (ATN), American Society for Training Development, bekerjasama dengan Supply Chain Management Society – Asia, dan berafiliasi dengan TeachMe Teamwork, USA serta International Centre for Organizational Management – UK dan International Association of Administration Professionals – USA . Hal ini membuat kami mampu memberi materi pelatihan yang up to date dengan layanan maksimal dan biaya yang sangat reasonable.
Advanced Microsoft Excel
oleh C&G Training Network| KATEGORI | Data Science |
| KLASIFIKASI | Pelatihan |
| METODE | |
| DURASI | - hours |
| HARGA |
Rp3.200.000 |
Advanced Microsoft Excel
Rp3.200.000
| KATEGORI | Data Science |
| KLASIFIKASI | Pelatihan |
| METODE | |
| DURASI | - hours |
