Beschreibung
Excel: Programming with VBA
Zielgruppe: Nur für Unternehmen und Institutionen.Visual Basic for Applications (VBA) is the programming language used in all Office components. This Excel training course will teach you the basics of programming, the distinction between functions and procedures, how to define constants and variables and how to set up programme structures. You will learn to create individual solutions for your own needs.
Kommende Starttermine
Inhalte / Module
- The Development Environment
- Components of the Development Environment
- Project Explorer
- Properties Window
- Module Window
- Working in the Module Window
- Basics of VBA Programming
- Applications of macros and VBA
- Macro recording
- A simple program
- Structure of procedures
- Comments and line wrapping
- VBA syntax
- Input and message boxes
- Use of macros in Excel
- Triggering macros
- Form design
- Control elements
- Basic language elements
- Objects?
- Properties, methods and events
- Objects on forms
- Naming conventions
- Working with the object catalogue
- Linking events and procedures
- Functions and variables
- Predefined functions
- Declaring variables
- Data types
- Declaration of constants
- Principles of event-oriented programming
- Overview of events
- Arguments in event procedures
- Event procedures in practical use
- Controlling the programme flow
- Programme flow charts
- Instructions sequences
- Two-way and multi-level selection
- Case selection
- Loops
- For loop
- While loop
- Until loop
- Do loop
- Further control structures (Exit, GoTo, Recursion)
- Extended language elements
- Object variables
- Listings
- Named arguments
- Troubleshooting and Error Handling
- Basics of error handling
- Testing procedures with step in
- Checking and monitoring variables
- Catching and handling run-time errors
- Objects in Excel
- Properties and methods of Excel objects
- With statements
- The object catalogue
- The Excel object model
- References to libraries
- Working with Excel data
- Searching directories
- Saving Excel files
- Checking if files are open
- Accessing sheets and cells
- Checking whether a sheet exists in a folder
- Transfer values to other sheets
- Working with columns and rows
Zielgruppe / Voraussetzungen
Hinweis: Dieser Kurs richtet sich an Mitarbeitende aus Unternehmen und Institutionen.
Für Privatpersonen ist dieser Kurs leider nicht geeignet.
Bitte beachten Sie: Bildungsgutscheine der Agentur für Arbeit werden für diesen Kurs NICHT anerkannt.
Abschlussqualifikation / Zertifikat
Infos anfordern
GFU Cyrus AG
Erweitern Sie Ihre IT-Skills mit einem offenen IT-Training oder ganz nach Ihren Bedürfnissen durch eine individuelle IT-Schulung. Programmiersprachen (C#, Python, Java, …), Microsoft Office 365, Anforderungsmanagement, Projektmanagement, Business Intelligence, Data Science, Künstliche Intelligenz, IT-Sicherheit , Administration & Datenbanken, Softwareentwicklung, Testmanagement...
Erfahren Sie mehr über GFU Cyrus AG und weitere Kurse des Anbieters.