Public Course : Risk Based Internal Audit ; Powerful database Analysis Dashboard Reporting with Ms. Excel

	MARKSHARE Training We Provide Workshop & Training Call Us : Elizia (Ms) 0821 2256 4094 / 021- 57932035 elizia@marksharetraining.co.id / laurenciaelizia@gmail.com www.marksharetraining.co.id
	Yth, Bapak / Ibu HRD Manager Training & Development Manager kami Markshare Training , ingin menginformasikan bahwa kami akan menyelenggarakan training sebagai berikut : Risk Based Internal Audit Jakarta, 7 – 8 MEI 2018 Powerfull Database Analysis & Dashboard Reporting with Ms. Excel 2007/2010   Jakarta, 25 – 26 April 2018 Outline :                                                                     1.     STANDAR PROFESI AUDIT INTERNAL 2.     INTERNAL AUDIT CHARTER 3.     INTRODUCTION TO INTERNAL AUDITING (SEJARAH, PERKEMBANGAN, DAN GAMBARAN UMUM AUDIT INTERNAL) 4.     TEKNIK-TEKNIK AUDIT INTERNAL (CONTROL) 5.     PENILAIAN RISIKO (RISK ASSESSMENT) 6.     SURVEI PENDAHULUAN (PRELIMINARY AUDIT SURVEY) 7.     PROGRAM AUDIT (AUDIT PROGRAM) 8.     PEKERJAAN LAPANGAN (AUDIT FIELD WORK) I 9.     PEKERJAAN LAPANGAN (AUDIT FIELD WORK)  II 10.           AUDIT SISTEM  INFORMATIKA (INFORMATION     SYSTEM AUDIT) 11.           TEMUAN AUDIT (AUDIT FINDINGS) 12.           DOKUMENTASI KERTAS KERJA AUDIT (AUDIT WORKING PAPERS) 13.           LAPORAN HASIL AUDIT (AUDIT REPORT) 14.           STUDI KASUS OPERATIONAL AUDITING Outline : 1.       What’s New in Excel 2007/2010 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       Untuk topic lainnya dan In house Training, silahkan sampaikan kebutuhan dan request anda dengan cara : >> [[ Klik Disini Untuk Request Inhouse ]] << improve the quality of human resources by Inhouse training, scale UP your Business ! Call Us : Elizia (Ms) 0821 2256 4094 / 021- 57932035 elizia@marksharetraining.co.id / laurenciaelizia@gmail.com www.marksharetraining.co.id
	click here for unsubscribed
		JADWAL PUBLIC CLASS APRIL 2018

 

NO	TANGGAL	JUDUL TRAINING	LOKASI
1	16–17 April	Basic HR Management	Jakarta
2	17 - 18 April	The 7 Steps Selling Steps for Sales People	Jakarta
3	19- 20 April	Advanced Secretary Development Program	Jakarta
4	19 – 20April	Integrated Procurement Management	Jakarta
5	19 - 20 April	Public Speaking & Presentation Skills	Jakarta
6	19 - 20 April	Enterprise Risk Management	Jakarta
7	19 - 20 April	Successfully Managing People " An Essential Leadership & Managerial Skills"	Jakarta
8	23 - 24 April	Metode Penyusunan Spesifikasi & HPS	Jakarta
9	23 - 24 April	Leadership For Sales ; Lead Well Sell Better	jakarta
10	23 - 24 April	Persiapan Masa Pensiun	Jakarta
11	23 - 24 April	Comprehensive Basic Accounting For Executive	jakarta
12	23 –24 April	Humas & Protokoler	Jakarta
13	23 –24 April	Strategic Vendor Management	Jakarta
14	24 - 25 April	Corporate Journalism ; How to Treat Corporate Website, Magazine & Media Handling	Jakarta
15	24 - 25 April	Finance For Non Finance	Jakarta
16	24 - 25 April	Career & Talent Management	Jakarta
17	25 -26 April	Powerfull Database Analysis & Dashboard Reporting with ms. Excel 2007 / 2010	Jakarta
18	25 – 26April	Training For Trainers	Jakarta
19	26 - 27 April	Logical Thinking & Problem Solving	Jakarta
20	26 - 27 April	Contract & Tender in Procurement	Jakarta
21	26 – 27April	Effective Supervisory Skill	Jakarta
22	26 - 27 April	General Affairs Management Development Program	Jakarta
23	26 - 27 April	SMART Interview	Jakarta
24	26 - 27 April	Creative Cashflow & Treasury Management	Jakarta
25	26 - 27 April	Project Management Using Ms. Project Application	Jakarta
26	26 - 27 April	Comprehensive Industrial Relation	Jakarta
27	26 - 27 April	Workload Analysis Implementation with EXCEL 2007 FOR HR & NON HR	Jakarta

 

NO	TANGGAL	JUDUL TRAINING
1	3 - 4 Mei	Discovering Effective Financial Statement Analysis
2	3 - 4 Mei	Extraordinary Journalisme for Corporate Website
3	3 - 4 Mei	Effective Practical Business Communication
4	7 - 8 Mei	Risk Based Internal Audit
5	8 - 9 Mei	Powerfull Database Analysis & Dashboard Reporting with Ms. Excel 2007/2010
6	8 - 9 Mei	Business Process Modeling Implementation With BPMN Tools
7	8 - 9 Mei	Enterprise Risk Management
8	14-15Mei	Cost Accounting - Best Practice
9	14-15Mei	Effective Office Management With Kaizen 5S & Filing System
10	14-15Mei	General Affair Management Development Program
11	14-15Mei	Public Speaking & Presentation Skills
12	15-16Mei	Metode Penyusunan Spesifikasi & HPS
13	15-16Mei	Effective Negotiation & Lobbying Skills
14	15-16Mei	Transformational Leadership & Managerial Skill
15	17-18Mei	Strategic Sourcing & Vendor Management
16	17-18Mei	Project Management Using Ms. Project Application
17	17-18Mei	Logical & Creative Problem Solving
18	17-18Mei	Creative Cashflow & Treasury Management
19	21-22Mei	EffectiveWarehouse & Inventory Management
20	21-22Mei	Productivity & Effective Time Management
21	21-22Mei	Electronic Filling System Implementation Based on Doc. Regulation & RMS-EFS With Excel 2007/2010/2013/2015/2016
22	21-22Mei	Integrated Procurement Management
23	21-22Mei	Negotiation Power For Purchasing
24	21-22Mei	The 7 Selling Steps Total Selling Basic
25	23-24Mei	Comprehensive Basic Accounting for Executive
26	23-24Mei	Public Relation Management
27	23-24Mei	Penyusunan Struktur Skala Upah (Compensation & Benefit)
28	23-24Mei	Personal Development & Generational Diversity In The Workplace
29	23-24Mei	Effective Technical report Writing
30	24-25Mei	New Product Development
31	24-25Mei	Career & Talent Management
32	30-31Mei	Workload Analysis Implementation With MS. Excel For HR & Non HR
33	30-31Mei	Training Need Analysis
34	30-31Mei	Human Resource Management Development Program (HRMDP)
35	30-31Mei	Advanced Service Excellence