Certificate Authentication

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