Training IT

ADVANCE MICROSOFT EXCEL

ADVANCE MICROSOFT EXCEL

Bandung | 24 – 26 Juni 2019 | Rp 6.500.000/ peserta
Bandung | 29 – 31 Juli 2019 | Rp 6.500.000/ peserta 
Bandung | 26 – 28 Agustus 2019 | Rp 6.500.000/ peserta
Bandung | 23 – 25 September 2019 | Rp 6.500.000/ peserta

Jadwal Training 2019 Selanjutnya …

 

 

TRAINING OBJECTIVE 

The course will be aimed at fairly experienced Excel users whom need to learn more complex functions,nesting,data manipulation and automation using basic macros  to perform more complex functions,lists analysis, use What-If tools and who would like to start recording basic macros.

Expertise in

Excel Advanced Course Objectives: After the course, will be able to:

  1. Use Lookup & Informational Functions
  2. Create Pivot Tables
  3. Use What-If Tools
  4. Sharing and Tracking Workbooks
  5. Record Basic Macros

 

MATERI TRAINING ADVANCE MICROSOFT EXCEL

  • Introduction to Excel
  1. Overview of Work books and Worksheets
  2. Customizing and managing the new Excel interface
  3. Enhancing worksheets using Themes and Styles
  4. Working with Range,Smart tags and Intel liSense
  5. Organizing and managing Data using Tables
  • Formatting Worksheets
  1. Cell Formatting and Custom Formatting
  2. Dynamic effects using basic Conditional Formatting
  3. Advanced Conditional formatting
  • Working with Names
  1. Creating,editing and deleting a NameRange
  2. Scope ofa Name Range
  3. Implementing named rangesin formulas and functions
  • Working with Formulas and Referencing Techniques
  1. Nesting formulas and functions
  2. Cell Referencing and Addressing methods
  3. Overcoming cyclic redundancy using iterations
  • Setting  Validations  and  Criteria’s
  1. Validating data and customizing errors
  2. Creating and Modifying List Ranges
  3. Integrating dynamic lists with lookup functions and charts
  • Analyzing WorksheetData
  1. Sorting database on various constraints

 

INSTRUCTOR ADVANCE MICROSOFT EXCEL 

Hasan Balubita, S.Si, M.Kom.  and Team

Hasan Balubita, S.Si, M.Kom. adalah  seorang magister Komputer Program Rekayasa Sistem Informasi, kini beliau menjabat sebagai Dosen jurusan Teknologi Sistem Informasi di Politeknik Praktisi Bandung. Pendidikan non formal yang beliau tekuni di bidang IT adalah Web Master di ITB, Pelatihan Bahasa Pemrograman Java dll.Beliau sudah sering kali menjadi instruktur pelatihan untuk perusahaan-perusahaan di Indonesia lewat topic-topik training yang beliau kuasai, seperti : Filing Arsip Digital dan Document Control, Aplikasi MS Office, Database MS Access, Advance MS Excell, Pendataan Aset dan Pelaporan Aset dan lain-lain.

 

VENUE  ADVANCE MICROSOFT EXCEL

Bandung (Golden Flower, Banana Inn, Grand Seriti, Carrcadin, Amaroossa, Grand Serela, Gino Feruci, Verona Palace, Malaka, Zodiac Taurus)

 

ADVANCE MICROSOFT EXCEL  TRAINING DURATION

3 hari

 

TRAINING TIME 

  1. 24 Jun 2019-26 Jun 2019
  2. 29 Jul 2019-31 Jul 2019
  3. 26 Agust 2019-28 Agust 2019
  4. 23 Sep 2019-25 Sep 2019
  5. 28 Okt 2019-30 Okt 2019
  6. 25 Nop 2019-27 Nop 2019
  7. 16 Des 2019-18 Des 2019

 

INVESTATION PRICE/PERSON :

  1. Rp 6.500.000/person (full fare) or
  2. Rp 6.250.000/person (early bird, payment 1 week before training) or
  3. Rp 5.950.000/person (if there are 3 or more participants from the same company)

 

FACILITIES FOR PARTICIPANTS:

  1. Modul Training
  2. Flashdisk Training berisi materi training
  3. Sertifikat
  4. ATK: NoteBook dan Ballpoint
  5. T-Shirt
  6. Ransel
  7. Foto Training
  8. Ruang Training dengan fasilitas Full AC dan multimedia
  9. Makan siang dan 2 kali coffeebreak
  10. Instruktur yang Qualified
  11. Transportasi untuk peserta dari hotel penginapan ke hotel tempat training – PP (jika peserta minimal dari satu perusahaan ada 4 peserta)

 

Formulir Permintaaan Informasi Lanjutan / Pra-Pendaftaran Public Training
  1. INFORMATION OPTIONS
  2. (required)
  3. (required)
  4. PERSONAL DATA
  5. (required)
  6. (required)
  7. (required)
  8. (valid email required)
  9. (required)
  10. (required)
  11. PRE REGISTRATION DATA (Tidak Mengikat)
  12. (required)
  13. MESSAGE FOR TRAINING PROVIDER
 

cforms contact form by delicious:days

Post a Comment