Training
Contact
Colorful web of lines on a dark background

Intermediate Excel VBA - Visual Basic for Applications

Take your automation skills to the next level: write reusable VBA code to manage data, streamline reports, and analyse results efficiently.
    Duration
    Start hour
    Level

      3 days • Live online • Hands-on labs • Certificate included

      Quick Facts

      • Price

        255 £

      • Duration

        ⏰ 3 days (24 training hours) of practical Excel training

      • Training format

        Live online course with interactive exercises and real-life business data.

      • Learning method

        Mini lectures + practice = knowledge you will use immediately.

      • Certificate

        Official training certificate issued upon course completion.

      • Registration

        Check available dates and register via this form.

        About the course

        Learn how to take your Excel automation to the next level with structured, efficient VBA programming.

        This Intermediate Excel VBA course is designed for professionals who already know the basics of macros and want to expand into advanced data automation.

        It focuses on practical use cases - automating everyday Excel tasks, managing multiple workbooks, and improving data workflows.

        All classes are live and interactive, with hands-on exercises and real business examples.

        Key benefits:

        • Build confidence in writing and managing VBA code
        • Reduce repetitive manual work
        • Improve accuracy and efficiency of your Excel tasks
        • Learn directly from experienced instructors

         

        Who should attend?

         This training course is intended for individuals who:

        • Work with multiple worksheets and workbooks simultaneously
        • Create multiple worksheets and/or workbooks with repetitive data or calculation structures
        • Prepare similar or identical datasets and reports in spreadsheets for different stakeholders

        It is especially suitable for

        • Analysts
        • Accountants
        • Warehouse staff
        • Employees involved in production support and organisation

        Learning outcomes

        After completing this training, participants will be able to:

        • Automate repetitive and multi-sheet tasks
        • Manage and consolidate large sets of data across workbooks
        • Create custom VBA functions and procedures
        • Format, clean, and analyse data automatically
        • Optimise VBA code for speed and reliability

        Enrol now!

        Transform your daily workflow

        This course is designed for one purpose: to give you the power to automate your most time-consuming Excel tasks. 

        After completing this training, you will be able to:

        1. Build & format reports instantly

        Automatically generate and format worksheets with complex, repetitive calculation structures. Turn a task that takes hours into a process that runs with a single click, using your own custom functions and styles.

        2. Consolidate data effortlessly

        Put an end to the repetitive task of manual copy-pasting. Write effective scripts that will automatically collect, centralize, and archive data from multiple workbooks and worksheets into one reliable source of truth. 

        3. Create custom views for any stakeholder

        Automatically segregate and prepare unique data sets for different teams or managers. Your code can instantly adapt the output to show the right information to the right people, every single time, without extra manual work.
        Free up your time to focus on high-value analysis and strategy, not repetitive tasks.

        Enrol now

        FAQ

        Is this intermedite course right for you?

        Profile of participants

        This training course is intended for individuals who, among other things:

        • work with multiple worksheets and workbooks at the same time,
        • create multiple worksheets and/or workbooks with repetitive data/calculation structures,
        • prepare similar or identical data sets and/or reports in spreadsheets for many different stakeholders.

        It is intended, among others, for analysts, accountants, warehouse staff, and employees in production support and organisation.

        Preparation

        Required knowledge:

        • very good practical knowledge of MS Excel (participants should use intensively MS Excel in daily work),
        • taken the training course “VBA in MS Excel – Beginners Level. Basics of computer programming (or knowledge and background of the training material).

        What is the main difference between intermediate and a basic Excel VBA course?
        • Our basic Excel VBA course focuses on recording and editing macros. 
        • During the intermediate course, you will dive deep into writing custom code from scratch. 

        The full syllabus can be found in FAQ section: "What topics are covered in the VBA in MS Excel course?"

        What topics are covered in the VBA in MS Excel course?
        1. Start of the training course – organizational matters
        2. User-defined functions
          2.1.   Using functions
          2.2.   Using functions in MS Excel formulas
          2.3.   Using functions in VBA code
          2.4.   Creating custom functions
          2.5.   Creating add-ins – function library
        3. Formulas – calculation structure in worksheet
          3.1.   Inserting of formulas into a spreadsheet
        4. Styles
          4.1.   Applying styles and cell style types
          4.2.   Operations on cell styles
        5. Operations on worksheets
          5.1.   References to worksheets
          5.2.   Creating and deleting worksheets
        6. Operations on workbooks
          6.1.   Operations on an active workbook
          6.2.   Operations on selected workbook
        7. Worksheet and workbook events
          7.1.   Storage location of worksheet and workbook event procedures
          7.2.   Syntax of event procedure control manual
          7.3.   Worksheet events
          7.4.   Workbook events
        8. Error detection and handling
          8.1.   Run-time error catching and handling
          8.2.   Run-time error catching possibilities in code
          8.3.   Elements of run-time error handling
        9. Useful mechanisms and structures – selection
          9.1.   Timing (“Timer” function)
          9.2.   Procedure optimization using “ScreenUpdating” function
          9.3.   Code protection against preview and modification
          9.4.   Using With ... End With statement to increase the clarity and speed of procedures
          9.5.   Using indicators for single objects
          9.6.   Running dialog boxes of an application
          9.7.   Running another application
        10. End of the training course (test + discussion of the results, training evaluation)

        Training methods:

        Lecture + workshops (amount proportional to lecture) + workshops check (individual) + workshops discussion.

        What is the role of VBA in Excel?

        VBA (Visual Basic for Applications) empowers you to automate repetitive Excel tasks, streamline workflows, and boost productivity. Instead of manual clicks, you create macros that handle complex operations quickly and accurately, freeing up your time for more strategic work.

        What's next after the intermediate course?
        How can I join?

        To sign up, simply fill out the short registration form.

        Go to form!

        Is VBA still relevant in 2025?

        Absolutely! VBA remains a powerful tool in Excel for automating tasks, customising reports, and integrating with other Office applications. It's widely used in businesses worldwide to save time and reduce errors.

        Similar trainings

        Sign up for training!

        Register now for our upcoming training sessions by filling out the registration form.

        Join us to build your expertise and take the next step in your career!

        Enrol now!

        📩 Any questions? Get in touch with us!

        Lidia Waśnik

        lidia.wasnik@comarch.com

        +48 12 646 14 41