98.9% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
Excel VBA Advanced Training Courses
Designed for Excel 365, 2016, 2013, 2010, 2007
Who is this course for?
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.
Attendance of our Microsoft Excel VBA course, or equivalent knowledge.
Including the understanding of the following:
- Variable types
- Using object variables to represent worksheets and workbooks
- Using count based (For-Next) and conditional based (Do-Until, Do-While) loops
- If-Then-Else-End If and Select Case statements
- With blocks
- Using Range and Cells objects
- 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.
The Excel Object Model
Exploring the Range object in detail
The versatile CurrentRegion object
Working with collections of Workbooks and Worksheets
Manipulating Charts through VBA
Manipulating PivotTables through VBA
Efficient variable storage with arrays
The Array function
Triggers and Events
Running macros automatically
Executing macros on a timer
Associating macros with other Workbook events
Passing parameters by reference and by value
Working with Text Files
Importing text files
Exporting text files
Using the FileStream object
Linking with Office
Connecting to other Office applications
Working with other Office applications
Linking to data sources using ADO
Understanding ActiveX Data Objects
Using Excel to communicate with other data sources
Understanding the connection string
Adding, reading, modifying and deleting data
How macro security works
Password protecting your code
Distributing macros via an Add-In
Appendix: Classes and Objects
Working with Class Modules
Prices & Dates
What you get
Training is held in our modern, comfortable, air-conditioned suites
Modern-spec IT, fully networked with internet access
"What do I get on the day?"
Lunch is provided at a local restaurant or pub. Browse the sample menus:
Courses start at 9:30am.
Please aim to be with us for 9:15am.
Joining information (how to get to our venues)
Available throughout the day:
- Hot beverages
- Clean, filtered water
Training formats & Services
Why us? / Testimonials
Euromoney Institutional Investor PLC
Excel VBA Advanced
We were provided with the knowledge and the skills to try and test what we learnt through substantial exercises, templates and manuals. The trainers were able to tailor the examples to our questions and they were able to make it more applicable to what we are likely to use. The trainers were knowledgeable, adaptable and highly effective. We thoroughly benefited from the training and would recommend the Company.
Marketing Communications Manager
Excel VBA Advanced
A fantastic course for learning the structure and fundamentals of Excel VBA. This was very useful to me especially as I have to do a lot of work with Excel. The trainer was very enthusiastic, motivating, and helpful as well.
Excel VBA Advanced
Great course, that will really help me in my work where I have to mange a lot of data,
I suggest to keep time for practical issues that delegates might have on their own data or at their own work,
618 Excel events in the next 12 months, live dates & pricing here