Duta Software Training

[Australian]

Kondisi Barang : Baru

Harga :



Lokasi Seller : DKI Jakarta


Description :



http://img4.imageshack.us/img4/2631/dutasoftwaretraining.jpg





Excel Fundamentals for Finance (1 hari)

----------------------------------------

Functions

- Financial functions (PMT, NPV, IRR etc)

- Logical functions (IF, AND, OR)

- String functions (LEFT, RIGHT, MID etc)

- Date & time functions

- Aggregation functions (SUBTOTAL etc)

- Lookup functions (VLOOKUP etc)

etc.

Charts

- Add, remove, resize, modify charts

- Working with chart elements

- Formatting charts

- Chart types

etc.

Formatting

Navigation

- Hyperlinks

- Viewing a large file

etc.

What if Analysis

Introduction to Macro



Minimal 4 peserta @Rp400000/peserta





Excel for Officer (1 hari)

--------------------------

Basic Functions & Formulas: SUMIF, SUMPRODUCT, COUNTA, SUBTOTAL, LOOKUP, INDIRECT, OFFSET, etc

Data Validation

Pivot Table

Static & Dynamic Chart

Create Dashboard/ Case Study



Minimal 4 peserta @Rp400000/peserta





Custom Excel (1 hari)

------------------------

As Per Needed with Case Study



Minimal 4 peserta @Rp400000/peserta





Excel Macro/ VBA (2 hari)



Minimal 4 peserta @Rp600000/peserta





Excel Database Programming (2 hari)



Minimal 4 peserta @Rp600000/peserta





Structure Query Language (SQL) - 2 hari

------------------------------

Option: for SQL Server or Oracle

- Concept of RDBMS

- Data Manipulation Language: insert, update, delete

- Transact SQL (Stored Procedure, Function, etc) --> for SQL Server

- PL/SQL --> for Oracle



Minimal 4 peserta @Rp600000/peserta





Develop Application Using Ms. Access (1 hari)



Minimal 4 peserta @Rp400000/peserta





ASP.NET (C# or VB) - 2 hari



Minimal 4 peserta @Rp600000/peserta





Create Report Using Logi Report - 1 hari

- Prerequisite: understand SQL

- Include free version of Software (LogiReport)

Note: LogiReport is free BI Tool



Minimal 4 peserta @Rp600000/peserta





Crystal Report (1 hari)



Minimal 4 peserta @Rp400000/peserta





PowerPoint (4 jam)



Minimal 4 peserta @Rp250000/peserta





Ms. Project (1 hari)



Minimal 4 peserta @Rp400000/peserta





Desain dengan Adobe Photoshop (1 hari)



Minimal 4 peserta @Rp400000/peserta





Membuat Video Tutorial Dengan Camtasia Studio (4 jam)



Minimal 4 peserta @Rp250000/peserta



Lokasi Training : In House Training, Workshop Dutasoftware (MPR III 13D Cilandak Jaksel)



Include : Modul training, CD contoh soal



Website : http://www.dutasoftware.com



Hub : 081281130930