Excel tools in controlling: Getting started with VBA programming

Automate Excel Instead of Clicking

• Recording and Understanding Macros.
• Develop your own VBA macros.
• Confident use of the VBA Editor.
• Get hands-on experience with the Excel object model.

The Fundamentals of Successful VBA Solutions

• Create your own procedures and functions.
• Managing data with variables and constants.
• Automate decisions and processes.
• Identify problems and address them professionally.

Conveniently Collect and Manage Data

• Create user-friendly dialogs.
• Check and control input.
• Using Built-in Excel Dialogs Effectively.

Securely Automate Excel Files and Data

• Automatically create, open, and save workbooks.
• Manage worksheets effectively.
• Edit and analyze cells and ranges using VBA.
• Complete recurring tasks with the push of a button.

Developing Professional VBA Projects

• Create structured and maintainable VBA solutions.
• Organize modules and routines effectively.
• Introduction to Developing Your Own Excel Add-Ins.

Please bring your own laptop to the training . You can find more detailed installation instructions under Methods.