By July 24, 2018 0 Comments Read More →

ADVANCE MICROSOFT EXCEL

 ADVANCE MICROSOFT EXCEL 

Bandung | 06 – 08 Agustus 2018 | Rp 5.950.000/ peserta
Bandung | 17 – 19 September 2018 | Rp 5.950.000/ peserta
Bandung | 22 – 24 Oktober 2018 | Rp 5.950.000/ peserta 
Bandung | 19 – 21 November 2018 | Rp 5.950.000/ peserta 

Jadwal Training 2018 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)

 

TRAINING DURATION  ADVANCE MICROSOFT EXCEL 

3 hari

 

TRAINING TIME 

  1. 16 Jul 2018-18 Jul 2018
  2. 06 Aug 2018-08 Aug 2018
  3. 17 Sep 2018-19 Sep 2018
  4. 22 Oct 2018-24 Oct 2018
  5. 19 Nov 2018-21 Nov 2018
  6. 26 Dec 2018-28 Dec 2018

 

INVESTATION PRICE/PERSON

  1. Rp 5.950.000/peserta (bayar penuh)  atau
  2. Rp 5.750.000/peserta (early bird, yang membayar 1 minggu sebelum training) atau
  3. Rp 5.500.000/peserta (grup, untuk 3 peserta atau lebih dari 1 perusahaan yang sama)

 

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

About the Author:

http://www.twitter.com/avisdjamal

Post a Comment