Skip to navigation (Press Enter).
Skip to search (Press Enter).
Skip to course offerings (Press Enter).
Skip to content (Press Enter).

Detailed search

We are happy to advise you!
+49 40 253346-10 Contact

7E1

Online Training

Duration 2 days

Price (excl. tax)

930.— €

Dates and Booking

Request a date

Classroom Training

Duration 2 days

Price (excl. tax)

Germany: 930.— €

Dates and Booking

Request a date

Onsite Training

Request onsite training

Excel 2010 / Excel 2013 / Excel 2016 / Excel 2019 - VBA - Programmierung Aufbaukurs (7E1)

Who should attend

Angesprochener Teilnehmerkreis sind Excel-Poweruser, die ihre Anwendunge automatisieren möchten, PC-Betreuer und Anwendungsprogrammierer.

Prerequisites

Besuch des Seminars Excel - VBA-Programmierung Grundkurs oder vergleichbare Kenntnisse.

Course Objectives

Aufbauend zu den Inhalten des Kurses VBA-Programmierung Grundlagen erlernen Sie hier weitere Techniken.

Course Content

Module schützen, mit Zertifikaten arbeiten
Prozeduren weitergeben mit Add-Ins
Erweiterte Datentypen - Arrays, Verbunde, Aufzählvariable
Eindimensionale und mehrdimensionale Arrays
Dynamische und statische Arrays verwenden
Gültigkeitsbereiche von Variablen, Variablenübergabe byVal und byRef
Objektvariable benutzen, Objekt referenzieren
Range-Objekt, Diagramm-Objekt, Pivottabellen-Objekt
Vertiefung: Ereignisse, For-each, benutzerdefinierte Funktionen
Programmieren im Bereich Ordner/Dateien
Ascii- bzw. CSV-Dateien erstellen
Zurückgreifen auf integrierte Exceldialoge und Officedialoge
Vertiefung: Eigene Dialogformulare erstellen
Eigene Fehlermeldungen erstellen
Auf andere Office-Anwendungen zugreifen

Online Training

Duration 2 days

Price (excl. tax)

930.— €

Dates and Booking

Request a date

Classroom Training

Duration 2 days

Price (excl. tax)

Germany: 930.— €

Dates and Booking

Request a date

Schedule

Virtual Classroom
Classroom Training

Instructor-led Online Training: Course conducted online in a virtual classroom.

German

Time zone: Central European Summer Time (CEST) ±1 hour

5–6 Jul 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

12–13 Jul 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

19–20 Jul 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

26–27 Jul 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

9–10 Aug 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

29–30 Aug 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

30–31 Aug 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

13–14 Sep 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

+ show all dates

5–6 Jul 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

12–13 Jul 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

19–20 Jul 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

26–27 Jul 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

9–10 Aug 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

29–30 Aug 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

30–31 Aug 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

13–14 Sep 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

20–21 Sep 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

21–22 Sep 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

4–5 Oct 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

25–26 Oct 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

27–28 Oct 2022 Online Training Time zone: Central European Summer Time (CEST) Course language: German

8–9 Nov 2022 Online Training Time zone: Central European Time (CET) Course language: German

15–16 Nov 2022 Online Training Time zone: Central European Time (CET) Course language: German

17–18 Nov 2022 Online Training Time zone: Central European Time (CET) Course language: German

29–30 Nov 2022 Online Training Time zone: Central European Time (CET) Course language: German

20–21 Dec 2022 Online Training Time zone: Central European Time (CET) Course language: German

7–8 Feb 2023 Online Training Time zone: Central European Time (CET) Course language: German

21–22 Feb 2023 Online Training Time zone: Central European Time (CET) Course language: German

4–5 Apr 2023 Online Training Time zone: Central European Summer Time (CEST) Course language: German

18–19 Apr 2023 Online Training Time zone: Central European Summer Time (CEST) Course language: German

4–5 May 2023 Online Training Time zone: Central European Summer Time (CEST) Course language: German

30–31 May 2023 Online Training Time zone: Central European Summer Time (CEST) Course language: German

13–14 Jun 2023 Online Training Time zone: Central European Summer Time (CEST) Course language: German

4–5 Jul 2023 Online Training Time zone: Central European Summer Time (CEST) Course language: German

18–19 Jul 2023 Online Training Time zone: Central European Summer Time (CEST) Course language: German

25–26 Jul 2023 Online Training Time zone: Central European Summer Time (CEST) Course language: German

8–9 Aug 2023 Online Training Time zone: Central European Summer Time (CEST) Course language: German

29–30 Aug 2023 Online Training Time zone: Central European Summer Time (CEST) Course language: German

12–13 Sep 2023 Online Training Time zone: Central European Summer Time (CEST) Course language: German

19–20 Sep 2023 Online Training Time zone: Central European Summer Time (CEST) Course language: German

24–25 Oct 2023 Online Training Time zone: Central European Summer Time (CEST) Course language: German

7–8 Nov 2023 Online Training Time zone: Central European Time (CET) Course language: German

14–15 Nov 2023 Online Training Time zone: Central European Time (CET) Course language: German

28–29 Nov 2023 Online Training Time zone: Central European Time (CET) Course language: German

19–20 Dec 2023 Online Training Time zone: Central European Time (CET) Course language: German

