Excel Advanced

Suitable for advanced Excel users. You will learn how to use Excel to automate complex tasks. The course provides a solid foundation in Excel VBA



2 Days


Online resources

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.

Virtual Classroom

Daytime or evenings using iLiveLearning. Full interaction with the trainer, just like in the classroom. Software provided.

Self-paced eLearning

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

Course overview

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.

Online Option


Course curriculum

Section 1: Introduction
Introduction – Excel Overview – Recording A Macro – Reviewing Macro Code – Introduction to Excel – Objects, Methods And Properties – Differences Between Office 2003, 2007, 2010 And 2013 – Creating A Macro Enabled Workbook
Section 2: Macro Recorder Part 1
Introduction – Recording A Macro To Format Cells – Recording A Macro To Format Cells As Currency – Recording A Macro To Swap Two Columns – Recording A Macro Using Relative References Rather Than Absolute – Recording A Macro To Turn Gridlines On And Off – Tweaking Macros To Change Their Functionality
Section 3: Macro Recorder Part 2, A Larger Example
Introduction – Some Useful Functionality In Excel For Cell Selection – Importing A Text File – Filling Blank Cells With Data – Adding A Column With The Date – Creating A Pivot – Creating A Chart – Deleting Sheets And Charts – Putting Them All Together
Section 4: Forms
Introduction – Creating A Simple Switchboard Form To Call Our Previous Macros – Adding A Button To The Ribbon To Display The Form – Using The Auto Open Events To Display The Form – The Name List Form, Dealing With Events – Using String Functions To Manipulate Text – Creating A Form To Interact With Data On A Sheet
Section 5: Loops
Introduction – Looping Through Data In A Column With The For Loop – The While Loop – Using ‘Cells’ To Access A Cell – Looping Through Variable Length Lists – Looping Through Data In A Column With Spaces – Calling Formula To Determine When To Stop A Loop – Creating Reusable VBA Code – Finding And Formatting Data Using Loops
Section 6: User Defined Functions
Introduction – Creating A User Defined Function (UDF) – Creating A Variable Discount Calculation UDF – Error Handling In VBA – Debugging In VBA
Section 7: Automation
Introduction – Automating Word From Excel – Automating Powerpoint From Excel – Automating Outlook From Excel – Getting Data From Access Into Excel Using VBA
Section 8: Security
Introduction – Personal Macro Workbook – Macro Security Levels – Using A Digital Signature

Contact us - we'll reply to you quickly

Enquiry Form

  • Hidden
  • This field is for validation purposes and should be left unchanged.

By clicking send, you agree for us to contact you about your enquiry.