Automate, Optimize, and Develop Your Own Solutions
Deepen your knowledge from Module 1 and learn how to professionally automate complex tasks with VBA.
Create your own functions, procedures, and user dialogs, analyze existing macros, and connect Excel with other systems – for example, SAP or Outlook.
This practical 2-day workshop shows you how to make processes even more efficient, process data from various sources, and link Office applications together.
Discover how advanced VBA programming enables you to develop real business solutions in Excel.
Your Benefits at a Glance
• Practice-oriented deepening of your Excel VBA and macro knowledge
• Development of custom functions and procedures for complex tasks
• Automation of processes with Excel, Outlook, and other Office tools
• Creation of user-friendly dialogs and control interfaces
• Numerous practical examples and best practices for immediate use
• Hybrid workshop: participation possible in person or live online
Seminar Content
Advanced Macros and VBA
• Use procedures and functions effectively
• Apply conditions and control structures in practice
• Use dialog boxes and worksheets to control program parameters
• Intensive use of Excel objects for flexible solutions
Extend Excel’s Command Range
• Write your own VBA functions and use them in Excel
• Read and create text files
• Integrate Office objects into Excel
Automate Lists, Pivot Tables, and Charts
• Automatically extend base data with formula columns
• Advanced filtering with VBA
• Work with list objects
• Create and customize pivot tables via VBA
• Automatically generate and control charts
Practical Tips & New Use Cases
• Control other Office applications with VBA
• Automate creation and editing of multiple files
• Generate and send Outlook emails with or without attachments
• Read inbox data from Outlook
• Create PDF files via VBA
• Generate XML files
• Use recursive programming for targeted searches