dibuka Program Training Online / Webinar !

Tetap bisa training sekalipun #diRumahAja

PUBLIC TRAINING - PURNAMA ACADEMY

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

REQUEST FOR INHOUSE TRAINING

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

PORTFOLIO : INHOUSE TRAINING ANDROID - PLN MALUKU

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

PORTFOLIO : INHOUSE TRAINING MAGENTO - INFOTECH JAKARTA

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

Friday, March 26, 2021

TRAINING POWER BI BERSAMA DISHUB KOTA BANDUNG

Training Microsoft Power BI Bersama Bapak Ridho dari Dishub Bandung yang diselenggarakan di Meeting Office Purnama Academy Bandung dengan tetap mengutamakan protokol kesehatan, terima kasih semoga bermanfaat.

Wednesday, March 24, 2021

EXCEL VBA MACRO , SILABUS , JADWAL TRAINING PURNAMA ACADEMY

Berikut Silabus training Excel VBA Macro yang diselenggarakan oleh Purnama Academy , tersedia metode pelatihan Online/ Offline / Inhouse training di jakarta, bandung, surabaya, dan beberapa kota besar lainnya di indonesia, silahkan hubungi tim sales Purnama Academy 0838-0838-0001 (Call/ Whatsapp) untuk mengetahui detail , jadwal dan biaya training serta mekanisme pendaftaran training

 


EXCEL VBA MACRO PROGRAMMING

Durasi

:

3 Hari (09.00 – 16.00) – Online/ Offline / Inhouse

 

 

 

Deskripsi

:

Microsoft® Excel Macro adalah sebuah tool yang dapat membuat pekerjaan menjadi lebih mudah untuk ditangani, di share, dan dibaca. Fungsi utama  bahasa Macro untuk mengefesienkan langkah dalam pembuatan report di MS Excel hingga cukup dengan satu klik saja.  Visual Basic Application merupakan bahasa yang powerful untuk mempermudah proses kerja dari awalnya terdiri beberapa langkah menjadi cukup satu langkah saja. Sekarang Anda tidak lagi frustrasi dalam membuat dokumen, reports, kalkulasi dan juga project.

 

 

 

Tujuan Training

:

Melalui training ini diharapkan peserta setelah selesai dapat membuat excel macro untuk meningkatkan kemampuan file excel nya dengan bekal  pengetahuan :

1.        Mengenal Konsep Pembuatan Macro and VBA

2.        Cara Record, Store and Run a Macro

3.        Membuat Procedure, Functions, Event Programming Handling Errors

4.        Membuat Object Form dalam Macro

5.        Automation antar workbook

6.        Membuat User Defined Function dan AddOns Excel sendiri

 

 

 

Target Peserta

:

1.        Office Staff

2.        Data Analyst

3.        Desktop Programmer

4.        Public

 

 

 

Prasyarat

:

Memiliki pengetahuan mendalam di Microsoft Excel

 

 

 

Materi Training

:

 

I.                     Persiapan               

              Developer Ribbon  

              Macro Security       

              Macro Enabled Workbook (.xlsm)         

II.             Recording Macro   

              Record Macro        

              Manage Macro      

              Relative References              

              Edit Macro             

III.            VBE, Module & Procedures   

              Mengakses VBE     

              Module   

              Procedures             

IV.            Object & Addressing              

              Object Addressing 

V.             Property Format    

              Format menggunakan .Address            

VI.            With … End With   

              Penggunaan With.. End With

VII.           Formula R1C1        

              Penggunaan R1C1  

VIII.          Variable 

              Fase Variable         

              Local Variable        

              Public Variable       

              Constant Variable  

              Object Variable      

IX.            Inputbox 

              Penggunaan Inputbox            

X.             Conditional If         

              Penggunaan Conditional IF    

              UCASE/LCASE  Function        

XI.            User Defined Function (UDF)

              Pembuatan UDF    

XII.           Msgbox  

              Penggunaan Msgbox             

XIII.          Anatomi Script & Project Password      

              Anatomi script       

              Project Password   

