Senin, 23 Januari 2017

Confirm Running : Microsoft Excel 2010 / 2013 with Visual Basic for Application ( VBA - Macro )

 

MARKSHARE Training

We Provide Workshop & Training

 

 Microsoft Excel 2010/2013 Visual Basic for Application 
(VBA-Macro)

Hotel Oria Jakarta , 30 – 31 Januari 2017

Call Us :

SARI (Ms.)

Mobile: 0858 9026 0140

Phone : 021 – 5793 2035

E-mail : sari@marksharetraining.co.id

d.sari131282@gmail.com

click here to unsubscribe

 

 

Tujuan Training

 

Ø  Dapat mengoptimalkan pekerjaan dengan Microsoft Excel

Ø  Dapat menciptakan advanced report yang dinamis

Ø  Membuat otomatisasi dalam pekerjaan di Excel

Ø  Menyederhanakan perhitungan dan formula yang kompleks

Ø  Menciptakan keamanan yang maksimal di excel

Ø  Membuat function sendiri untuk memudahkan perhitungan dan melindungi kerahasiaan rumus

Ø  Memaksimalkan grafik dengan VBA Macro

 

Prasyarat

Ø  Memiliki skill dasar dan atau telah menggunakan MS. Excel

 

Materi Training

Ø  Overview Of Excel Advance Formula and features

·         H/Vlookup , Dsum , SumIf, IF , Goal Seek, Conditional Formating , Data validation , Pivot Table ,Excel Protection, Case studies.

Ø  Introduction To Macro & VBA Overview

·         Macro & VBA definition

·         Toolbars & VBE

·         Macro execution (record, store and run macro)

·         Basic versus VBA

·         Examining recoded macro code

·         Debugging tools

·         Object, Methods and Properties

Ø  Referring To Ranges The range object

·         Select specify range

·         Referring cells in other sheet

·         Referring a relative range to another range

·         Using Properties

Ø  Looping And Flow Control Using variables for statement

·         Using while . . . wend loop

·         The VBA loop: For . . .Each

·         Flow control If . . then . . else

·         Using Select Case

Ø  Names Global versus Local names

·         Adding names

·         Deleting names

·         Type of names

·         Hiding names

·         Checking for the existence of a name

Ø  Event Programming Level of events

·         Using events

·         Workbook events

Ø  More with VBA Macro

·         Using Visual Basic Subroutines and Creating Functions

·         Creating Interactive Macros          

·         Using Macros to Format Cells       

·         Using Variables in Macros            

·         Creating If/Then/Else Routines                     

·         Adding Form Controls & Active X Control to Your Worksheets (Form, Listbox, Textbox, Buttons)

·         Optimizing Chart and Pivot Table using VBA Macro

Ø  Handling Errors Basic error handling: on error go to

·         Generic error handlers

·         Customize error handlers

Ø  Excel VBA Study Case

·         Building Automatic Excel Report Generator

·         Automatic Cash Flow Generator

Investasi

Normal Rp. 4.500.000,-/peserta

Grup 3 orang Rp. 4.000.000,- /peserta

Limited Seat Available  Call us & Register Now

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 !

 

 

Click here to  Unsubscribe

 

NO

TANGGAL

JUDUL TRAINING

Lokasi

1

17 - 18 Januari

Contract & Tender Management in procurement

Jakarta

2

19 - 20 Januari 2016

Leadership & Managerial Skill

Jakarta

3

19 - 20 Januari 2016

Financial Statement Analysis

Jakarta

4

23 - 24  Januari 2017

Effective Office Management With kaizen 5S & Filing System

Jakarta

5

23 - 24  Januari 2017

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

Jakarta

6

24 - 25 Januari 2017

Strategic Procurement Management

Bandung

7

25 – 26 januari 2017

General Affairs Professional : Concept , Strategy & Implementation

Jakarta

8

25 - 26 Januari 2017

Technic Communication & Negotiation Skills

Jakarta

9

26 - 27 Januari 2017

Negotiation Power For Purchasing

Jakarta

10

26 - 27 Januari 2017

Advanced Secretary Development Program

Jakarta

11

26 - 27 Januari 2017

Integrated Presentation Skill

Bandung

12

26 - 27 Januari 2017

Creative Analythical Thingking

Bandung

13

30 - 31 Januari 2017

Basic Marketing & CRM Management

Jakarta

14

30 - 31 Januari 2017

Best Practice Warehouse Management

Jakarta

15

30 - 31 Januari 2017

Comprehensive Ms. Excel Training With Visual Basic Application (VBA)

Jakarta

NO

TANGGAL

JUDUL TRAINING

Lokasi

1

1 - 2 februari

Certified Career & Talent Management

Jakarta

2

2 - 3 Februari

Risk Based Internal Audit

Surabaya

3

6 - 7 Februari

Communication & Interpersonal Skill

Jakarta

4

7 - 8 Februari

Best Practice Warehouse Management

Jakarta

5

7 - 8 Februari

Win - Win Negotiation Skill

Jakarta

6

8 - 9 Februari

Total Selling : Advanced Sales program

Jakarta

7

8 - 9 Februari

Training For Trainers ( TFT )

Jakarta

8

8 - 9 Februari

Finance for Non Finance Executive

Jakarta

9

9 - 10 Februari

Technic Presentation Skill

Surabaya

10

9 - 10 Februari

Workload Analysis Implementation with Ms.Excel for HR & Non HR

Jakarta

11

9 - 10 Februari

Metode Penyusunan Spesifikasi & Harga Perkiraan Sendiri ( HPS / Owner Estimasi )

Jakarta

12

9 - 10 Februari

Managing Difficult Customer & Handling Complaint Professionaly

Jakarta

13

13 - 14 Februari

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

Jakarta

14

13 - 14 Februari

Good Corporate Governance ( GCG ) Implementation

Jakarta

15

17-Feb

Infographic Powerpoint

Jakarta

16

20-Feb

Creating Balancedscoredcard Step by Step

Jakarta

17

21 - 22 Februari

Clinic Essensial Excel for office data processing System

Jakarta

18

21 - 22 Februari

Business Ettiquette & Protokoler

Jakarta

19

22 - 23 Februari

Secretary Development Program

Jakarta

20

22 - 23 februari

Project Management using MS Project

Jakarta

21

23 - 24 Februari

Strategic Sourcing & vendor Management

Bandung

22

23 - 24 Februari

Total Quality Management ( TQM )

Bandung

23

23 - 24 Februari

Comprehensive Supervisory Skill

Jakarta

24

27 - 28 Februari

How To Identify Training Need ( TNA )

Jakarta

25

27 - 28 Februari

Technical Report Writing

Jakarta

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