Ingin dapat diskon training 600 ribu ?!, beli vouchernya di Tokopedia atau Bukalapak !


Kami Bekerjasama dengan hotel bintang di 4 kota Bandung-Jakarta-Bali-Cikarang untuk memberikan kenyamanan peserta public training


Inhouse Training adalah pilihan paling tepat untuk jumlah peserta perusahaan yang banyak dengan mengutamakan efisiensi biaya training.


Inhouse Training Android Application Development di PT. PLN Wilayah Maluku selama 4 hari


Inhouse Training Magento E-Commerce berdurasi 7 hari dibagi 2 sesi Fundamental dan Advanced.

Tuesday, June 18, 2019

VBA Data Base Complete project in 3hours

VBA Data Base Complete project in 3hours

This video will helps to how to create data base in excel sheet Our training videos on YouTube cover formulas, functions and VBA or macros,Android , Visual studio C programming language and Java. Useful for beginners as well as advanced learners. New upload every day. Trading Tools Aps Fibonacci Retrace with Breakout App http://bit.ly/2L7PSVl Camarilla pivot point App http://bit.ly/2FiBS7s Range BreakOut App http://bit.ly/2L7PTsn Subscribe to YOUTUBE :http://www.youtube.com/c/TechSite/ Like on FACEBOOK :http://bit.ly/2Fib8nq Visit my WebSite :http://bit.ly/2L7PTZp Watch more VIDEOS :http://www.youtube.com/c/TechSite/videos Follow us on Instagram :http://bit.ly/2Fj2FAm Follow Us on Twitter :http://twitter.com/techsiteraghu/ Follow Us on vimeo :http://bit.ly/2KYfsMg Feed burner :http://bit.ly/2Fmjc6K Add, delete and rename sheet:https://www.youtube.com/playlist?list=PLdjoCUa5gxgeWEwyu4MV3ejHG08pD0oNU Java program in Kannada :https://www.youtube.com/playlist?list=PLdjoCUa5gxgfptzJ8SA7kUFyehmsluxBr Android Studio Tutorial -https://www.youtube.com/watch?v=q5u4PqrYhH0&list=PLdjoCUa5gxgciILY0b6ITFuzscl00WgBV C language tutorial playlist : https://youtu.be/cpcg1yAHOWM?list=PLdjoCUa5gxgcWLhLcjyxpwI6j-0vfESTC Data entry project in userform :https://www.youtube.com/playlist?list=PLdjoCUa5gxgcA3Os_lLyCfiJzlKf90Gu- UserformTutorial -https://www.youtube.com/watch?v=2qrpaSXRo-A&list=PLdjoCUa5gxgcTLigPBC288sPT5RZYJAW9 excel Sheet Tutorial -https://www.youtube.com/watch?v=O6x5mNePPx4&list=PLdjoCUa5gxgfatwxeBJ2hCX42sHn0k-HN Unigraphics Nx11 -https://www.youtube.com/watch?v=0GRBN9E7_IQ&list=PLdjoCUa5gxgexzahnpLr5mNrBvYVndADF Excel Project :https://www.youtube.com/watch?v=-IwAhK-B8o4&list=PLdjoCUa5gxgcSOyRIEPYMjFLBpDG4BALh Web Design Course : https://www.youtube.com/watch?v=XVzJcDvAppk&list=PLdjoCUa5gxge1jH73K4Ep5-wnpsV-HxGI Mobile Aps : https://www.youtube.com/watch?v=hA0ZujqIoqY&list=PLdjoCUa5gxgcDOGoq92Lui0W5ocpvupbf
via YouTube https://youtu.be/2SeWA-JnC7I

Liked on YouTube: 7 Tips Excel Yang Bisa Mempercepat Pekerjaan

7 Tips Excel Yang Bisa Mempercepat Pekerjaan

