HOME
 

Excel VBA Advanced

STL
Course summary
2 days
English
Nationwide
Corporate Training for Teams
STL courses

Excel VBA Advanced

Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... Upon completion of the course delegates will have a good understanding of the major components of VBA.; Delegates will expand their reach by being able to use VBA to communicate with other Office applications, such as Word.; In addition, the course also covers working with data from database applications such as Access, and manipulating and presenting the data.


STL virtual classroom training

We all have to accept our preferred face-to-face method just isn't an option right now. However, virtual classroom training that we have developed offers some benefits which can make it seem less of a compromise and more of a viable interim training solution. 

Our virtual classroom training is delivered by the same team responsible for achieving industry leading customer satisfaction ratings with face-to-face training, so rest assured you are in safe hands.

Suitability - Who should attend?

This course is aimed at individuals with a basic grounding in Excel VBA and an advanced knowledge of Microsoft Excel, who wish to develop their skills with introduce more sophisticated automation into their workflows.

Training Course Content

The Excel Object ModelExploring the Range object in detailThe versatile CurrentRegion objectWorking with collections of Workbooks and WorksheetsManipulating Charts through VBAManipulating PivotTables through VBAArraysEfficient variable storage with arraysArray optimisationDynamic arraysThe Array functionTriggers and EventsRunning macros automaticallyExecuting macros on a timerAssociating macros with other Workbook eventsAdvanced ParametersPassing parameters by reference and by valueWorking with Text FilesImporting text filesExporting text filesUsing the FileStream objectLinking with OfficeConnecting to other Office applicationsWorking with other Office applicationsLinking to data sources using ADOUnderstanding ActiveX Data ObjectsUsing Excel to communicate with other data sourcesUnderstanding the connection stringAdding, reading, modifying and deleting dataAdd-InsHow macro security worksPassword protecting your codeDistributing macros via an Add-InAppendix: Classes and ObjectsWorking with Class Modules

Expenses

Prices from £579. Promotional rates often available the further ahead you book. Contact us for quote.

Be Inspired! Watch the Video

Provider: STL

STL - Microsoft Training

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....


Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Excel VBA Advanced.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL

STL

Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.stl-training.co.uk


Request information

Find out more about this Excel VBA Advanced course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here