Learning Options for this Course
This course can be taken at our Training Centre in Dublin 2. Socially distanced learning. Full interaction with expert trainers.
Daytime or evenings using iLiveLearning. Full interaction with the trainer, just like in the classroom. Software provided.
Self-paced online course on our Learning Hub with Assessment and Certification. 1 Year access. Software required.
Skills You will have at the end of the Course
Record and edit a macro’s VBA code
Understand object oriented structure of Excel
Creating custom forms in Excel
Macro security and protection of macro code
Foundations of programming using VBA
Pump data from databases, CSV files and similar
The course provides a solid foundation in Excel VBA. Using Excel VBA will extend your knowledge of recorded Macros and provide you with powerful skills to automate Excel. This course explains how and where Macros can be useful in Excel and how to use Excel for as much of the “heavy lifting” as possible.
Advanced Excel knowledge is required
At the end of the course, you’ll be Certified by the Irish Academy of Computer Training
Who would benefit
Users familiar with recording and editing basic macros in Excel who want to go further in automating and customising Excel using VBA – Visual Basic for Applications. No previous programming experience is required but an expert level of Excel use is assumed
Why take the Course
Repeating actions on workbooks or sheets? It may be possible to automate that work. Importing data, cleaning data, archiving existing information and similar activities are good candidates for automation in Excel. VBA provides extra options for developers looking to automate Excel.
Section 1: Introduction
Section 2: Macro Recorder Part 1
Section 3: Macro Recorder Part 2, A Larger Example
Section 4: Forms
Section 5: Loops
Section 6: User Defined Functions
Section 7: Automation
Section 8: Security
Contact us - we'll reply to you quickly
By clicking send, you agree for us to contact you about your enquiry.