CREATE ACCOUNT

Inixindo MakassarInixindo Makassar

Open hours: Mn - Fr: 8:00am - 17:00pm /Saturday & Sunday: Closed
  • Member
  • Keluar
  • Home
  • Profil
  • Trainings
    • Networking
    • Programming
    • Database
    • IT Security
    • Data Center
    • Office Application
    • IT Management
    • Virtualization
  • Sertifikasi
  • Jadwal Training
  • Hubungi Kami
  • Artikel

Microsoft Office Access 2013 : Part 2

  • 0
Senin, 01 Januari 2018 / Published in Office Application

Your training and experience using Microsoft® Access® 2013 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2013 will result in a robust, functional database for your users.

You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access 2013.
AccessMicrosoft

Sertifikasi MCSA : Web Application

  • 0
Senin, 01 Januari 2018 / Published in Programming

1. PROGRAMMING IN HTML5 WITH JAVASCRIPT AND CSS3

 Pelatihan ini memberikan pengenalan tentang HTML5, CSS3, dan JavaScript. Pelatihan ini membantu peserta menambah pengetahuan dasar programing HTML5/CSS3/JavaScript. Pelatihan ini merupakan langkah awal dalam track pembuatan aplikasi Web dan aplikasi Windows Store. Peserta akan focus pada penggunaan HTML5/CSS3/JavaScript untuk menerapkan logika pemrograman, definisi dan penggunaan variable, looping dan branching, halaman interface, validasi input data, menyimpan data dan pembuatan struktur aplikasi yang baik. Pelatihan ini menggunakan Visual Studio 2012.

 Sertifikasi

Peserta akan mendapatkan sertifikasi MCSA dengan mengikuti pelatihan & exam :

  • Programming in HTML5 with JavaScript and CSS3
  • Developing ASP.NET MVC 4 Web Applications

Tujuan Pelatihan

  • Mampu menjelaskan bagaimana menggunakan Visual Studio 2012 untuk membuat dan menjalankan aplikasi Web
  • Mendeskripsikan fitur HTML5 dan membuat halaman HTML5
  • Membuat halaman menjadi interaktif dengan JavaScript
  • Dapat membuat form HTML5 dengan bentuk inputan yang berbeda-beda dan memvalidasi data inputan
  • Mengirim dan menerima datamenggunakan XMLHTTPRequest objects dan JQuery AJAX operations
  • Style HTML5 menggunakan CSS3
  • Membuat aplikasi web yang mendukung operasi offline
  • Membuat halaman web HTML5 yang responsive
  • Menggunakan socket untuk mengirim dan menerima data antara web dan server

Garis Besar Pelatihan

  1. Modul 1: Pengenalan HTML dan CSS
  2. Modul 2: Membuat dan menghias halaman HTML5
  3. Modul 3: Pengenalan JavaScript
  4. Modul 4: Membuat form untuk mendapatkan data dan melakukan validasi
  5. Modul 5: Komunikasi dengan remote data source
  6. Modul 6: Menghias HTML5 dengan menggunakan CSS3
  7. Modul 7: Membuat objek dan metode menggunakan JavaScript
  8. Modul 8: Membuat halaman interaktif menggunakan HTML5 APIs
  9. Modul 9: Menambah dukungan ofline untuk aplikasi web
  10. Modul 10: Menerapkan halaman user yang fleksibel
  11. Modul 11: Membuat grafik
  12. Modul 12: Membuat animasi
  13. Modul 13: Menerapkan komunikasi real-time menggunakan Web-Sockets
  14. Modul 14: Membuat proses Web Worker

Siapa Yang Perlu Hadir?

  • Pelatihan ini ditujukan untuk pengembang web yang sudah memiliki pengalaman programing 6-12 bulan dan yang tertarik belajar HTML5,JavaScript dan CSS3.
  • Pengembang aplikasi yang akan melakukan ujian 70-480 mengenai HTML5, JavaScript dan CSS3.

Prasyarat Pelatihan

Pelatihan ini disarankan untuk peserta yang memiliki pengetahuan dan keahlian antara lain:

  • Memahami struktur dasar HTML
  • Memahami bagaimana membuat CSS
  • Mengerti bagaimana menulis JavaScript

Durasi Pelatihan

5 Hari


