Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members 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 小时
客户评论 (7)
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
机器翻译
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)
机器翻译
培训师的灵活性。全面回答每个问题。
Krystyna Szpala - Sogecap SA Branch in Poland
课程 - Visual Basic for Applications (VBA) for Analysts
机器翻译
我真的从现实生活中的实际例子中受益匪浅。
Wioleta
课程 - Data and Analytics - from the ground up
机器翻译
I learned new things so that is a good point