Tuesday, March 3, 2009

Agenda Public Training - Maret 2009 & Sepanjang tahun 2009

Kami menyapa Anda kembali di bulan Februari ini dengan Agenda Public Training untuk bulan Maret 2009 dan sepanjang tahun 2009.

AGENDA PUBLIC TRAINING

www.voloxa.com/Voloxa_AgendaPublicTraining.pdf

(klik untuk lihat detail)

OUR SERVICES – Outsourcing on Corporate Learning

www.voloxa.com/Voloxa_OurServices.pdf

(klik untuk lihat detail)

Agenda pelatihan bulan Maret 2009 akan diisi dengan 11 materi pelatihan:

MARKETING

1. Manajemen Pemasaran bagi Perusahaan Jasa (10-11 Maret)

2. International Marketing: Penetrasi Pasar Luar Negeri (30-31 Maret)

FINANCE

3. IFRS: Harmonisasi Standar Akuntansi Dunia (12-13 Maret)

HUMAN RESOURCE

4. Entrepreneurship: Transisi dari Karyawan ke Wirausaha (16-17 Maret)

LEADERSHIP and MANAGEMENT

5. Manajemen Kantor Cabang: Skills for Branch & District Manager (2-3 Maret)

6. Leadership & Management Skills for New Managers (19-20 Maret)

OPERATIONS

7. Inventory Management: Production Plan & Inventory Control (5-6 Maret)

8. Warehouse Management: From Storage to Warehouse Optimization (23-24 Maret)

SOFT SKILLS

9. Communication Skill for Non Marketing People (18 Maret)

10. Negotiation Skill in Corporate Environment (25 Maret)

11. Personal Development and Communication for Receptionist (4 Maret)

ABOUT US

Voloxa is a reliable partner for outsourcing your 'Corporate Learning' programs. With base in Jakarta, we assist to cultivate learning culture within your organization by providing learning services in :

3 Deliveries ( Classroom, E-Learning, Outbound )

4 Operations ( Curriculum, Administration, Measurement, Reporting )

5 Functions ( Marketing, Finance, Human Resource, Operations, Soft Skills )

Sincerely,

Lin Ernawati

VOLOXA

Kencana Niaga D1/3W

Jakarta Barat, Indonesia

Tel (62) 21 585 5985 / 585 8915

E-mail: mail@voloxa.com

Website: www.voloxa.com

Database Management and Analysis on March 30-31, 2009

Excel Series

Database Management and Analysis

Jakarta, March 30-31, 2009

April 23-24, 2009

Description

This course teaches Participants how to modify database records using data forms and specify criteria for database functions. The use of the Automatic Subtotals feature is also examined. In this course, Participants will learn to create PivotTables and Pivot-Charts. They will also forecast values with trend lines and create scenarios.

Objectives

By the end of this course, you will be able to:

· Work with Excel databases,

· Sort database data,

· Use database functions,

· Use financial functions,

· Use advanced filters and automatic subtotals,

· Create pivot tables and pivot charts,

· Modify pivot tables,

· Audit worksheets and perform what-if analyses and

· Work with scenarios.

Detailed Outline

Working with Databases

Identifying Database Components

Adding Database Components

Modifying Database Records

Sorting Database Data

Sorting Records by up to Three Fields

Rearranging Fields

Sorting Records by Four Fields

Applying Custom Sort Orders

Sorting Text as Numbers

Using Database Functions

Using the DAVERAGE Function

Using the DCOUNT Function

Using the DSUM Function

Using the DMIN Function

Using the DMAX Function

Using the DGET Function

Using Advanced Filters and Automatic Subtotals

Using the Advanced Filter Feature

Extracting Data

Using the Automatic Subtotals Feature

Creating PivotTables and Pivot-Charts

Creating PivotTables

Changing PivotTable Layouts

Changing PivotTable Field Names and Functions

Extracting Data from PivotTables

Creating Pivot-Charts

Working with Form

Label and Edit Box

Group Box and Button

Check Box and Option Button

List Box and Combo Box

Combination List-Edit

Combination Drop-Down-Edit

Scroll Bar and Spinner

Edit Code and Toggle Grid

Modifying PivotTables

Formatting Numbers in PivotTables

Displaying and Hiding PivotTable Data

Refreshing PivotTable Data

Sorting PivotTable Data

Using the PivotTable AutoFormat Feature

Auditing Worksheets and Performing What-If Analyses

Tracing Precedents and Dependents

Locating Precedents and Dependents

Locating and Resolving Errors

Using the Goal Seek Feature

Using the Solver Feature

Forecasting Values with trend lines

Working with Scenarios

Creating Scenarios

Applying Scenarios

Creating Scenario Summary Reports

Editing and Deleting Scenarios

Protecting Scenarios

Using MACRO

Recording Macro

Assigning Macro to Button and Icons

Create My Own File and Menu on Menu Bar

HLOOKUP and VLOOKUP

Case Study and Tools

Budgeting and Forecasting Analysis

Inventory and Production Analysis

Corporate Performance Analysis

Financial Business Analysis

Tax Computation Analysis

Business Plan Analysis

Instructor

MUSLIM

· Financial Modeling Specialist

· Business Process Review Specialist

· Chairman and CEO of PT. MY Consulting

· Partner of Adi Jimmy Arthawan Accounting Firm

He is a registered accountant by profession as Partner of KAP Adi Jimmy Arthawan and is working as President Director for MY Consulting Indonesia.

With a very rich and varied work experience acquired by his employment in several different experiences, He commands the best knowledge of the theory and use of various Computer Applications, especially Microsoft Excel.

