EXCEL: ADVANCE MICROSOFT EXCEL

Event

02 – 04 Januari 2017 | Rp. 5.950.000/peserta di Bandung
30 Januari – 01 Februari 2017 | Rp. 5.950.000/peserta di Bandung
20 – 22 Maret 2017 | Rp. 5.950.000/peserta di Bandung
03 – 05 April 2017 | Rp. 5.950.000/peserta di Bandung

Jadwal 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

 

CAKUPAN 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 :

Hotel Kagum Group 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. 02 Jan 2017-04 Jan 2017
  2. 30 Jan 2017-01 Feb 2017
  3. 20 Mar 2017-22 Mar 2017
  4. 03 Apr 2017-05 Apr 2017
  5. 22 May 2017-24 May 2017
  6. 19 Jun 2017-21 Jun 2017
  7. 03 Jul 2017-05 Jul 2017
  8. 14 Aug 2017-16 Aug 2017
  9. 04 Sep 2017-06 Sep 2017
  10. 02 Oct 2017-04 Oct 2017
  11. 20 Nov 2017-22 Nov 2017
  12. 27 Dec 2017-29 Dec 2017

 

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)

 

  ADVANCE MICROSOFT EXCEL 

Formulir Pra-Pendaftaran Public Training / Permintaan Informasi Lebih Lanjut
  1. JENIS INFORMASI/TRAINING
  2. (required)
  3. (required)
  4. DATA PRIBADI
  5. (required)
  6. (required)
  7. (required)
  8. (valid email required)
  9. (required)
  10. (required)
  11. DATA PRE REGISTRATION (Tidak Mengikat)
  12. (required)
  13. PESAN UNTUK PENYELENGGARA TRAINING
 

cforms contact form by delicious:days

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • TwitThis
  • Facebook
  • LinkedIn
  • Google Bookmarks
  • Y!GG
  • Digg
  • del.icio.us
  • StumbleUpon
  • Reddit
  • MySpace
  • Technorati
  • YahooMyWeb
  • YahooBuzz

Leave a Reply

Your email address will not be published. Required fields are marked *