Excel memang banyak sekali digunakan di perkantoran dan tentunya mampu membantu pekerjaan kita sehari-hari. Jika kita mengetahui cara menggunakan excel dengan benar tentu tidaklah sulit untuk mengerjakannya. Beberapa tips dan trik yang sering digunakan dalam excel dan membantu sekali dalam tugas kita dan inilah 7 trik dan tips yang bisa dipake. TIPS LAINNYA TENTANG EXCEL : Rumus IF AND Multiple Kriteria dengan Rentang Nilai ---- : https://goo.gl/4kEukJ Contoh Rumus COUNTIFS dengan Multiple Kriteria ---- : https://goo.gl/ysZdSA
via YouTube https://youtu.be/JsdcYL2GrhM

Excel Macro Tutorial - Learn how macros can really speed up your work in Excel

Excel Macro Tutorial - Learn how macros can really speed up your work in Excel

Get FREE 28-page e-book "Record Your First Macro" here → http://bit.ly/2HQMivq ----- // Episode Notes Read more at http://bit.ly/2W07d9j This video is an introduction to the basics of Macros and VBA in Excel. When you see the power of macros you will want to learn how to use them yourself! Think of a macro as a tape recording. It remembers word for word what you "say" to Excel. VBA = Visual Basic for Applications. This is the language used by Excel to record macros. In the video we cover a simple use-case for the macro recorder: how to change your number formats. For an interesting example of pretty advanced VBA, check out the article on using Google Maps in Excel with VBA: http://bit.ly/2HQMjiY This video uses this sound from freesound: ferrari355underhood4.mp3 by enginemusic -- http://bit.ly/2W07dpP
via YouTube https://youtu.be/-QHT6TEm3NE

Pengertian System Development Life Cycle (SDLC)

Pengertian System Development Life Cycle  - Software Development

SDLC (Systems Development Life Cycle, Siklus Hidup Pengembangan Sistem) atau Systems Life Cycle (Siklus Hidup Sistem), dalam rekayasa sistem dan rekayasa perangkat lunak, adalah proses pembuatan dan pengubahan sistem serta model dan metodologi yang digunakan untuk mengembangkan sistem-sistem tersebut. Konsep ini umumnya merujuk pada sistem komputer atau informasi. SDLC juga merupakan pola yang diambil untuk mengembangkan sistem perangkat lunak, yang terdiri dari tahap-tahap: rencana(planning),analisis (analysis), desain (design), implementasi (implementation), uji coba (testing) dan pengelolaan (maintenance). Dalam rekayasa perangkat lunak angsyat Ä, konsep SDLC mendasari berbagai jenis metodologi pengembangan perangkat lunak. Metodologi-metodologi ini membentuk suatu kerangka kerja untuk perencanaan dan pengendalian pembuatan sistem informasi, yaitu proses pengembangan perangkat lunak. Terdapat 3 jenis metode siklus hidup sistem yang paling banyak digunakan, yakni: siklus hidup sistem tradisional (traditional system life cycle), siklus hidup menggunakan prototyping (life cycle using prototyping), dan siklus hidup sistem orientasi objek (object-oriented system life cycle).

software development,
app development,
mobile app development,
web development,
agile development,
website development,
agile software development,
mobile app development company,
rapid application development,
system development life cycle,
software development life cycle,
system development life cycle adalah,
metode pengembangan perangkat lunak,
system development life cycle adalah,
system development life cycle,
rapid application development,
metode pengembangan perangkat lunak,
software development life cycle,

Monday, June 17, 2019


Purnama Academy Training  (0838.0838.0001), Silabus Training :

 3  Days (09.00 – 16.00)

According to the International Association of IT Asset Managers (IAITAM), IT Asset Management (ITAM) is “a set of business practices that incorporates IT assets across the business units within the organization. It joins the financial, inventory, contractual and risk management responsibilities to manage the overall life cycle of these assets including tactical and strategic decision making”. Assets include all elements of software and hardware that are found in the business environment.
IT asset management is sometimes referred to as IT inventory management because it typically involves gathering detailed hardware and software inventory information which is then used to make decisions about purchases and how assets are used. Having an accurate IT asset inventory helps companies use their assets more effectively and avoid unnecessary asset purchases by re-using existing resources. IT asset management also enables organizations to lower the risks costs of unknowingly building new IT projects on outdated (or unknown) infrastructure foundations.
IT Asset management is made effective using metadata and electronic records to track and categorize the organization’s assets. Metadata is the description of the physical or digital asset and any supporting information that is needed to inform asset management decisions. The metadata depth can vary depending on the needs of the organization.

