By September 12, 2017 0 Comments Read More →

ADVANCE MICROSOFT EXCEL – Almost Running

ADVANCE MICROSOFT EXCEL 

Bandung | 28 – 29 September 2017 | Rp 5.950.000/person – ALMOST RUNNING
Bandung | 02 – 04 Oktober 2017 | Rp 5.950.000/person
Bandung | 20 – 22 November 2017 | Rp 5.950.000/person
Bandung | 27 – 29 Desember 2017 | Rp 5.950.000/person

 

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 :  

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:

Bandung (Golden Flower, Banana Inn, Serela, Gino Feruci), Amaroossa Hotel, Noor Hotel, Grand Setiabudi Hotel, dll

 

TRAINING DURATION :

3 hari

 

TRAINING TIME  :

  1. 02 Oct 2017-04 Oct 2017
  2. 20 Nov 2017-22 Nov 2017
  3. 27 Dec 2017-29 Dec 2017

 

 

INVESTMENT PRICE/PERSON:

  1. Rp 5.950.000/person (full fare) or
  2. Rp 5.750.000/person (early bird, payment 1 week before training) or
  3. Rp 5.500.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 MS Excel
  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