| FAQ |
| Calendar |
|
|
#1
15th October 2012
|
||||
|
||||
Duta Software Training
Kondisi Barang : Baru
Harga : Lokasi Seller : DKI Jakarta Description :  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 
|
 |
|
|