His experience as a middle level and top-level manager and also as a business owner has provided the perfect angle of top management thoughts and an easy-learning solution model with which he has tailored the learning approach.

Investment

IDR 5.000.000 (Five Million)

Send 4 delegates and the 5th comes for FREE

Pay 5 for 7 participants

Methodology

Lecturers

Case study and Exercises

1 Participant to a computer

Practical Computer Hands on Applications

Bring your own laptop and have all your financial modeling (installed excel 2003-2007)

Facilities

Hot Spot Training Room

Excel Bible (Full Version) – Text book (softcopy)

Training Handout and Exercise (softcopy)

Lunch and Coffee Break (2)

Certificate and Consultation

Venue

Training Center MYC Academy

Wisma Nugra Santana

12 Floor Suite1216

Jl Jend Sudirman Kav 7-8

Jakarta 10220 INDONESIA

In-house package (special terms)

Pay 9 for 14 participants

Venue and schedule as client confirmation

Tailor-made for teams of between 7 and 14 executives

Thanks and regards,

Yuniarti

Events Coordinator

PT MY Consulting

Wisma Nugra Santana

12 Floor Suite1216

Jl Jend Sudirman Kav 7-8

Jakarta 10220 INDONESIA

Ph 62 21 5704791

Fax 62 21 5704918

yunie@myconsulting.us

PUBLIC TRAINING SCHEDULE ON FEBRUARY 2009

DATE

GROUP TYPE

TOPICS

02-04

Excel Series

CEO Financial Modeling (Corporate Financial Analysis and Forecasting)

05-06

Excel Series

Finance Analysis for Non Finance Manager

10-11

Excel Series

Business Plan Analysis (Corporate Financing and Evaluation)

12-13

Excel Series

Finance Analysis for Non Finance Manager

17-18

19-20

24-25

Excel Series

Excel Series

Excel Series

Database Management and Analysis

Annual Report Analysis and Interpretation

Business Plan Analysis (Corporate Financing and Evaluation)

PUBLIC TRAINING SCHEDULE ON MARCH 2009

DATE

GROUP TYPE

TOPICS

03-04

Excel Series

CEO Financial Modeling (Corporate Dashboard Analysis)

05-06

Excel Series

Finance Analysis for Non Finance Manager

10-11

Excel Series

Business Plan Analysis (Corporate Financing and Evaluation)

12-13

Excel Series

Finance Analysis for Non Finance Manager

16-18

19-20

24-25

Excel Series

Excel Series

Excel Series

CEO Financial Modeling (Corporate Financial Analysis and Forecasting)

Annual Report Analysis and Interpretation

Business Plan Analysis (Corporate Financing and Evaluation)

PUBLIC TRAINING SCHEDULE ON APRIL 2009

DATE

GROUP TYPE

TOPICS

01-03

Excel Series

CEO Financial Modeling (Corporate Financial Analysis and Forecasting)

07-09

Excel Series

CEO Financial Modeling (Market and Valuation Analysis)

14-15

Excel Series

Business Plan Analysis (Corporate Financing and Evaluation)

16-17

Excel Series

Finance Analysis for Non Finance Manager

21-22

23-24

28-29

Excel Series

Excel Series

Excel Series

CEO Financial Modeling (Corporate Dashboard Analysis)

Database Management and Analysis

Business Plan Analysis (Corporate Financing and Evaluation)

RECENT ATTENDEES INCLUDE ON OUR TRAINING

2008

· Total Bangun Persada, Tbk

· Grendale Partners

· Charoen Pokphan Indonesia Tbk

· Boehringer Ingelheim Indonesia

· Meta Epsi

· Ernst & Young

· Medco Power Indonesia

· Widya Sapta Colas

· Medco Geothermal Sarulla

· Asuransi Adira Dinamika

· First Media Tbk

· Bekaert Indonesia

· Astellas Pharma Indonesia

· Intiland Development Tbk

· Sandoz Indonesia

· Aero Wisata

· Sefas Pelindotama

· Sorini Agro Asia Tbk

· CIC Indonesia

· Metrodata Electronics Tbk

· Adira Asuransi Dinamika

· Jakarta International Container Terminal

· Hutchison Port Indonesia

· Kaltim Prima Amoniak

· Bank BTPN Tbk

· Indosat Tbk

· Lembaga Penjamin Simpanan

· SUCOFINDO (PERSERO)

· Unican Surya Agung

· Timah (PERSERO) Tbk

· Sierad Produce Tbk

· Lippo Karawaci Tbk

· CNOOC SES Ltd

· PERTAMINA (PERSERO)

· BAHANA (PERSERO)

· Bredero Shaw Indonesia

· Bank of Tokyo Mitsubishi

· Danareksa (PERSERO)

· Janssen Pharmaceutica

· Excelcomindo Pratama Tbk

· Deutsche Verdhana Indonesia

· Rajawali Corpora

· Tripatra Enginers and Contractors

· Ekspres Transportasi Antarbenua

· NetToCyber Indonesia

· Ciputra Corpora

· Trimegah Securities Tbk

· Astratel

· Astra International Tbk

· Express Group

· Kawasan Industri Jababeka Tbk

· IMECO

· Kraft Foods Indonesia

· Semen Gresik (Persero) Tbk

2009

· Cipta Pratama Technocom

· StarEnergy (Kakap)

· Exspan Petrogas Intranusa

· Kalbe Nutritionals

· Dwi Era Sejahtera

· Excelcomindo Pratama Tbk

· Pertamina Energi Hulu (PERSERO)

· Kaltim Prima Amoniak

· Panorama Convexion

· Bahana