XIV.         Subrutin & Error Handling     

              Penggunaan SUBRUTIN        

              Penggunaan ERROR HANDLING           

XV.          Array & Looping     

              Jenis Array

·                     Jenis Looping         

              For .. Next              

              Do... Loop               

              isEmpty function    

XVI.         Object Form & Control          

              Form      

              Toolbox  

              Lable      

              Textbox  

              Enabled = False     

              ComboBox              

              Command Button  

              TabIndex Property  

              Text Property         

              Event & Private Sub               

XVII.        Run Macro from Excel          

              Menambahkan Control Button Form di Sheet

 

 

 

IBM Cognos Analytics Silabus , Jadwal Training, Tempat Pelatihan

Training Syllabus IBM Cognos Analytics Fundamental in Purnama Academy (IT & Management Training), Please call/whatsapp to : 0838-0838-0001 for details and registration, Purnama Academy menyediakan metode pelatihan IBM Cognos Analytics secara online, offline (Tatap muka) ataupun inhouse training di Jakarta, Bandung, Bogor, Surabaya, Yogya dan seluruh kota di indonesia



IBM Cognos Analytics Fundamental

 

Durations : 4 Days (09.00 – 16.00)

Method     : Online/ Offline/ Inhouse Training

Description

The latest version of IBM Cognos Business Intelligence is Cognos Analytics and it brings IBM right back into the game against new-age competitors such as QlikView and Tableau. This sleek, next-generation, unified tool provides you with a fast, intent-driven dashboard and report-authoring interface on top of the strong foundation that IBM Cognos has provided over decades.

The highlights of this Learning Path are
Explore Cognos and it’s high level architecture
Augment enterprise data with your offline data to produce stunning dashboards and presentations without IT costs
Learn to secure your data with advanced filters

 


What you'll learn

Learn to build stunning Dashboards with Cognos Analytics
Learn how and when to use visualization
Create tabbed dashboards and stories using the new Dashboard tool of Cognos
Master the full-fledged Report Authoring tool
Understand how a dashboard is different from a report, and when to use both
Understand the Reporting Interface
Implement crosstabs and SQL queries

Requirements

-      Basic knowledge of data and relationship between variety of data

-      IBM Cognos Analytics  CloudTrial Account

Who this course is for

This Learning Path is targeted at
Accountants, managers, controllers, sales heads, and so on will find this Learning Path useful for their day to day work and career progression
Developers, business analysts, testers, product owners of reporting system / data warehouse / MIS can use Cognos Analytics (Cognos) to author dashboards and stories within IT department

 

Course content

Day 1

PRETEST

INTRODUCTION

·         IBM Cognos Analytics Overview

·         Reports Versus Dashboards

·         Detailed Properties of Visualizations

·         Drill-Through to Another Report

·         Master-Detail Relationship/Repeaters

·         Case Study

REPORT INTERFACE

·         Opening the Report Interface

·         Adding Data

·         Adding Report Pages and Prompt Pages

·         Using Toolbox

·         Crosstab in Detail

·         Case Study Continue

Day 2

CROSSTABS AND SQL QUERIES

·         Nested Crosstab

·         Discontinuous Crosstab

·         Examining and Overriding SQL Queries

·         Crosstabs and SQL Queries

·         Case Study Continue

 

Day 3
FILTERING

·         Populating Values in Prompt Control

·         Using Prompt Parameters

·         Mandatory and Optional Prompts

·         Cascading Prompt

·         Prompts on Report Page

·         Case Study Continue

VISUALIZATIONS

 

·         Difference between Charts and Extensible Visualizations

·         Heatmap Visualization

·         Gauge Control

·         Sparkline

·         Case Study Continue

 

Day 4
DRILL-THROUGH AND MASTER DETAIL RELATIONSHIP

·         Container within Container

·         Drill-Through to Another Report (Drill-Through Links)

·         Finishing Touches

·         Drill-Through and Master-Detail Relationship

·         Case Study Final

POST TEST

Trainer : Purnama Academy Trainer

Next Training Recommendation : IBM COGNOS ANALYTICS ADVANCED