Online-Workshop: Excel functions and VBA for advanced international students
In this compact two-day Excel seminar you will pick out two topics: practical use of common and some uncommon Ecxel functions on one side and Excel programming with macros and VBA (= visual basic for applications) on the other.
After the first part of the seminar, you wil be able to use many functions in Excel the right and efficient way. You will discuss and use functions by themselves and complexly nested. After this, you will handle functions easily and know how to find help to functions you haven´t used yet. Apart from this there will be loads of tips and tricks. Working with Excel makes fun, you´ll see!
After the function part of half a day comes automation of things in Excel with macros and VBA. Real programming you won´t learn in only one and a half day, but with a well-structured beginning you will have a good head start and you will be able to continue learning VBA on your own, if you find it useful. You will start with recording and executing macros, then optimize them by hand in the excel visual basic editor. After that, you will write VBA yourself, using all the help functions that the edictor is offering you.
The workshops consists partly of theory and lots of small, useful exercises to learn using Excel in the most efficient way. Come and see what Excel programming can do for you. Are you on?
Preconditions to participate in the workshop:
- at least some working experience with the program
- computer with sound and microphone or headset
- computer camera
- second computer monitor or computer or tablet is of great use; on one screen you will follow the workshop, hear and see the presentation and on the other screen you can do your own exercises in Excel; one big monitor of at least 22 inces (60 cm) is possible too
Please note that this workshop has two dates!
Target group: The workshop is aimed at international students and PhD students of the Viadrina as well as students and PhD students with a migration and/or refugee background. If required and depending on available places, other Viadrina students and PhD students are welcome to participate in the workshop. Please note, however, that final admission will only be granted shortly before the start of the workshop.
(Please note that the workshop is funded by the German Academic Exchange Service (DAAD) as part of the DAAD Integra project. In this context, part of the places are reserved for international female students from Turkey, Syria, Afghanistan, Iran, Iraq, Somalia, Eritrea and Nigeria).
Trainer: Louis Sterck is a physicist who has taught physics first before shifting to teaching software. He is teaching since 25 years cross-media production, using information in many different ways.
ECTS: 1 ECTS - depending on the study and examination regulations of your degree programme, regular attendance and participation in an evaluation.
Please note that all registrations at Training Manager will be admitted first. The final admission will be made by the course organisation shortly before the course starts. Therefore, please feel free to register for the workshop even if it is indicated that all places are already taken.
The seminar takes place online. You will receive the login data short before the course starts.
- Kompetenzen für Bewerbung und Berufseinstieg
- 1. Termin:
- Montag, 01. November 2021, 09:00 Uhr - 17:00 Uhr
- 2. Termin:
- Dienstag, 02. November 2021, 09:00 Uhr - 17:00 Uhr
- Mittwoch, 01. September 2021, 14:30 Uhr
- Sonntag, 24. Oktober 2021, 23:59 Uhr
- Sonntag, 31. Oktober 2021, 23:59 Uhr
- Maximalanzahl Teilnehmer/innen:
If you have any questions, please feel free to contact the project coordination of STEPin - Study Entrance Phase for International Students of the Viadrina International Affairs Department at STEPin@europa-uni.de.
Ihre Anmeldung zu dieser Veranstaltung ist verbindlich. Bitte tragen Sie sich am Ende eines Veranstaltungstages in die Teilnahmeliste ein und evaluieren Sie die Veranstaltung im Trainingsportal.
Bei unentschuldigtem Fehlen wird eine einmalige Verwarnung ausgesprochen, bei wiederholtem Fehlen wird eine Sperrung für das laufende und das folgende Semester für das Trainingsprogramm verhängt. Abmeldungen am Veranstaltungstag gelten nur bei Vorlage eines ärztlichen Attests als entschuldigt. Bei Fragen, wenden Sie sich bitte an den/die Veranstalter*in.