ADVANCED EXCEL

ADVANCED EXCEL

Bandung | 01 – 04 April 2019 | Rp 8.500.000/ peserta
Bandung | 20 – 23 Mei 2019 | Rp 8.500.000/ peserta
Bandung | 17 – 20 Juni 2019 | Rp 8.500.000/ peserta
Bandung | 08 – 11 Juli 2019 | Rp 8.500.000/ peserta

Jadwal Training 2019 Selanjutnya …

 

 

ADVANCED EXCEL TRAINING MATERIAL OUTLINE

1. Introduction to MS Excel and Understanding Basic Working with it
   1. Introduction to MS Excel,
   2. Quick Review on MS Excel Options,
   3. Ribbon,Worksheets and ToolbarDifference Between Excel 2003, 2007, 2010 and 2013
   4. Saving Excel File as CSV,
   5. Macro Enable Sheet, PDF and Older Versions
   6. Using Excel Shortcuts with FullList of Excel Shortcuts
   7. Copy, Cut, Paste, Hide, Unhide, Delete and Link the Data in Rows, Columns and Sheets
   8. Using Paste Special Options
   9. Formatting Cells, Rows, Columns and Sheets
   10. Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password
   11. Page Layout, Themes, Background and Printer Properties
   12. Inserting Pictures, Hyperlinks, Header/Footers, Shapes and Other Objects in Worksheets
2. Working with Formulas/Functions
   1. Lookup and Reference Functions:
   2. VLOOKUP, HLOOKUP,  INDEX, ADDRESS, MATCH, OFFSET, TRANSPOSE etc
   3. Logical Function:IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc
   4. Database Functions:DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP etc
   5. Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR,YEARFRAC, TIME, WEEKDAY, WORKDAY etc
   6. Information Functions:CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT,ISNUMBER, ISREF, ISTEXT, TYPE etc
   7. Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS etc
   8. Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK,COUNTIF,FORECAST, MAX, MAXA,MIN, MINA, STDEVA etc
   9. Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE,TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc
3. Conditional Formatting
   1. Using Conditional Formatting
   2. Using Conditional Formatting with Multiple Cell Rules
   3. Using Color Scales and Icon Sets in Conditional Formatting
   4. Creating New Rules and Managing Existing Rules
4. Data Sorting and Filtering
   1. Sorting Data by Values, Colors, etc
   2. Using Filters to Sort Data
   3. Advance Filtering Options
5. Pivot Tables
   1. Creating Pivot Tables
   2. Using Pivot Table Options
   3. Changing and Updating Data Range
   4. Formatting Pivot Table and Making Dynamic Pivot Tables
6. Pivot Charts
   1. Creating Pivot Charts
   2. Types of Pivot Charts and Their Usage
   3. Formatting Pivot Charts and Making Dynamic Pivot Charts
7. VBA Macro
   1. Introduction to VBA Macro
   2. Recording Macro & Understanding Code Behind
   3. Editing, Writing VBA Code and Saving as Macro or Add-In
   4. Adding Add-Ins in Excel
8. Case Study: Sales & Financial Reporting
   1. Creating Sales and Financial Reporting
   2. Sales & Financial Data Visualization using Dashboard
   3. Creating Custom Application for Sales and Reporting

 

RECOMMENDATION FOR PARTICIPANT: 

Participant must bring Laptop for practice sessions

 

INSTRUCTOR :    

Abdullah Fajar, S.Si.,M.Sc.

 

VENUE :

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

 

TRAINING DURATION :

4 days

 

JADWAL TRAINING 2019

• 01 Apr 2019-04 Apr 2019
• 20 Mei 2019-23 Mei 2019
• 17 Jun 2019-20 Jun 2019
• 08 Jul 2019-11 Jul 2019
• 19 Agust 2019-22 Agust 2019
• 16 Sep 2019-19 Sep 2019
• 07 Okt 2019-10 Okt 2019
• 18 Nop 2019-21 Nop 2019
• 09 Des 2019-12 Des 2019

 

INVESTATION PRICE/PERSON :

1. Rp. 8.500.000/peserta (bayar penuh)  atau
2. Rp. 8.250.000/peserta (early bird, yang membayar 1 minggu sebelum training)  atau
3. Rp. 7.950.000/peserta (peserta bergroup yang terdiri dari 3 peserta atau lebih dari 1 perusahaan yang sama)

 

FACILITIES FOR PARTICIPANTS:

1. Modul Training
2. Flash Disk 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. Judul Training(required)
3. Tanggal Training
4. Select a message type Registration Offering Letter (Permintaan Proposal Penawaran) Next Schedule Information (Jadwal selanjutnya) More Information (Informasi tambahan) Others (lain-lain) (required)
5. PERSONAL DATA
6. Your Name(required)
7. Job Title(required)
8. Company(required)
9. Company Address
10. Email(valid email required)
11. Mobile Phone(required)
12. Office Phone(required)
13. Extention No.
14. Facsimile (Fax)
15. Website
16. PRE REGISTRATION DATA (Tidak Mengikat)
17. Penanggung Jawab Training di Perusahaan
18. Email
19. Office Phone+Ext atau No. Handphone
20. Jumlah Peserta(required)
21. Nama-nama peserta
22. Payment Method Bank Transfers Submitting an Invoice Cheque or Cash on arrival ( If Possible)
23. MESSAGE FOR TRAINING PROVIDER
24. Pesan untuk penyelenggara Training
25. CC this registration / message to me
26. Isikan angka/huruf pada gambar

 

cforms contact form by delicious:days