Courses / Advanced Excel Power Macros (VBA)
Advanced Excel Power Macros (VBA)
- Provider
- Desktop Training & Development Ltd
- Summary
- This course is designed to help delegates expand their knowledge on Excel Power Macros.
About the Course
- Target
- This course is suitable for those with a good knowledge of Excel and some knowledge of Visual Basic for Applications.
- Entry requirements
- A thorough knowledge of Excel is essential as is a basic knowledge of Visual Basic for Applications.
- Outcome
- Content
- Using Arrays
- explanation of what an array is
- dimensioning arrays
- manipulating data within an array
- advantages and typical uses of arrays
Understanding the Excel Object Model- overview of the object model
- using the object browser and the help screens
Workbook and Worksheet Events- exploration of workbook events
- exploration of worksheet events
Creating User Defined Functions with Optional Arguments
Working with Text Files- importing data from a text file
- saving data to a text file
Linking Excel and Access- how to retrieve data from an Access database
Linking Excel to Word- how to insert information into a Word document
- how to control word from within Excel
Working with Charts- how to create a simple chart
- changing chart properties
Exploring Further the use of Custom Forms- using the built-in dialog boxes
- adding a list box to a form
- adding a combo box to a form
- exploring events within a form
Menus and Toolbars- adding new menu items
- removing menu items
- working with toolbars
A comprehensive course manual provides support throughout the course and upon your return to the office. - Cost
- Please contact the provider for course fees.
- Enrolment
- Telephone, fax or write to Desktop.
- Website
- www.desktoptraining.co.uk
Availability
- Starts
- Course dates are available on request
- Duration
- One day
- Timetable
- 9.30 am - 16.30 pm
- Provider
- Desktop Training & Development Ltd
Venues/Contact
Main (View map)
11 Beta Terrace
Masterlord Office Village
Ransomes Europark
Ipswich, Suffolk
IP3 9FE
UNITED KINGDOM
Telephone 0845 1188150
Email info@desktoptraining.co.uk
Website http://www.desktopcourses.co.uk
Venue Notes 0
Courses
Syndicate