Date on request

Germany

5–6 Jul 2022 Berlin Course language: German

5–6 Jul 2022 Dresden Course language: German

5–6 Jul 2022 Düsseldorf Course language: German

5–6 Jul 2022 Stuttgart Course language: German

26–27 Jul 2022 Berlin Course language: German

26–27 Jul 2022 Dresden Course language: German

26–27 Jul 2022 Düsseldorf Course language: German

26–27 Jul 2022 Stuttgart Course language: German

+ show all dates

5–6 Jul 2022 Berlin Course language: German

5–6 Jul 2022 Dresden Course language: German

5–6 Jul 2022 Düsseldorf Course language: German

5–6 Jul 2022 Stuttgart Course language: German

26–27 Jul 2022 Berlin Course language: German

26–27 Jul 2022 Dresden Course language: German

26–27 Jul 2022 Düsseldorf Course language: German

26–27 Jul 2022 Stuttgart Course language: German

30–31 Aug 2022 Berlin Course language: German

30–31 Aug 2022 Dresden Course language: German

30–31 Aug 2022 Düsseldorf Course language: German

30–31 Aug 2022 Stuttgart Course language: German

20–21 Sep 2022 Berlin Course language: German

20–21 Sep 2022 Dresden Course language: German

20–21 Sep 2022 Düsseldorf Course language: German

20–21 Sep 2022 Stuttgart Course language: German

25–26 Oct 2022 Berlin Course language: German

25–26 Oct 2022 Dresden Course language: German

25–26 Oct 2022 Düsseldorf Course language: German

25–26 Oct 2022 Stuttgart Course language: German

15–16 Nov 2022 Berlin Course language: German

15–16 Nov 2022 Düsseldorf Course language: German

15–16 Nov 2022 Stuttgart Course language: German

17–18 Nov 2022 Dresden Course language: German

20–21 Dec 2022 Berlin Course language: German

20–21 Dec 2022 Dresden Course language: German

20–21 Dec 2022 Düsseldorf Course language: German

20–21 Dec 2022 Stuttgart Course language: German

7–8 Feb 2023 Berlin Course language: German

7–8 Feb 2023 Dresden Course language: German

7–8 Feb 2023 Düsseldorf Course language: German

7–8 Feb 2023 Stuttgart Course language: German

4–5 Apr 2023 Berlin Course language: German

4–5 Apr 2023 Dresden Course language: German

4–5 Apr 2023 Düsseldorf Course language: German

4–5 Apr 2023 Stuttgart Course language: German

4–5 May 2023 Berlin Course language: German

4–5 May 2023 Dresden Course language: German

4–5 May 2023 Düsseldorf Course language: German

4–5 May 2023 Stuttgart Course language: German

30–31 May 2023 Berlin Course language: German

30–31 May 2023 Dresden Course language: German

30–31 May 2023 Düsseldorf Course language: German

30–31 May 2023 Stuttgart Course language: German

4–5 Jul 2023 Berlin Course language: German

4–5 Jul 2023 Dresden Course language: German

4–5 Jul 2023 Düsseldorf Course language: German

4–5 Jul 2023 Stuttgart Course language: German

25–26 Jul 2023 Berlin Course language: German

25–26 Jul 2023 Dresden Course language: German

25–26 Jul 2023 Düsseldorf Course language: German

25–26 Jul 2023 Stuttgart Course language: German

29–30 Aug 2023 Berlin Course language: German

29–30 Aug 2023 Dresden Course language: German

29–30 Aug 2023 Düsseldorf Course language: German

29–30 Aug 2023 Stuttgart Course language: German

19–20 Sep 2023 Berlin Course language: German

19–20 Sep 2023 Dresden Course language: German

19–20 Sep 2023 Düsseldorf Course language: German

19–20 Sep 2023 Stuttgart Course language: German

24–25 Oct 2023 Berlin Course language: German

24–25 Oct 2023 Dresden Course language: German

24–25 Oct 2023 Düsseldorf Course language: German

24–25 Oct 2023 Stuttgart Course language: German

14–15 Nov 2023 Berlin Course language: German

14–15 Nov 2023 Dresden Course language: German

14–15 Nov 2023 Düsseldorf Course language: German

14–15 Nov 2023 Stuttgart Course language: German

19–20 Dec 2023 Berlin Course language: German

19–20 Dec 2023 Dresden Course language: German

19–20 Dec 2023 Düsseldorf Course language: German

19–20 Dec 2023 Stuttgart Course language: German

X

Contact

Contact

Please Select Your Cookie Preferences:

We use cookies to enhance your experience with personalised content and recommendations, tailored advertising, social media features and for analysing our traffic. Please choose if this site may use web cookies or other technologies that can uniquely recognize your browser (“Cookies”) as described below. You can choose not to permit some types of collection using our cookie settings, which may impact your experience of the website and services we offer.

Essential cookies

Essential cookies help make a website usable by enabling basic functions like course bookings and access to secure areas of the website. The website cannot function properly without these cookies.
Functional cookies

These cookies allow us to analyze your use of the sites, evaluate and improve our performance, and provide a better experience. For example, they help us to know which pages are the most popular and see how visitors move around the sites. They also help power optional features, like social sharing tools.
Advertising / Third-party cookies

These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.

Find out about our use of cookies

save settings