Certificate ID:
535705
Authentication Code:
99d93
Certified Person Name:
Pawel Zawila
Certified Person Email:
Trainer Name:
Marek Michno
Duration Days:
3
Duration Hours:
21
Course Name:
Visual Basic for Applications (VBA) w Excel - poziom Guru
Course Date:
26 April 2017 09:00 to 28 April 2017 17:00
Venue:
Zabierzów, Poland
Course Outline:
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
Certificate Sent:
Certificate Sent
Course Name Eng:
Excel and VBA Guru