0

In our seminar rooms or comfortably from home!

Here you can find all our seminar topics about your keyword!

We support you as a consultant, organizer, and implementation partner for IT-qualifications, IT-projects, and Data Centre training

News: EPI joins the TÜV NORD GROUP

This marks a significant milestone in EPI’s 38-year journey, strengthening its position to serve customers while continuing to operate independently under the EPI brand

Press release PDF



Our bestseller workshops

EU AI Act - Das Gesetz zur künstlichen Intelligenz

EU AI Act - The law on Artificial Intelligence

More to this Download PDF EU AI Act - Das Gesetz zur künstlichen Intelligenz  PDF
Von der Excel-Praxis zur souveränen Copilot-Nutzung im Arbe

From Excel Expertise to Confident Copilot Usage in Everyday Work

More to this Download PDF Von der Excel-Praxis zur souveränen Copilot-Nutzung im Arbe  PDF
Microsoft AI-Builder

Microsoft AI-Builder

More to this Download PDF Microsoft AI-Builder  PDF
Microsoft Copilot für Office 365

Microsoft Copilot for Office 365

More to this Download PDF Microsoft Copilot für Office 365  PDF
Microsoft Copilot für Entwickler und Programmierer

Microsoft Copilot for Developers and Programmers

More to this Download PDF Microsoft Copilot für Entwickler und Programmierer  PDF
Microsoft 365 Teams & Kanäle - Zusammenarbeit in Teams

Microsoft 365 Teams & Channels - Collaboration in Teams

More to this Download PDF Microsoft 365 Teams & Kanäle - Zusammenarbeit in Teams   PDF
Microsoft 365 Dateien organisieren mit Teams, SharePoint & O

Microsoft 365 Organizing files with Teams, SharePoint & OneDrive

More to this Download PDF Microsoft 365 Dateien organisieren mit Teams, SharePoint & O  PDF
Microsoft 365 Zeit & Aufgabenmanagement mit Outlook, To Do,

Microsoft 365 Time & Task Management with Outlook, To Do, Loop & Planner

More to this Download PDF Microsoft 365 Zeit & Aufgabenmanagement mit Outlook, To Do,   PDF
Power Apps

Power Apps

More to this Download PDF Power Apps  PDF
Excel für Controller

Excel Knowledge for Controlling

More to this Download PDF Excel für Controller  PDF
Office 365 Power Automate Grundlagen

Office 365 Power Automate Basics

More to this Download PDF Office 365 Power Automate Grundlagen   PDF
Office 365 Power Automate Genehmigungsflows

Office 365 Power Automate Approval flows

More to this Download PDF Office 365 Power Automate Genehmigungsflows  PDF
Excel Data Analyst - Von Rohdaten bis zum Dashboard

Become Excel Data Analyst - From Raw Data to Dashboard

More to this Download PDF Excel Data Analyst - Von Rohdaten bis zum Dashboard   PDF
Folien mit WOW-Effekt - Die Funktionen Zoom und Morphen

Slides with WOW effect - The functions "Zoom" and "Morphen" (Office 365)

More to this Download PDF Folien mit WOW-Effekt - Die Funktionen Zoom und Morphen   PDF
Professionelles Berichtswesen mit Excel & Power Query

Professional reporting with Excel & Power Query

More to this Download PDF Professionelles Berichtswesen mit Excel & Power Query  PDF
Excel Power Query - Datenaufbereitung ohne Makros

Excel Power Query - Data preparation without Macros

More to this Download PDF Excel Power Query - Datenaufbereitung ohne Makros   PDF
Excel Makros für Jedermann - Mit Makros die tägliche Arbei

Excel Macros for Everyone - Automate daily work with macros

More to this Download PDF Excel Makros für Jedermann - Mit Makros die tägliche Arbei  PDF
Excel Pivot und PowerPivot

Excel Pivot and PowerPivot

More to this Download PDF Excel Pivot und PowerPivot  PDF
Excel Makros und VBA Modul 1

Excel Macros und VBA Module 1

More to this Download PDF Excel Makros und VBA Modul 1  PDF
Excel Makros und VBA Modul 2

Excel Macros und VBA Module 2

More to this Download PDF Excel Makros und VBA Modul 2  PDF

You can rent our seminar rooms!


Your booking with us is transparent and flexible, without hidden costs. Our seminar rooms in Cologne not only offer pleasant air conditioning, but are also equipped with high-quality technology such as PCs, flat screens and projectors.

Seminarraum 1
Seminarraum 2
Seminarraum 3

 

Raumvermietung

Automate Word, streamline workflows & build your own VBA solutions

This practical training teaches you how to automate Microsoft Word using VBA.
You will learn how to record, edit and optimise macros, work with the VBA editor, use variables and control structures, and access Word‑specific objects and document areas.
By the end of the course, you will be able to create your own small automation solutions and significantly increase efficiency in your daily Word work.

Our experienced trainers will show you how to:

  • record, test and edit macros in a professional way
  • understand the possibilities and limitations of Word macros
  • navigate and use the VBA development environment
  • declare and manage variables, constants, procedures and functions
  • work with control structures (If, Select Case) and loops
  • access Word-specific objects, fields and form elements
  • create input and output dialogs
  • identify, debug and fix errors effectively

Your benefits at a glance

  • a clear & efficient introduction to Word automation
  • practical examples and reusable code structures
  • skills to develop your own VBA‑based solutions
  • faster work processes through automation

Course Contents

Recording & Editing Macros

  • possibilities and limitations of macros
  • recording and testing macros
  • editing macros in the VBA editor

Programming Basics

  • parts of the development environment
  • understanding the Object Browser
  • event procedures and functions
  • creating and testing procedures
  • declaring and using variables
  • scope and lifetime of variables
  • using constants
  • control structures: If–Then–Else, Select Case
  • loops: For Next, Do Loop While, Do Loop Until

Word‑Specific Programming Techniques

  • using the Word object model
  • accessing document areas
  • programming fields and form elements
  • creating input and output dialogs

Error Handling & Debugging

  • basics of error handling
  • using breakpoints
  • inspecting and monitoring variables
  • using the Immediate Window

Target Group

This course is ideal for:

  • users who want to automate tasks in Microsoft Word
  • professionals who frequently perform repetitive actions
  • advanced Word users interested in programming and automation

Prerequisites

  • good to very good knowledge of Microsoft Word
  • practical experience with Word documents
  • general PC and Office experience

Data Centre training for many companies:
These customers already trust us

Maximize the security and efficiency of your data center with our certified Data Centre Training. Our practical training courses provide essential know-how on the design, operation and compliance of data centers. Through continuous training, you reduce downtime, minimize sources of error and meet international standards. Benefit from recognised certifications with the globally accredited training courses from PROKODA GmbH & EPI.