Explore Our Courses

Visual Basic for Applications (VBA) in Excel - Advanced

14 Hours
This instructor-led, live training in Hong Kong (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 Hong Kong (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...

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(19)

exhaustion of topics

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

Machine Translated

The pace of classes is perfect, not too fast, not too slow, lots of examples and exercises. Each participant could freely perform the exercises without any pressure to answer questions. Everyone could act in their own time, and in case of a failed attempt, you could catch up when the trainer showed the solution.

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

Machine Translated

Perfect preparation of the host who didn't think about what he wanted to show, just went according to plan and explained everything perfectly. Great knowledge, great willingness to present issues, answers to questions allowed to understand the problem and solve it. His vast knowledge is evident from years of work.

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

Machine Translated

overall perfect. In every respect, whether it's the knowledge or the way of transmitting this knowledge, it's amazing.

Bartosz
Course - Excel Advanced with VBA

Machine Translated

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

The instructor's interaction with the participants, knowledge, openness to discussion and ideas.

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

Machine Translated

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)

I really was benefit from the real life practical examples.

Wioleta
Course - Data and Analytics - from the ground up

I mostly liked the patience of Tamil.

Laszlo Maros
Course - Data and Analytics - from the ground up

Tamil is very knowledgeable and nice person, I have learned from him a lot.

Aleksandra Szubert
Course - Data and Analytics - from the ground up

Detailed and comprehensive instruction given by experienced and clearly knowledgeable expert on the subject.

Justin Roche
Course - Data and Analytics - from the ground up

The way the trainer made complex subjects easy to understand.

Adam Drewry
Course - Data and Analytics - from the ground up

A lot of exercise. Trainer doesn't need to have support for his course. He has really great knowledge for his subject.

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

It was really nice of the trainer that he took a lot of time to answer our questions and helped us improve or gave us hints on how to improve some macros we were already using without fully understanding the code.

David Trieu - CD Projekt SA
Course - Visual Basic for Applications (VBA) in Excel - Introduction to programming

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

I really enjoy the training. Huge and practical! knowledge of the trainer combined with his skill to conduct the training made the training time very efficient. The trainer recognized the level of participant's experience in VBA and provided exercises relevant to that experience which made the training very useful.

Barbara Peek - UBS Business Solutions Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel - Advanced

I was benefit from the trainer knowledge, explanation and tips.

Kornel Tymcio - UBS Business Solutions Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel - Advanced

I liked the trainer, nice guy with great attitude.

Lukasz Kanior - UBS Business Solutions Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel - Advanced

I generally enjoyed the knowledge and sense of humor.

Łukasz Rózga - UBS Business Solutions Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel - Advanced

Upcoming Courses

Other regions in Hong Kong

Other Countries

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