After following this course at Purnama Academy Training you will be able to :


·         Complete overview of IT Asset Management concepts
·         Successfully apply IT Asset Management best practices to build and maintain IT Assets
·         Identify the practices leading to sustainable IT Asset Management programs that maximize value to the organization and meet goals specified
·         Determine and execute next steps, and evaluate success within the organization’s unique culture, strengths and weaknesses
·         An practical approach towards ITAM

-          IT Professionals
-          IT Stakeholders
-          Newbies to IT Industry

Anyone who wants learn about IT Asset Management



ITAM Definition
Benefit of ITAM
Need of ITAM
ITAM Life-cycle

Day 2
IT Asset Management Processes
IT Asset Return Process
Processing Lost and Stolen Assets
IMACD (Install,Move,Add,Change,Disposal)

Day 3
KPI and Metrics
Policy, Process, Procedure
ITAM Maturity Model
ITAM Tools Selection




Duration : 4 Days (09.00 – 16.00)

Description :

Microsoft Dynamics AX is the most versatile and extensive Tier 1 ERP product available for enterprises operating locally or globally

Many leading organizations all over the world are turning towards MS Dynamics AX Technical for updating their business processes. Therefore,  the demand for certified Microsoft Dynamics AX Technical professionals is skyrocketing and paving the way for enormous job opportunities.

Objectives :

Microsoft Dynamics AX Technical Training deals with Operations and Management to organize data in a regulatory manner. The primary objectives of this training are listed below:
·         Understand the Workflow Management
·         Implementing the best Practices on Microsoft Dynamics
·         Manage SSRS Reports
·         Using The Run Base Framework

Participants :
·         Business Professionals
·         Business Managers
·         Business Entrepreneurs
·         Management Executives
·         Business Development Executives

Prerequisites :
There are no specific prerequisites for learning Microsoft Dynamics AX Technical. Anyone interested in learning this technology can join the training.

Topics include:

·         General Ledger Setup and Review in Microsoft Dynamics AX 
·         Chart of Accounts and Ledger Balances in Microsoft Dynamics 
·         General Ledger Configuration in Microsoft Dynamics AX 
·         General Journals in Microsoft Dynamics AX 
·         Sales and Withholding Taxes in Microsoft Dynamics AX 
·         Cash and Bank Setup in Microsoft Dynamics AX 
·         Cash and Bank Reconciliation in Microsoft Dynamics AX 
·         Vendor Setup in Microsoft Dynamics AX 
·         Vendor Invoicing in Microsoft Dynamics AX 
·         Vendor Invoice Journals in Microsoft Dynamics AX 
·         Vendor Payments in Microsoft Dynamics AX 
·         Prepayments in Microsoft Dynamics AX 
·         Customer Setup in Microsoft Dynamics AX 
·         Free Text Invoices and Sales Order Invoices 
·         Customer Cash Receipts in Microsoft Dynamics AX 
·         Budgeting in Microsoft Dynamics AX 
·         Budget Planning in Microsoft Dynamics AX 
·         Budget Control in Microsoft Dynamics AX 
·         Commitment Accounting in Microsoft Dynamics AX 
·         Bills of Exchange in Microsoft Dynamics AX 
·         Centralized Payments in Microsoft Dynamics AX 
·         Intercompany Accounting in Microsoft Dynamics AX 
·         Eliminations and Consolidations in Microsoft Dynamics AX 
·         Customer Collections in Microsoft Dynamics AX 
·         Period End in Microsoft Dynamics AX 
·         Fixed Asset Setup in Microsoft Dynamics AX 
·         Fixed Asset Depreciation in Microsoft Dynamics AX 
·         Fixed Asset Management in Microsoft Dynamics AX 
·         Fixed Asset Transaction in Microsoft Dynamics AX

