Excel VBA application development in controlling

Application planning

• Basics and strategies for effective planning of software projects in controlling.

Creation and processing of a product backlog

• Introduction to agile methods and their application in software development.

Program architecture

• Best practices and patterns for building robust and maintainable applications.

Design and ergonomics for the user

• Principles of user-friendly design and their implementation.

Introduction to working with software projects

• Structured approach to the development of controlling solutions.

Add-in programming

• Creation of Excel add-ins to extend the functionality.

Customization of the ribbon

• Customization and extension of the Excel ribbon to control the developed applications.

Collaboration of Office applications

• Integration and collaboration of various Office applications such as Excel, Word and Outlook.

Trigger and time control

• Automation of processes through event- and time-controlled workflows.

Use of ChatGPT

• Use of AI tools to support and automate programming tasks.

API programming

• Introduction to programming interfaces for integrating external data sources and services.

VBA practical knowledge and examples

• The content taught is illustrated using a central practical example. In the practical example, the functions and features created are combined in an add-in and controlled via a menu extension. The above-mentioned content is used in this add-in. Effective solutions for typical problems in controlling are presented in further examples.