2. DEVELOPING ASP.NET MVC 4 WEB APPLICATIONS

Pelatihan ini akan memberikan pengetahuan dan keterampilan kepada peserta pelatihan dalam hal membangun aplikasi web MVC ASP.Net menggunakan teknologi .Net Framework 4.5. Pelatihan akan difokuskan kepada meningkatkan performance dan skalabilitas aplikasi web. MVC ASP.Net akan dikenalkan dan dibandingkan dengan Web Form sehingga dapat mengetahui kapan harus menggunakan web form atau MVC.

 Sertifikasi

Peserta akan mendapatkan sertifikasi MCSA dengan mengikuti pelatihan & exam :

  • Programming in HTML5 with JavaScript and CSS3
  • Developing ASP.NET MVC 4 Web Applications

Tujuan Pelatihan

  1. Mampu mendeskripsikan teknologi web Microsoft dan memilih teknologi yang sesuai untuk digunakan membangun aplikasi web.
  2. Mampu mendesain arsitektur dan implementasi aplikasi web yang sesuai dengan fungsi, user interface yang dibutuhkan dan bisnis model yang diinginkan.
  3. Mampu membuat Model MVC dan menulis kode yang mengimplementasikan business logic di dalam Model yang meliputi method, property dan event.
  4. Mampu membuat Controller MVC untuk mengelola interaksi user, update model dan memilih View.
  5. Mampu membuat View di dalam MVC yang menampilkan dan mengedit data dan berinteraksi dengan Model dan Controller.
  6. Mampu menjalankan test unit dan debugging sebuah aplikasi web di Visual Studio 2012 dan mengkonfigurasi sebuah aplikasi untuk troubleshooting.
  7. Mampu membangun sebuah aplikasi web yang menggunakan ASP.Net routing engine untuk menampilkan URL yang friendly dan suatu hirarki navigasi kepada user.
  8. Mampu menerapkan suatu tampilan dan rasa termasuk branding perusahaan, melalui suatu aplikasi web MVC.
  9. Mampu menggunakan partial page yang melakukan update dan caching untuk menurunka penggunaan bandwidth yang digunakan oleh aplikasi dan mempercepat respon terhadap request user.
  10. Mampu menulis kode Javascript yang dijalankan di sisi client dan menggunakan script library Jquery untuk mengoptimalkan respon dari aplikasi web MVC.
  11. Mampu menerapkan sistem membership yang lengkap di dalam aplikasi web MVC.
  12. Mampu membangun aplikasi MVC yang tahan terhadap serangan dan memberikan informasi tentang user dan kelengkapannya.
  13. Mampu mendeskripsikan bagaimana menulis kode ke dalam layanan web Windows Azure dan memanggilnya dari sebuah aplikasi MVC.
  14. Mampu mendeskripsikan tentang Web API dan mengapa developer menambahkan suatu Web API ke dalam aplikasi.
  15. Mampu memodifikasi cara browser merequest dan dihandle oleh aplikasi MVC.
  16. Mampu mendeskripsikan bagaimanan membuat paket deploy sebuah aplikasi web MVC ASP.Net dari komputer development ke suatu web server untuk production.

Siapa Yang Perlu Hadir?

  • Web Developer

Prasyarat Pelatihan

Pelatihan ini disarankan untuk peserta yang memiliki pengetahuan dan keahlian antara lain:

  • Peserta harus memiliki pengetahuan dasar tentang pemrograman berbasis ASP.NET
  • Peserta harus memiliki pengetahuan dasar tentang pemrograman berbasis C#

Durasi Pelatihan

5 Hari

MicrosoftVisual Studio

Data Analysis Fundamentals Using Excel

  • 0
Senin, 01 Januari 2018 / Published in Office Application

Course Duration: 2 Days

About This Course
Training Data Analysis Fundamentals using Excel (Microsoft Official Curriculum). The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets.

Audience Profile
This course is intended for anyone responsible for analyzing data with Excel

At Course Completion
After completing this course, students will be able to:

  • Create an Excel report
  • Create an Excel table
  • Create a pivot table and pivot chart
  • Create a dashboard and analyze data
  • Create Hierarchies
  • Create an Excel data model and connect to external data

Prerequisites
Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Basic Knowledge of Excel spreadsheets

