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
Requirements
Required practical and advanced knowledge of Microsoft Excel and VBA in Excel.
Testimonials (7)
Trainer flexibility. Comprehensive answers to every question.
Krystyna Szpala - Sogecap SA Branch in Poland
Course - Visual Basic for Applications (VBA) for Analysts
Machine Translated
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.
Julie - Environment, Marine and Fisheries
Course - Excel VBA Introduction
I really was benefit from the real life practical examples.
Wioleta
Course - Data and Analytics - from the ground up
'Fun facts' - how to achieve the same the other way around.
Paulina - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
I liked the large number of tasks and the friendly atmosphere.
Paulina - LKQ Polska Sp. z o. o.
Course - Excel Data Analysis
Machine Translated
Trainer's knowledge and experience.
Paweł Dykowski - LKQ Polska Sp. z o. o.
Course - Excel Modelling
Great pace during the training. very knowledgeable and teaching style