Course not currently available
Excel and VBA Guru Training Course
Course
In Oxford ()
Description
-
Type
Course
The course topics cover maximum automation. The student will learn how to use VBA effectively, how to use cell names to be copied, which are useful properties of objects only available in Excel VBA code and how to create your own control library. Finally, participants will learn how to create a complete application and how to secure it.
About this course
Required practical and advanced knowledge of Microsoft Excel and VBA in Excel.
Reviews
Subjects
- Access
- Excel
- MS Excel
Course programme
- Functions Panel
- The properties of an object from VBA
- Events Sheet, Workbook and Application
- Formula repeatedly nested
- Solver addition
- Creating a user interface
- Advanced forms and custom dialog boxes
- Event handling forms
- Automation vs ADO
- Using the functionality in Access VBA code in Excel
- Sending emails from Excel
- Reading data from Outlook
- Application Development and its distribution
- Distribution and securing additions to Excel
- Creating custom toolbars and menu
- Tips and tricks to use other Excel features, for example double pie,and extracting numeric values from text
Additional information
Excel and VBA Guru Training Course