Excel Macros and VBA Module 2
2-Day Workshop
Make your work in Excel easier with macros and VBA functions and procedures. We will show you how to deepen your macro knowledge and create your own functions in VBA.
Discover how to effectively use the Immediate Window, Object Browser, and other helpful tools to make your work easier. Learn how to analyze foreign and custom macros and process data and information from other systems such as SAP.
Optimize your automation techniques and learn how to create and use custom user dialogs. We will teach you how to work safely and comfortably with macros and VBA routines and use advanced programming concepts.
Workshop Content
Deepening Macros & VBA Knowledge:
- Use of procedures & functions
- Conditions & control structures in practical use
- Use dialog windows & worksheets to control program parameters
- Intensive use of Excel objects
Expanding Excel Command Scope:
- Writing your own functions
- Reading & creating text files
- Using Office objects in Excel
Working with Lists, Pivot Tables & Charts:
- Automate the extension of base data with formula columns
- Advanced filtering with VBA
- Working with list objects
- Create Pivot Tables with VBA
- Generate & control charts via VBA
Practical Tips & New Use Cases:
- Control other Office applications
- Create & edit many files
- Generate Outlook emails
- Create PDF files with VBA
- Create and send emails with attachments
- Read Outlook inbox messages
- Generate XML files
- Use recursive programming for search
Who Should Attend This Workshop?
This workshop is designed for those who want to intensify their knowledge of Excel macros and develop custom, tailored solutions with Excel VBA.