Centennial Tower

5F, Jl. Gatot Subroto No.24-25, RT.2/RW.2, Karet Semanggi, Kecamatan Setiabudi, Kota Jakarta Selatan, Daerah Khusus Ibukota, Jakarta Selatan, Indonesia, 12930

Grand Slipi Tower

Jl. Letjen S. Parman No.24, RT.1/RW.4, Palmerah, Kec. Palmerah, Kota Jakarta Barat, Daerah Khusus Ibukota Jakarta , Jakarta Barat, Indonesia, 11480

The City Tower

12F, Jl. M.H. Thamrin No.81, Dukuh Atas, Menteng, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus Ibukota , Jakarta Pusat, Indonesia, 10310

Explore Our Courses

Visual Basic for Applications (VBA) in Excel - Advanced

 14 Hours
The course reveals the secrets of effective writing advanced applications in VBA application MsExcel. This instructor-led, live training (online or onsite) is aimed at data analysts who wish to use advanced VBA in Excel for automating tasks. By the end of this training, participants will be able to:
  • Write an advanced object-oriented application
  • Convert text files
  • Use of external data sources
  • Use external libraries
Format of the Course
  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.
Course Customization Options
  • To request a customized training for this course, please contact us to arrange.
Read more...

Visual Basic for Applications (VBA) in Excel - Introduction to programming

 21 Hours
It is an introduction to procedural programming in VBA. Training allows you to gain a strong foundation for further learning and VBA environment. This instructor-led, live training (online or onsite) is aimed at data analysts who wish to use VBA in Excel for automating tasks. By the end of this training, participants will be able to:
  • Record and edit macros as required.
  • Write procedures using data from the sheet.
  • Create your own functions.
  • Handle an event (opening worksheet cell update etc.) by means of the handler.
  • Create a form.
Format of the Course
  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.
Course Customization Options
  • To request a customized training for this course, please contact us to arrange.
Read more...

Excel VBA Introduction

 14 Hours
It is an introduction to procedural programming in VBA. Training allows you to gain a strong foundation for further learning and VBA environment. This instructor-led, live training (online or onsite) is aimed at data analysts who wish to use VBA in Excel for automating tasks. By the end of this training, participants will be able to:
  • Record and edit macros as required.
  • Write procedures using data from the sheet.
  • Create your own functions.
  • Handle an event (opening worksheet cell update etc.) by means of the handler.
  • Create a form.
Format of the Course
  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.
Course Customization Options
  • To request a customized training for this course, please contact us to arrange.
Read more...

Data and Analytics - from the ground up

42 Hours
Data analytics is a crucial tool in business today. We will focus throughout on developing skills for practical hands on data analysis. The aim is to help delegates to give evidence-based answers to questions: What has happened?
  • processing and analyzing data
  • producing informative data visualizations
What will happen?
  • forecasting future performance
  • evaluating forecasts
What should happen?
  • turning data into evidence-based business decisions
  • optimizing processes
The course itself can be delivered either as a 6 day classroom course or remotely over a period of weeks if preferred. We can work with you to deliver the course to best suit your needs.
Read more...

Excel Advanced with VBA

 21 Hours
Participants will be able to excel themselves, in the most optimal way to create, consolidate and manage data. A number of tools designed to streamline the work often significantly reduces the time to activities carried out so far and can help you design an application that could perform new tasks.
Read more...

Visual Basic for Applications (VBA) in Excel (intermediate level)

 14 Hours
Course is intended for those familiar the basics of VBA who want to develop their knowledge and greater use of language capabilities.
Read more...

Excel and VBA Programming for Audit and Finance Professionals

 28 Hours
Please answer the following questions:
  • Is your daily work in Excel is a never-ending string of commands copy-paste?
  • Are you wasting time on repetition of similar operations to prepare the data for analysis?
  • Do you know all the keyboard shortcuts in Excel, but you are not satisfied with the results?
  • Rather than deal with data analysis and preparation of wasting time?
  • Do you have to manually verify the correctness of such data obtained from different systems?
  • Do you have to stay at work after hours or Excel to take books home because not doing during the day?
  • Is Your job is to prepare reports based on a large data set?
  • Do you feel that working in Excel, you come to a roundabout way of results?
If you can answer YES to one of the questions then it's time stop this nightmare. This training is for you. Find out how you can speed up your daily operations and get most out of MS Excel. WARNING After the training, your life will change dramatically. Activities, which occupied the whole day will take just a few moments. Are you ready for this?
Read more...

Last Updated:

Testimonials (5)

Showing examples, pictorial way of translating

Aneta - LKQ Polska Sp. z o. o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)

Machine Translated

exhaustion of topics

Karol - VOLKSWAGEN POZNAŃ SP. Z O.O.
Course - Excel Advanced with VBA

Machine Translated

I like the hands on training and seeing us solve for issues on the spot.

Jon Matrille - LocumTenens.com
Course - Visual Basic for Applications (VBA) in Excel - Advanced

Working on and using our own data/spreadsheets, where we could see how it would benefit us most.

Julie - Environment, Marine and Fisheries
Course - Excel VBA Introduction

I really was benefit from the real life practical examples.

Wioleta
Course - Data and Analytics - from the ground up

Upcoming Courses

Other regions in Indonesia

Other Countries

These courses are also available in other countries
Online Excel VBA Pelatihan pada Jakarta, Excel VBA kursus pelatihan pada Jakarta, Akhir pekan Excel VBA Pelatihan pada Jakarta, Excel VBA pelatihan pada Jakarta, Excel VBA Instruktur Kepala pada Jakarta, Akhir pekan Excel VBA Pelatihan pada Jakarta, Excel VBA kelas pada Jakarta, Excel VBA pelatihan satu lawan satu pada Jakarta, Excel VBA kamp pelatihan pada Jakarta, Excel VBA instruktur kepala pada Jakarta, Excel VBA kursus privat pada Jakarta, Excel VBA di-tempat pada Jakarta, Excel VBA instruktur pada Jakarta, Online Excel VBA Pelatihan pada Jakarta, Selamat malam Excel VBA Pelatihan pada Jakarta, Excel VBA Pelatihan pada Jakarta