Jungang-Dong Center

Jung-Gu, 102, Jungang-daero, 7/F., PanOcean Building, Busan, korea, 48938

Busan Jungang-dong Centre is located on the 7th floor of PanOcean B/D in which many tenants are forwarding companies, shipping firms, and conglomerates like Hyundai marine, Woori bank, Shinhan investment, Joongang newspaper. Jungang-dong is one of the main business districts in Busan, so there are many foreign consulates, financial corporations, hotels, shipping companies, etc. The building is situated with good visibility in the centre of the traditional CBD area in Busan,100 meters from Jungang subway, 5 minutes walk to Busan International Ferry Terminal, and 4 minutes drive to Busan KTX Station or Nampo-dong downtown area.

Explore Our Courses

Visual Basic for Applications (VBA) in Excel - Advanced

 14 Hours
This instructor-led, live training in Busan (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
Read more...

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

 21 Hours
This instructor-led, live training in Busan (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.
Read more...

VBA For Access & Excel

 21 Hours
The objective of the course is to enable participants to gain a mastery of the fundamentals and usages of VBA for Access & Excel.
Read more...

Excel VBA in One Day

 7 Hours
This live instructor-led training (onsite or remote) will guide you through the most important elements of  Excel VBA. A combination of comprehensively prepared training materials and the expertise of the instructor will demonstrate the power of task automation using VBA. Format of the Course
  • Interactive lecture and discussion.
  • Hands-on implementation in a live-lab environment.
Course Customization Options
  • To request a customized training, please contact us.
Read more...

Access VBA

 21 Hours
The training discusses issues related to programming in Visual Basic for Applications and presents ways of accessing data using VBA. The training participants also learn the mechanisms that allow them to write a professional database application.
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...

Visual Basic for Applications (VBA) for Analysts

 21 Hours
The course is designed for users of Excel for creating analyzes and reports.
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 (6)

There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.

Aleksander Jarecki - Amazon Development Center Poland Sp. z o.o.

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

Training Room and quite location and all the stuff.

Abdullah Adelyar - USAID - Kabul Afghanistan

Course - Access VBA

I generally enjoyed the practical examples.

Marika Agius

Course - Visual Basic for Applications (VBA) for Analysts

Content and the way it was provided.

Marcin Samborski

Course - Visual Basic for Applications (VBA) in Excel - Advanced

Training agenda was well thought out.

Przemek Zalasinski

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

I liked the examples and the way he explained.

Sandeep Parashar

Course - VBA For Access & Excel

Upcoming Courses

VBA For Access & Excel

2025-05-26 10:00
21 hours
Jungang-Dong Center
₩ 7500000 (Online)
₩ 15000000 (Classroom)

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

2025-06-05 10:00
14 hours
Jungang-Dong Center
₩ 5000000 (Online)
₩ 10000000 (Classroom)

Excel and VBA Programming for Audit and Finance Professionals

2025-06-23 10:00
28 hours
Jungang-Dong Center
₩ 10000000 (Online)
₩ 20000000 (Classroom)

Visual Basic for Applications (VBA) in Excel - Advanced

2025-07-03 10:00
14 hours
Jungang-Dong Center
₩ 5000000 (Online)
₩ 10000000 (Classroom)

Excel Advanced with VBA

2025-07-21 10:00
21 hours
Jungang-Dong Center
₩ 7500000 (Online)
₩ 15000000 (Classroom)

Other regions in South Korea

Other Countries

These courses are also available in other countries
Online VBA training in Busan, VBA training courses in Busan, Weekend VBA courses in Busan, Evening VBA training in Busan, VBA instructor-led in Busan, Weekend VBA training in Busan, VBA boot camp in Busan, VBA on-site in Busan, VBA one on one training in Busan, Online VBA training in Busan, Evening VBA courses in Busan, VBA instructor in Busan, VBA classes in Busan, VBA trainer in Busan, VBA private courses in Busan, VBA instructor-led in Busan, VBA coaching in Busan