Information for
Quick links
Faculties
Data import and data analysis (Microsoft Excel)
| Format | Online-Course (Microsoft Teams) On the day before the event, you will receive the online access data by e-mail (invitation to the course in Microsoft Teams). |
| Course language | English (Level B2 required) |
| Course date and time | Thursday, 11 April 2024, 5.00 – 6.30 p.m. |
| Registration | until Monday, 08 April 2024, 10 a.m. via the registration form (closed) |
| Further information | wissenschaft-international(at)isz.uni-saarland.de |
| Course fee | free of charge for international Bachelor's and Master's students and doctoral students from all faculties of Saarland University |
| ECTS points | The workshop (3 wu/work units) can be recognized within the Key Competencies Programme ("Schlüsselkompetenzen-Programm"). Conditions/further information on CP acquisition |
Microsoft Excel is a very powerful tool. However, due to its huge scope, the inhibition to deal with the program in more detail is high.
However, a handful of functions are already sufficient to analyze data easily, quickly and clearly.
This workshop deals with the most important functions and features for a quick start. Step by step, data import, data cleansing and data analysis will be demonstrated using several examples and exercises.
In order to put what you have learned into practice, it is advisable to use a device with the latest Microsoft Excel installed.
Learning Objectives:
The participants will learn:
- 1. The basis of any data file: data import from various sources
- Data import from text files and from the web - 2. The basis for working quickly: data cleansing
- Simple data cleansing - Cleansing functions - 3. Fast evaluations: conditional formatting and standard functions
- Multilevel filters
- Conditional Formatting
- Count If, Sum If
- Data dropdown and SVERWEIS - 4. For illustration: working with charts
- Inserting and editing charts - 5. To complete: tips and tricks to work faster
- Transfer format
- Fixing windows
- Tips and tricks on how to work with more complex formulas
- Linking with other Office applications
The tutor will be happy to answer any questions that you may have.
Tutor:
Kai Rochlus, M.Sc., has finished his master program in Materials Science at Saarland University with top grades. Additionally, to his main course he participated in research visits at Korea University of Technology and Education, Drexel University, Philadelphia and University of California, Santa Barbara. Amongst others, his seminar portfolio includes workshops for scientifically working with different software in an efficient manner.