product review overlay image

Product Description

Excel Advanced – Modules K + L Online

Designed for experienced Excel users who want to automate their work using macros and Visual Basic. Learn how to record, customise and edit macros, and create your own reusable tools and functions. Delivered as flexible 2-hour modules that can be taken individually or combined into a half-day session.

Not sure if this course is suitable? Quick Quiz or FREE – Training Needs Analysis

Module K – Recording & Managing Macros

Duration: 2 hours
Format: Live online

  • Recording a macro
  • The Personal Macro Workbook
  • Recording with relative referencing
  • Assigning macros to buttons
  • Customising the ribbon and adding macro buttons

Outcome: Automate repetitive tasks and create easy-to-run macro tools to improve efficiency.

Module L – VBA Editing & Custom Functions

Duration: 2 hours
Format: Live online

  • Editing Visual Basic code
  • Understanding recorded macro structure
  • Creating user-defined functions (UDFs)
  • Sharing and distributing custom tools

Outcome: Modify macros confidently, build custom functions and develop reusable solutions for advanced Excel workflows.

Learning Path

Module K + Module L = Excel Advanced – Level 2
Half Day – 9:00am–1:00pm (Online)

Customer Reviews

Excel Advanced Modules K + L Online

Places Available