Course Outline

Module 1: Reporting in Excel
This module explains how to create a report in Excel
Lessons

  • Filtering and Formatting Data
  • Charts

Lab: Create an Excel report

  • Filtering Excel Data
  • Formatting Excel Data
  • Create excel Charts

After completing this module, students will be able to:

  • Filter and format data.
  • Create charts.

Module 2: Excel Tables
This module explains how to create data tables in Excel
Lessons

  • Excel Data Tables
  • Summarizing Data

Lab: Create an Excel Table

  • Create an Excel Table
  • Summarize Excel Data

After completing this module, students will be able to:

  • Explain what Excel Data tables are.
  • Sort, filter, and validate data.
  • Summarize data.
  • Format summarized data.

Module 3: Pivot Tables and Pivot Charts
This module describes pivot tables and pivot charts and how to work with them.
Lessons

  • Pivot Tables
  • Pivot Charts
  • Editing Pivot Tables and Pivot Charts

Lab: Importing Data from a CSV File

  • Creating a Pivot Table
  • Creating a Pivot Chart
  • Editing Pivot Tables and Pivot Charts

After completing this module, students will be able to:

  • Describe pivot tables and how to create them.
  • Describe the various elements of a pivot chart.
  • Edit pivot tables and pivot charts.

Module 4: Dashboards
This module describes Excel dashboards, how to create them and the role in data analysis in Excel pivot
tables.
Lessons

  • Creating a Dashboard
  • Data Analysis in Excel Pivot Tables

Lab: Create a Dashboard

  • Arranging Tables and Charts
  • Slicing Data
  • Data Analysis

After completing this module, students will be able to:

  • Describe a dashboard.
  • Filter data using a slicer.
  • Add calculated columns to a dashboard.
  • Find anomalies.

Module 5: Hierarchies
This module describes hierarchies and time data.
Lessons

  • Hierarchies
  • Time Data

Lab: Creating Hierarchies

  • Create a Hierarchy
  • Configure Time data
  • Create an Animated Time Chart

After completing this module, students will be able to:

  • Describe hierarchies.
  • Create levels within a hierarchy.
  • Explain why time data is different and how to work with it.

Module 6: The Excel Data Model
This module explores the Excel data model and looks at ways of extending it.
Lessons

  • Using an Excel Data Model
  • External Data

Lab: Explore an Excel Data Model

  • Add Multiple Tables
  • Create Relationships
  • Add External Data

After completing this module, students will be able to:

  • Explain an Excel Data Model and how to use it.
  • Import External Data and use it.
  • Link out to external data.
ExcelMicrosoft

Analyzing Data With Excel

  • 0
Senin, 01 Januari 2018 / Published in Office Application

Course Duration: 3 Days

About This Course
Training Analyzing Data with Excel (Microsoft Official Curriculum) The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

Audience Profile
This course is intended for anyone responsible for analyzing data with Excel.
The course will likely be attended by SQL Server report creators who are interested in alternative
methods of presenting data.

At Course Completion
After completing this course, students will be able to:

  • Explore and extend a classic Excel dashboard.
  • Explore and extend an Excel data model.
  • Pre-format and import a .CSV file.
  • Import data from a SQL Server database
  • Import data from a report.
  • Create measures using advanced DAX functions.
  • Create data visualizations in Excel.
  • Create a Power BI dashboard with Excel.

Prerequisites
Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Good Knowledge of Excel spreadsheets, functions, and charts.
  • Working knowledge of relational databases

Course Outline

Module 1: Data Analysis in Excel
This module looks at the classic Excel dashboard and at ways to extend it.
Lessons

  • Classic Data Analysis with Excel
  • Excel Pivot Tables
  • Limitations of Classic Data Analysis

Lab: Building a Classic Excel Dashboard

  • Filtering and Formatting Data
  • Building a Pivot Table
  • Building a Pivot Chart
  • Building a Dashboard

After completing this module, students will be able to:

  • Describe classic data analysis with Excel
  • Describe Excel pivot tables
  • Describe the limitations of classic data analysis with Excel

Module 2: The Excel Data Model
This module looks at the classic Excel data model and at ways to extend it.

  • Using an Excel Data Model
  • DAX

