Visual Basic for Excel - Advanced
Sponsored links
Who is it for?
This course is great for people who want a more professional result using Excel. If you already have a thorough understanding of Excel formulae and functions, and use some Visual Basic programming, this course is for you.
What is it about?A step up from our introductory course, this day takes you through advanced methods of data management and smart uses of VBA programmes.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
What do I get out of it?
By the end of this course you will possess:
- The skills to maximise Excel functionality
- in depth understanding of how to Edit,Amend and Update VBA Programmes
- Improved interfaces between Excel spreadsheets
- An advanced understanding of methods of data management through powerful VBA tools
- Macros: Debugging and Tracing Errors in Macros
- Visual Basic Objects
- Range, Object Flexibility and Constraints
- Object Hierarchy
- Workbooks and Worksheets
- Activating Worksheets and Workbooks through VBA
- Constants and Variables
- Structure, Control and Conditional Structure Control
- Sub-Routines and Non-Structured Information
- Customising Forms and Dialogue Boxes
- Using Forms with Pre-Defined Dialogue Boxes
- Form Controls and Properties; Customised Forms
- Adding in Other Applications
- What are Add-Ins?
- Generating an Add-In
- Using Add-Ins in a Workbook
- Error Handling within the Programme Logic
This Training Course is taught in classrooms in the following locations:
London WC
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
