Excel VBA Level 4
Course Outline

DURATION	1 day
PREREQUISITES	Must be confident or at least have had sufficient exposure to the concepts covered in Levels 1-3.
DESCRIPTION	Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
COURSE DATES	SPECIAL: Four Days of MS Office training for the price of Three! Click here to request an alternate date Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday. Weekend Sat, 11-Feb-12 10:00 - 16:30 £200.00 +VAT Weekday Mon, 27-Feb-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 12-Mar-12 and Tue, 13-Mar-12 18:30 - 21:30 £200.00 +VAT Weekday Tue, 27-Mar-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 14-Apr-12 10:00 - 16:30 £200.00 +VAT Weekday Thu, 26-Apr-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 12-May-12 10:00 - 16:30 £200.00 +VAT Weekday Fri, 25-May-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 11-Jun-12 and Tue, 12-Jun-12 18:30 - 21:30 £200.00 +VAT Weekday Wed, 27-Jun-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 14-Jul-12 10:00 - 16:30 £200.00 +VAT Weekday Thu, 26-Jul-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 11-Aug-12 10:00 - 16:30 £200.00 +VAT Weekday Mon, 27-Aug-12 09:30 - 16:30 £200.00 +VAT Weekday Thu, 6-Sep-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 10-Sep-12 and Tue, 11-Sep-12 18:30 - 21:30 £200.00 +VAT Weekend Sat, 13-Oct-12 10:00 - 16:30 £200.00 +VAT Weekday Thu, 25-Oct-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 12-Nov-12 and Tue, 13-Nov-12 18:30 - 21:30 £200.00 +VAT Weekday Tue, 27-Nov-12 09:30 - 16:30 £200.00 +VAT Evening Wed, 12-Dec-12 and Thu, 13-Dec-12 18:30 - 21:30 £200.00 +VAT Weekday Thu, 27-Dec-12 09:30 - 16:30 £200.00 +VAT Any One-to-One Tuition Any Date - Fully Customisable 09:30 - 16:30 £400.00 +VAT Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

Revision of Level 3

Creating Add-Ins (mini Excel applications)

·         What?  Why?

·         The Add-ins dialog box

·         Adding descriptive information

·         Creating

·         Opening

·         Distributing

·         Modifying

Manipulating Windows Explorer

·         Creating, Deleting, Renaming folders

·         Copying / Moving / Renaming files

·         Getting a list of all files in a folder

Absorbing lists of data to be use elsewhere

·         Arrays

­        Declaring and using redim

­        Multidimensional arrays

­        Dynamic Arrays

­        Using an Array

·         ADO Recordsets

­        Creating

­        Filtering

­        Sorting

­        Adding new records to

­        Counting records

­        Pasting into a sheet

Intro to Integrating with other Office Applications

·         Setting References

·         Starting another application

·         Activating the application

·         Outlook

­        Sending an email through Outlook

­        Sending separate emails per region

·         Word

­        Creating a memo with a chart

·         Access

­        Attaching to a database and appending the spreadsheet data

Codesigning your vba