Lab: Explore an Excel Data Model

  • Create Calculated Columns
  • Format Data Model Data
  • Create Measures
  • Analyze the Data

After completing this module, students will be able to:

  • Describe an Excel data model
  • View data within an Excel data table
  • Describe DAX

Module 3: Importing Data from Files
This module looks at pre-formatting and importing CSV files.

  • Importing Data into Excel
  • Shaping and Transforming Data
  • Loading Data

Lab: Importing Data from a CSV File

  • Import and Transform Data from a CSV File
  • Add Data from a Folder

After completing this module, students will be able to:

  • Import data into excel.
  • Shape and transform data.
  • Load data.

Module 4: Importing Data from Databases
This module looks at how to import data into Excel from a SQL Server database.
Lessons

  • Available Data Sources
  • Previewing, Shaping, and Transforming Data
  • Table Relationships and Hierarchies
  • Loading Data

Lab: Import Data from Multiple Sources

  • Import Data from SQL Server
  • Import Data from a CSV File
  • Create a Data Table

After completing this module, students will be able to:

  • Identify available data sources.
  • Preview, shape, and transform data.
  • Explain table relationships and hierarchies.
  • Load data from various sources.

Module 5: Importing Data from Excel Reports
This module describes how to import data from a report.
Lessons

  • Importing Data from Excel Reports
  • Transforming Excel report Data

Lab: Importing Data from a Report

  • Import Data from Excel
  • Transform the Excel Data
  • Load the Data into an Excel Data Model

After completing this module, students will be able to:

  • Import data from Excel reports.
  • Transform Excel report data.

Module 6: Creating and Formatting Measures
This module describes how to create and format measures.
Lessons

  • DAX
  • Measures
  • Advanced DAX Functions

Lab: Creating Measures using Advanced DAX Functions

  • Last year comparison
  • Year to date
  • Market Share

After completing this module, students will be able to:

  • Explain what DAX is and when to use it.
  • Describe a measure.
  • Use some of the advanced functions within DAX.

Module 7: Visualizing Data in Excel
This module describes how to visualize data in Excel.
Lessons

  • Pivot Charts
  • Cube Functions
  • Charts for Cube Functions
  • Lab: Data Visualization in Excel
  • Create a Tabular Report
  • Create a Pivot Chart
  • Add Slicers to Charts

After completing this module, students will be able to:

  • Create and refine a pivot chart.
  • Describe cube functions and when to use them.
  • Describe a number of charts for use with cube functions.

Module 8: Using Excel with Power BI
This module describes how to use Excel with Power BI.
Lessons

  • Power BI
  • Uploading Excel Data to Power BI
  • Power BI Mobile App

Lab: Creating a Power BI Dashboard with Excel

  • Uploading Excel Data
  • Creating a Power BI Dashboard

After completing this module, students will be able to:

  • Describe Power Bi and the various versions available.
  • Upload Excel data to Power BI.
  • Describe the Power BI App.
ExcelMicrosoft

Microsoft Office Word 2013 : Part 1

  • 0
Senin, 01 Januari 2018 / Published in Office Application

These days, most people take electronic word-processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It’s impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you’ll need to know the ins and outs of electronic word-processing.

Microsoft® Word 2013 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you’ll learn how to use Word 2013 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.

You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Word 2013.

MicrosoftWord
  • 1
  • 2
  • 3

PT. INIXINDO MAGGURU MACCA CEMERLANG

IT Learning and Certification Services
Jl. Nikel I Blok A.22 No. 18 Makassar 90222
South Sulawesi - Indonesia

OPEN HOURS

Monday - Friday. From 8:00am to 5:00pm
Saturday and Sunday: Closed

Phone : 0411 445 944
Info dan Registrasi Via Whatsapp
0811 445 944
Email : salesmks@inixindo.co.id

LSP LPK INIXINDO

  • Pengadministrasian Database
  • Pengadministrasian Keamanan Jaringan
  • Pengelolaan Layanan Teknologi Informasi
  • Pemrograman
  • Pengadministrasian Infrastruktur E-Government
  • Pengelolaan Keamanan Informasi
  • Pengelolaan Data Center
  • Pengembangan Mobile Application
  • Analisis Cloud Computing

Copyright © 2019 PT.Inixindo Magguru Macca Cemerlang - All rights reserved

TOP