Training SCADA SYSTEM (Supervisory Control And Data Acquisition)


SCADA SYSTEM (Supervisory Control And Data Acquisition)

Duration : 5 Days (09.00 – 16.00)

Description :

The term SCADA stands for Supervisory Control And Data Acquisition. SCADA system is a common process automation system which is used to gather data from sensors and instruments located at remote sites and to transmit and display this data at a central site for control or monitoring purposes.

Objectives :

·         List and summarize architectures of modern SCADA systems and their technical keywords, explain the working principles and their interaction between components of modern SCADA systems.
·         Summarize and list characteristics of Tag in general from SCADA software, and explain the functions of these characteristics in the systems.
·         State descriptions and functions of elements in Human-Machine Interfaces. Create Human – Machine Interfaces using appropriate tools.
·         Explain the working principles of connection between SCADA software with control devices using direct drivers. Use given SCADA software to implement the connection with appropriate PLCs using direct driver approach.
·         Explain the working principles of connection between SCADA software with control devices using DDE mechanism. Use given SCADA software to implement the connection with appropriate PLCs using DDE mechanism.
·         Explain the working principles of connection between SCADA software with control devices using OPC technology. Use given SCADA software to implement the connection with appropriate PLC using OPC technology.
·         Describe characteristics of Events & Alarms, Trends and Reports in SCADA, create Events & Alarms, Trend and Reports for a given project.

Participants :
·         Industrial Staff
·         Industrial Supervisor
·         PLC Programmer

Prerequisites :
-       Understanding of industrial system and Control
-       Basic Knowledge of PLC Programming

Topics include:

  1. Introduction
  2.  Industrial Automation Basics
  3.  Basic Knowledge
  4.  Programmable Logic Controllers (PLC)
  5.  Data & Communications
  6.  PLC & IntegraXor
  7.  Project overview
  8.  Project Management
  9.  Running the Project
  10.  Graphical Animation
  11.  Inkscape SAGE
  12.  Web Buttons
  13.  Slider Movement
  14.  Visibility
  15.  More Animations
  16.  Server-side Scripting
  17.  Client-side Scripting
  18.  Many side scripting
  19.  Inkscape SAGE Script
  20.  HTML Basics
  21.  Database


PURNAMA ACADEMY 0838-0838-0001


Duration : 3 Days (09.00 – 16.00)

Description :

Training Microsoft Excel Advanced Tips and Trick adalah training yang membahas cara cepat menyelesaikan berbagai studi kasus menggunakan kombinasi fitur fitur yang tersedia di Microsoft Excel

Objectives :
Melalui Training ini diharapkan
·         Peserta mampu menguasai teknik cepat mengolah data dan pembuatan pelaporan, peserta dihadapkan dengan 100% studi kasus langsung
·         Membuat otomatisasi pelaporan dengan macro

Participants :
·         Finance Staff
·         IT Staff

Prerequisites :
-       Basic Knowledge of Microsoft Excel

Topics include:

  1. Mengunakan format as table , cells style , auto calculation
  2. Memanfaatkan Flash Fill untuk memecah data
  3. Menggunakan Advanced Filter dan Advanced Sort
  4. Advanced Conditional Formating
  5. Menggunakan Protect and Share Workbook
  6. Vlookup vs Index Match
  7. Menggunakan Custom Format Cell
  8. Menggunakan Fitur consolidate dan what if analysis
  9. Mengakses data secara realtime dari database
  10. Menggunakan Pivot Table ,Power Pivot dan PowerView Untuk membuat dashboard yang dinamis
  11. Menggunakan Trace Presedence
  12. Menggunakan Sub Totals dan Group
  13. Menggunakan Shortcut Key Populer
  14. Membuat User Defined Function (UDF)
  15. Melakukan otomatisasi menggunakan macro