Excel Complete

Materi pelatihan Excel paling lengkap, mulai dari level Basic – Intermediate dan Advanced.

MATERI:

Materi Excel Basic

1. Introduction to Microsoft Excel

  • Identify 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
  • Create 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.

FASILITAS

  1. Modul Kursus Digital.
  2. Sertifikat
  3. LCD Projector/LED TV diruang kelas.
  4. Fasilitas komputer: PC/Laptop untuk setiap peserta
  5. Ruang kelas full AC.
  6. Konsultasi.

Pilihan Hari Kursus

  • Senin & Rabu  (Jumat)
  • Selasa & Kamis  (Jumat)
  • Sabtu (Weekend Class)

Pilihan Jam Kursus

  • Pagi: 09.00 – 12.00
  • Siang: 12.00 – 15.00
  • Sore: 15-00 – 18.00
  • Malam: 18.00 – 21.00

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

  • Kelas Online
  • Group Perusahaan (Inhouse Training)
  • Diklat Instansi Pemerintah

INFO & PENDAFTARAN HUBUNGI CUSTOMER SERVICE KAMI: