Excel Advanced Automation
This course is designed to equip participants with advanced skills in Excel automation using Macros, VBA (Visual Basic for Applications).
Advanced
2 Day Course
Certification Awarded
Online Resources
Course overview
- This course is designed to equip participants with advanced skills in Excel automation using Macros, VBA (Visual Basic for Applications). As an experienced user aiming to enhance efficiency, this course will empower you to leverage the full potential of Excel for automation.
Audience
- Experienced Excel users at seeking to automate tasks to enhance efficiency, including business professionals, analysts, and data scientists.
Objectives
- By the end of this course, participants will have the skills and confidence to create powerful automation solutions in Excel using Macros with VBA.
Certification
- At the end of the course, you’ll be Certified by the Irish Academy of Computer Training.
- CPD Certification
Requirements
- Advanced Excel knowledge is required
- Software is provided in the Classroom and Live Virtual options
Learning paths
- Progress to our Excel Master Diploma
Why choose IACT
- Ireland’s leading training provider for 30 years
- Full-time Certified Trainers who use the software every day
- Smaller class sizes to accelerate learning
Course curriculum
What's covered
Introduction to Excel Automation
Understanding the need for automation in Excel
Overview of Excel Macros and VBA
Recording and running simple Macros
Basic principles of programming logic
Using the Macro Recorder
Recording a macro
Using relative references rather than absolute
Tweaking macros to change their functionality
Recording multiple macros and putting them all together
Getting Started with VBA
Introduction to the VBA Editor
Variables, data types, and constants
Control structures (if statements, loops)
Procedures and functions in VBA
Advanced VBA Programming
Working with arrays and collections
Error handling and debugging techniques
User Forms and controls
Integrating VBA with Excel features (Worksheets, Workbooks)
Creating a User Defined Function
Office Automation
Automating Word from Excel
Automating PowerPoint from Excel
Automating Outlook from Excel
Security
Personal Macro Workbook
Macro security levels
Using a digital signature
Contact us.
We'll reply quickly.
Enquiry
I understand that my personal data is being processed in accordance with the privacy notice and accept the terms and conditions of use.