Schulungsübersicht
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
Voraussetzungen
Praktische und fortgeschrittene Kenntnisse in Microsoft Excel und VBA in Excel.
Erfahrungsberichte (7)
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
Kurs - Access VBA
Erschöpfung der Themen
Karol - VOLKSWAGEN POZNAŃ SP. Z O.O.
Kurs - Excel Advanced with VBA
Maschinelle Übersetzung
I like the hands on training and seeing us solve for issues on the spot.
Jon Matrille - LocumTenens.com
Kurs - Visual Basic for Applications (VBA) in Excel - Advanced
Zeigen von Beispielen, bildhaftes Erklären
Aneta - LKQ Polska Sp. z o. o.
Kurs - Visual Basic for Applications (VBA) in Excel (intermediate level)
Maschinelle Übersetzung
Flexibilität des Trainers. Umfassende Antworten auf jede Frage.
Krystyna Szpala - Sogecap SA Branch in Poland
Kurs - Visual Basic for Applications (VBA) for Analysts
Maschinelle Übersetzung
Ich habe wirklich von den praktischen Beispielen aus dem Leben profitiert.
Wioleta
Kurs - Data and Analytics - from the ground up
Maschinelle Übersetzung
I learned new things so that is a good point