Jumat, 20 April 2018

Running Mei : (1) Powerfull Database Analysis (2) Business process Modelling : Confirm Running

MARKSHARE Training

We Provide Workshop & Training

 

Call Us :

Eby (Ms.) 08561044530 / 021 – 5793 2035

eby@marksharetraining.co.id / eby.markshare@gmail.com / ask@marksharetraining.co.id

www.marksharetraining.co.id

for unsubscribe, click here

 

 

 

 

Powerfull Database Analysis & Dashboard Reporting Using Ms. Excel

Jadwal :

Jakarta, 8 - 9 Mei 2018

Business Process Modeling Implementation With BPMN Tools

Jadwal :

Jakarta, 8 – 9 Mei 2018

Outline Pelatihan :

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

Outline Pelatihan :

1.         Proses bisnis secara umum

2.         Proses bisnis konteks organisasi.

3.         Fenomena functional silos pada perusahaan.

4.         3 (tiga) proses bisnis yang ada dalam setiap organisasi.

5.         5 (lima) kegiatan manajemen organisasi yang terhubung ke dalam information system.

6.         Hubungan antara proses bisnis, information system dan aktifitas utama management.

7.         5 (lima) komponen kunci pemicu kejadian proses bisnis.

8.         3 (tiga) klasifikasi utama dalam proses bisnis.

9.         Perbaikan proses bisnis metode ESIA :

1)        Eliminate

2)        Simplify

3)        Integrate

4)        Automate

10.     Tool-tool dokumentasi proses bisnis :

1)        Relationship Mapping

2)        Flowchart

3)        Cross-Functional Flowchart

4)        Work-Flow Chart

11.     Manfaat – manfaat memperbaiki proses bisnis.

12.     Definisi Pemodelan Proses Bisnis (Business Process Modelling Definition):

1)        Flow Diagrams

2)        Concerned With 'Mapping' and 'Workflow'

3)        Sequence of Activities

4)        Events, Actions And Links

5)        Sequence & Organizational Operations

13.  Komponen-komponen yang harus ada dalam pemodelan proses bisnis :

1)        Business actor

2)        Business worker

3)        Association and generalization relation

4)        Business entity

5)        Business use case diagram

6)        Activity diagram

7)        Organization unit

14.     Tujuan pembuatan pemodelan proses bisnis.

15.     Mengetahui tahapan – tahapan pembuatan pemodelan proses bisnis

16.  Pemodelan proses bisnis dengan metode REAL :

1)        Resources

2)        Events

3)        Agents

4)        Locations

17.  Cases Study

 

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 !

 

 

 

 

 Jadwal Training Lainnya :

NO

TANGGAL

JUDUL TRAINING

LOKASI

28

23 - 24 April

Good Corporate Governance ( GCG ) Implementation

Jakarta

29

23 - 24 April

Metode Penyusunan Spesifikasi & HPS

Jakarta

30

23 - 24 April

Leadership For Sales ; Lead Well Sell Better

jakarta

31

23 – 24 April

Strategic Vendor Management

Jakarta

32

24 - 25 April

Electronic Filing System Implementation Based On Document Regulation And Rms – Efs Method With Excel 2007/2010/2013/2015/2016

jakarta

33

24 - 25 April

Corporate Journalism ; How to Treat Corporate Website, Magazine & Media Handling

Jakarta

34

24 - 25 April

Carreer & Talent Management

Jakarta

35

25 – 26 April

Training For Trainers

Jakarta

36

26 - 27 April

Logical Thinking & Problem Solving

Jakarta

37

26 - 27 April

Contract & Tender in Procurement

Jakarta

38

26 – 27 April

Effective Supervisory Skill

Jakarta

39

26 - 27 April

Creative Cashflow & Treasury Management

Jakarta

40

26 - 27 April

Project Management Using Ms. Project Application

Jakarta

41

26 - 27 April

Comprehensive Industrial Relation

Jakarta

42

26 - 27 April

Workload Analysis Implementation with EXCEL 2007 FOR HR & NON HR

Jakarta

43

26 - 27 April

Letter of Credit on Export & Import

jakarta

44

26 - 27 April

Budgeting Planing & Control

jakarta

 

 NO

TANGGAL

JUDUL TRAINING

LOKASI

1

3 - 4 Mei

Discovering Effective Financial Statement Analysis

Jakarta

2

3 - 4 Mei

Effective Practical Business Communication

Jakarta

3

9 – 10 Mei

Sucessfully Managing People “Leadership & Managerial Skill”

4

3 - 4 Mei

Impresive Public Speaking Skills

5

7 - 8 Mei

Risk Based Internal Audit

Jakarta

6

8 - 9 Mei

Powerfull Database Analysis & Dashboard Reporting with Ms. Excel 2007/2010

Jakarta

7

8 - 9 Mei

Business Process Modeling Implementation With BPMN Tools

Jakarta

8

9 – 10 Mei

Leadership For Sales “Lead Well Sell More!”

9

14 - 15 Mei

Cost Accounting - Best Practice

Jakarta

10

14 - 15 Mei

Effective Office Management With Kaizen 5S & Filing System

Jakarta

11

14 - 15 Mei

General Affair Management Development Program

Jakarta

12

14 - 15 Mei

Public Speaking & Presentation Skills

Jakarta

13

15 - 16 Mei

Metode Penyusunan Spesifikasi & HPS

Jakarta

14

15 - 16 Mei

Effective Negotiation & Lobbying Skills

Jakarta

15

15 - 16 Mei

Transformational Leadership & Managerial Skill

Jakarta

16

17 - 18 Mei

Strategic Sourcing & Vendor Management

Jakarta

17

17 - 18 Mei

Project Management Using Ms. Project Application

Jakarta

18

17- 18 Mei

Logical & Creative Problem Solving

Jakarta

19

17 - 18 Mei

Creative Cashflow & Treasury Management

Jakarta

20

21 - 22 Mei

EffectiveWarehouse & Inventory Management

Jakarta

21

21 - 22 Mei

Productivity & Effective Time Management

Jakarta

22

21 - 22 Mei

Electronic Filling System Implementation Based on Doc. Regulation & RMS-EFS With Excel 2007/2010/2013/2015/2016

Jakarta

23

21 -22 Mei

Integrated Procurement Management

Jakarta

24

21 - 22 Mei

Negotiation Power For Purchasing

Jakarta

25

21 - 22 Mei

The 7 Selling Steps Total Selling Basic

Jakarta

26

23 - 24 Mei

Comprehensive Basic Accounting for Executive

Jakarta

27

23 -24 Mei

Public Relation Management

Jakarta

28

23 - 24 Mei

Penyusunan Struktur Skala Upah (Compensation & Benefit)

Jakarta

29

23 - 24 Mei

Personal Development & Generational Diversity In The Workplace

Jakarta

30

23 - 24 Mei

Effective Technical report Writing

Jakarta

31

24 - 25 Mei

Enterprise Risk Management

Jakarta

32

24- 25 Mei

New Product Development

Jakarta

33

24 - 25 Mei

Career & Talent Management

Jakarta

34

30 - 31 Mei

Workload Analysis Implementation With MS. Excel For HR & Non HR

Jakarta

35

30 - 31 Mei

Training Need Analysis

Jakarta

36

30 - 31 Mei

Human Resource Management Development Program (HRMDP)

Jakarta

37

30 - 31 Mei

Advanced Service Excellence

Jakarta

 

 

 

Tidak ada komentar:

Posting Komentar