Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
コース概要
Advanced Features of Excel
- Functions Panel
- The properties of an object from VBA
- Events Sheet, Workbook and Application
- Formula repeatedly nested
- Solver addition
User Forms
- Creating a user interface
- Advanced forms and custom dialog boxes
- Event handling forms
Access and Excel Automation
- Automation vs ADO
- Using the functionality in Access VBA code in Excel
Outlook and Excel Automation
- Sending emails from Excel
- Reading data from Outlook
Creating Applications in Excel
- Application Development and its distribution
- Distribution and securing additions to Excel
- Creating custom toolbars and menu
Excel Hacks
- Tips and tricks to use other Excel features, for example double pie, and extracting numeric values from text
要求
Required practical and advanced knowledge of Microsoft Excel and VBA in Excel.
21 時間
お客様の声 (6)
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
コース - Access VBA
話題が尽きた
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
例の表示、図による翻訳方法
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
実際の実践例から本当に恩恵を受けました。
Wioleta
コース - Data and Analytics - from the ground up
Machine Translated