Course offer

Microsoft Excel - Basics

Microsoft Excel - Advanced A

First use of functions and diagrams

Microsoft Excel - Advanced B

Dealing with complex functions and macros

Also as
online course!

Microsoft Excel VBA Basics

Back to the main page

Duration:	2 days
Target group:	Excel users who want to automate Excel
Target:	Introduction to Excel programming using simple and practical examples
Prior knowledge:	Good Excel knowledge
Content:	Basics of programming The principle of VBA programming Working with projects Working with objects The Visual Basic Editor Basics The Project Explorer The code window The Properties Window Working with toolbars Programming basics Use variables Branches (IF/Select-Case) Grinding Object-oriented elements Basics Individual objects and objects in listings Object model Properties and methods of objects Examples for programming objects Programming aids and troubleshooting Basics The language directory Error types Test procedures step by step catch runtime errors Special Excel programming techniques Predefined constants Reference to cells and cell areas Create dialogs Basics Simple input and output dialogs Integrated Excel dialogs

With the seminar Excel VBA you can skip the limits of Excel. The course gives you a solid introduction to programming Excel with “Visual Basic for Application”. You will learn to develop independent programs for Excel and receive suggestions for the use of VBA in your company. Using many different case studies, you will be introduced to Excel programming step by step.

Course offer

Microsoft Excel VBA Basics

Course dates Microsoft Excel VBA Basics

Company

Information

Support

Partnerships