PILIHAN WAKTU
- WEEKDAY: Senin - Jum'at
PAGI : 09:00-12:00 WIB
SIANG: 13:00-16:00 WIB
MALAM: 18:00-21:00 WIB - WEEKEND: SABTU PAGI : 08:00-11:00 WIB
SIANG: 12:00-15:00 WIB
MALAM: 18:00-21:00 WIB
Materi pelatihan Excel paling lengkap, mulai dari level Basic – Intermediate dan Advanced.
MATERI:
Materi Excel Basic:
-
1. Introduction to Microsoft Excel
- the Elements of the Excel Interface
- Customize the Excel Interface
- Navigate and Select Cells in Worksheets
-
2. Excel Basic Functions
- Work with Cells (Numeric and Character)
- Work with Cells (Rows and Columns)
- Create and Modify Tables
- reate and Modify Sheets
-
3. Excel Functions
- Math Functions ( + , * , – , / )
- Statistical Functions
- Logical Functions and IF
- LOOKUP Functions
- Text Functions
- Date Functions
- Time Functions
-
4. Working with Charts
5. Modifying Chart Options
6. Formatting Charts
7. Printing
-
2. Materi Excel Intermediate & Advanced
1. Cells and range names static & dynamic
2. Working with Hyperlinks
3. Working with Multiple Worksheets & Workbooks
5. Index Match Functions
6. Filtering Data
7. Subtotal Function
8. Using Data Validation
9. Conditional Formatting
10. Consolidate Functions
11. Database Functions
12. Making Projections About Data
13. Creating and Managing Scenarios
14. Sparklines
15. Working with PivotTables & PivotCharts
16. PivotTable Data Model.
2. TATAP MUKA /Offline Class Room: tersedia di Kota Jakarta Timur
Fasilitas: 1. Modul
2. Sertifikat
3. Class Room Training : PC/Laptop, LCD Projector/LED TV
-
INFO PENDAFTARAN
- Jadwal kelas baru dibuka setiap bulan.
- Pendaftaran dibuka setiap hari Senin s/d Sabtu
- Sistem Pembayaran: Cash/Tunai, Transfer.
- Pilihan kelas: Reguler, Private, Weekend, Online Class.
-
Kursus ini juga tersedia untuk kelas:
- Inhouse Training (Group Perusahaan)
- Diklat Instansi Pemerintah
- Untuk permintaan Surat Penawaran > Hubungi Customer Service.
-
Berikut ini daftar lengkap materi Training Microsft Office di PRIVAKOM:
- Microsoft Office Professional
- Microsoft Excel Basic
- Microsoft Excel Intermediate
- Microsoft Excel Advanced
- Microsoft Excel Dashboard & Report
- Microsoft Excel Power BI
- Microsoft Excel VBA Macro
- Microsoft PowerPoint Basic
- Microsoft PowerPoint Advanced
PILIHAN KURSUS – MICROSOF OFFICE – Klik pada judul materi untuk melihat detail setiap materi:
PRIVAKOM Head Office Jakarta
Telp.0812 3450 7262

DAFTAR ONLINE

