MARKSHARE TRAINING
Call Us : 021 - 5793 2035 / 085890260140
d.sari131282@gmail.com/ sari@marksharetraining.co.id
| POWERFUL DATABASE ANALYSIS AND DASHBOARD REPORTING WITH EXCEL 2007/2010 26 – 27 April 2016 |
| OBJECTIVES Setelah mengikuti pelatihan ini peserta diharapkan mampu untuk : 1. Membaca dan memasukkan berbagai macam data : text file dan database yang lain yang jumlah record lebih dari 100.000 record ke dalam Excel 2007 2. Melakukan proses validasi data hasil konvert, baik untuk data text, date dan number. 3. Melakukan proses logical data dengan single IF dan multiple IF conditional function. 4. Melakukan quick filter dengan kombinasi gabungan key fields. 5. Melakukan custom filter dan Advance Filter (Query with Criteria). 6. Membuat tampilan dan formulasi dashboard reporting yang menarik dan dapat dijalankan secara interaktif oleh user. 7. Memanfaatkan fungsi-fungsi Excel untuk berbagai macam kebutuhan analisa database. 8. Mengaktifkan solver analysis tool pack dalam tab menu. 9. Menggunakan tool analisa database yang ada pada data analysis tool pack untuk kebutuhan analisa database yang cukup kompleks. 10. Menggunakan tool database analysis solver yang ada pada solver analysis tool pack. SYLLABUS 1. What’s New in Excel 2007 2. Read of Ribbon menu 3. Step by step operation for external data converting process to Excel database. 4. How make and using Quick Data Filter with create of fields combination union. 5. How make and using Custom Data Filter with filter by data type (number, text, date). 6. How make Advance Filter (Criteria and Output Data Query). 7. How make and using Conditional Formatting Process. 8. How make and using Consolidate Methods. 9. How make and using Single IF conditional and Multiple IF conditional function. 10. How make and using Data Validation. 11. How make and using Data Validation Automation with Table Function. 12. How make and using Data Table Method for one cell input and two cell input. 13. How make and using data analysis method (What If Analysis - Goal Seek and Scenario manager). 14. How make and using analysis function. 15. How make active and using solver analysis tool pack. 16. How make and using PivotTable 17. How make and using PivotChart 18. How make and design dashboard reporting 19. Case study implementation TRAINING INVEST : Rp. 3.750.000,-/person |
| Untuk pendaftaran atau informasi lebih lengkap, silahkan hubungi : Sdri. SARI Telp. : (021) 5793 2035 / 0858 9026 0140 E-mail : d.sari131282@gmail.com / sari@marksharetraining.co.id |
| If you no longer wish to receive message from us, click here to unsubscribe |
| NO | TANGGAL | JUDUL TRAINING | Keterangan | |
|
| ||||
| 1 | 03 Mei 2016 | Business Process Mapping | almost running | |
| 2 | 03 Mei 2016 | Customer Service Excellence | almost running | |
| 3 | 03 - 04 Mei 2016 | Corporate Journalism | Confirm Running | |
| 4 | 03 - 04 Mei 2016 | GA Development Program with data processing system | Confirm Running | |
| 5 | 10 - 11 Mei 2016 | Complaince & Risk Management | Confirm Running | |
| 6 | 10 - 11 Mei 2016 | Tata Kelola Kantor & Kearsipan | almost running | |
| 7 | 11 - 12 Mei 2016 | Cost Estimation in Procurement Management | almost running | |
| 8 | 11 - 12 Mei 2016 | Finance for Non Finance Executive | almost running | |
| 9 | 12 - 13 Mei 2016 | BALI : Effektif Negotiation & Lobbyinf Skill | almost running | |
| 10 | 12 - 13 Mei 2016 | BALI : Leadership & managerial skill | almost running | |
| 11 | 12 - 13 Mei 2016 | Metode penyusunan Harga Perkiraan Sendiri ( HPS ) | Confirm Running | |
| 12 | 16 - 17 Mei 2016 | Create Your Market Place " TOTAL SELLING " | Confirm Running | |
| 13 | 17 - 18 Mei 2016 | BANDUNG : Supply Chain Management | almost running | |
| 14 | 17 - 18 Mei 2016 | BANDUNG : Effektif Time Management | almost running | |
| 15 | 19 - 20 Mei 2016 | Contract management & tender in Procurement | almost running | |
| 16 | 19 - 20 Mei 2016 | Integrated Presentation Skill | almost running | |
| 17 | 19 - 20 Mei 2016 | Effektif Communication & Interpersonal Skill | almost running | |
| 18 | 24 - 25 Mei 2016 | The Getting Paid : Professional Debt Collection | Confirm Running | |
| 19 | 24 - 25 Mei 2016 | Pra Purna Bakti : Persiapan Masa Pensiun | almost running | |
| 20 | 25 -26 Mei 2016 | Advanced Ms. Excel | almost running | |
| 21 | 25 - 26 Mei 2016 | Coaching & Conseling | almost running | |
| 22 | 26 - 27 Mei 2016 | SURABAYA : Risk Based Internal Audit | Confirm Running | |
| 23 | 26 - 27 Mei 2016 | SURABAYA : Advanced Secretary Development Program | almost running | |
| 24 | 27 Mei 2016 | Infographic with Powerpoint | almost running | |
| 25 | 30 - 31 Mei 2016 | Talent Mapping & Pooling | almost running | |
| 26 | 30 - 31 Mei 2016 | Handling Complaint & Difficult Customer | almost running | |
|
|
|
|
| |
| For More Info & Registration Call Us : |
| |||
| 021 – 5793 2035 / 0858 9026 0140 ( SARI ) |
| |||
| d.sari131282@gmail.com / sari@marksharetraining.co.id |
| |||
Tidak ada komentar:
Posting Komentar