Explore Our Courses

Visual Basic for Applications (VBA) in Excel - Advanced

 14 時間
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.
続きを読む...

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

 21 時間
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.
続きを読む...

VBA For Access & Excel

 21 時間
The objective of the course is to enable participants to gain a mastery of the fundamentals and usages of VBA for Access & Excel.
続きを読む...

Excel VBA in One Day

 7 時間
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.
続きを読む...

Access VBA

 21 時間
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.
続きを読む...

Excel Advanced with VBA

 21 時間
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.
続きを読む...

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

 14 時間
Course is intended for those familiar the basics of VBA who want to develop their knowledge and greater use of language capabilities.
続きを読む...

Visual Basic for Applications (VBA) for Analysts

 21 時間
The course is designed for users of Excel for creating analyzes and reports.
続きを読む...

Excel and VBA Programming for Audit and Finance Professionals

 28 時間
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?
続きを読む...

Last Updated:

お客様の声(5)

例の表示、図による翻訳方法

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

Machine Translated

トレーナーの柔軟性。あらゆる質問に対する包括的な回答。

Krystyna Szpala - Sogecap SA Branch in Poland
コース - Visual Basic for Applications (VBA) for Analysts

Machine Translated

話題が尽きた

Karol - VOLKSWAGEN POZNAŃ SP. Z O.O.
コース - 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
コース - Visual Basic for Applications (VBA) in Excel - Advanced

Training Room and quite location and all the stuff.

Abdullah Adelyar - USAID - Kabul Afghanistan
コース - Access VBA

Upcoming Courses

Other regions in 日本

他の国

これらのコースは他の国でもあります>>
週末VBAコース, 夜のVBAトレーニング, VBAブートキャンプ, VBA インストラクターよる, 週末VBAトレーニング, 夜のVBAコース, VBA指導, VBAインストラクター, VBAレーナー, VBAレーナーコース, VBAクラス, VBAオンサイト, VBAプライベートコース, VBA1対1のトレーニング