EXCEL: ADVANCE MICROSOFT EXCEL

EVENT

06 – 08 April 2020 | Rp 6.500.000/ peserta di Bandung
18 – 20 Mei 2020 | Rp 6.500.000/ peserta di Bandung
08 – 10 Juni 2020 | Rp 6.500.000/ peserta di Bandung

Jadwal Training 2020 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

JADWAL TRAINING 2020

1. 06 Apr 2020-08 Apr 2020
2. 18 Mei 2020-20 Mei 2020
3. 08 Jun 2020-10 Jun 2020
4. 06 Jul 2020-08 Jul 2020
5. 10 Agust 2020-12 Agust 2020
6. 07 Sep 2020-09 Sep 2020
7. 12 Okt 2020-14 Okt 2020
8. 09 Nop 2020-11 Nop 2020
9. 07 Des 2020-09 Des 2020

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)

 ADVANCE MICROSOFT EXCEL

cforms contact form by delicious:days