Excel and VBA Guru Training Course
Course
In City Of London
Description
-
Type
Course
-
Location
City of london
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.
Facilities
Location
Start date
Start date
Reviews
Subjects
- Excel
- MS Excel
Course programme
Advanced Features of Excel
- 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
Excel and VBA Guru Training Course