catraining

 

Microsoft Partner
Microsoft Excel VBA Advanced

Audience: This course is aimed at experienced Excel VBA users who need to move to the next level. Create User Forms, create Add-ins and automate the other Office applications.

Course Duration: 1 day(1)

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and Saturday club.

Course Location: This Microsoft Excel VBA Advanced training course is delivered at our training centre in London situated close to Liverpool Street station; training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

 

MOS Excel Specialist / Expert Exam Costs ( optional )

 

All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

 

View Scheduled Public Courses

reaining course

 

After completing this course, students will be able to:
    • Appreciate the Excel Object Model
    • Store data in Arrays
    • Use Triggers and Events
    • Pass and Type argument values
    • Work with Text Files
    • Create User Forms
    • Automate other Office applications
    • Create Excel Add-Ins

  • Course Outline
    print this page
    Module 1: The Excel Object Model
    • Exploring the Range object in detail
    • CurrentRegion and UsedRange properties
    • Working with collections of Workbooks and Worksheets
    • Manipulating Charts and PivotTables
    Module 2: Arrays
    • Efficient variable storage with arrays
    • Dynamic arrays
    • The Array function
    Module 3: Triggers and Events
    • Running macros automatically
    • Executing macros on a timer
    • Associating macros with Workbook events
    Module 4: Parameters
    • Passing data By Reference and By Value
    Module 5: Working with Text Files
    • Importing text files
    • Exporting text files
     
    Module 6: User Forms
    • Controls Toolbox
    • Using User Form properties, events and methods
    • Understanding controls
    • Label controls
    • Text box controls
    • Command button controls
    • Combo box controls
    • Option button controls
    • Determining the tab order
    • How to launch a form in code
    Module 7: Office Automation
    • Connecting with other MS Office applications
    • Manipulating Access data using DAO, ADO and ADODB
    • Understanding ActiveX data objects
    • Using Excel to communicate with other data sources
    • Understanding the connection string
    • Adding, reading, modifying and deleting data
    Module 8: Add-Ins
    • How macro security works
    • Password protecting your code
    • Creating Add-Ins
     
      Microsoft

Call us now for further information Tel:08001601666