Datenimport und Datenauswertung (Microsoft Excel)

Data import and data analysis (Microsoft Excel)

FormatOnline-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 languageGerman (Level B2 required)
Course date and timeWednesday, 23 October 2024, 4.00 – 5.30 p.m. 
Registrationuntil Monday, 16 October 2024, 10.00 a.m. via the registration form (closed)
Further Informationwissenschaft-international(at)isz.uni-saarland.de
Course feefree of charge for international Bachelor's and Master's students and doctoral students from all faculties of Saarland University
ECTS pointsThe workshop (3 work units) is recognized within the Compass Program.
You can receive an equivalency certificate: 30 work units = 1 credit point (CP).  
Conditions/further information on the acquisition of CP/ECTS credits

Efficient data handling is essential for many tasks. In this interactive workshop, you will learn how to import, clean, and analyze data from various sources. You will discover how to import data from text files and the web and process it in a machine-readable format. The course also teaches you how to use conditional formatting and standard functions like COUNTIF and SUMIF to conduct quick analyses. Additionally, you’ll learn how to insert and edit charts to visually present your data. Practical exercises will help you apply what you’ve learned immediately.  

1. The Foundation of Every File: 

  • Data Import from Various Sources  
  • Data import from text files  
  • Data import from the web  

2. Basis for Efficient Work: 

  • Data Cleaning  
  • Simple data cleaning  
  • Using cleaning functions  

3. Quick Analyses: 

  • Conditional Formatting and Standard Functions  
  • Applying multi-level filters  
  • Using conditional formatting  
  • Using the COUNTIF function  
  • Using the SUMIF function  
  • Using data drop-downs and VLOOKUP  

4. Visualizing Data: 

  • Working with Charts  
  • Inserting charts  
  • Editing charts  

5. Bonus: 

  • Tips and Tricks for Faster Work  
  • Transferring formats  
  • Freezing panes  
  • Tips for more complex formulas 
  • Linking with other Office applications  

Kai Rochlus will be happy to answer any questions you may have!  

Disclaimer: The online course is based on the latest version of Office 365 for Windows. Commands may differ or be missing in older versions or in Office for Mac.

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.

Postal address

Internationales Studienzentrum Saar (ISZ Saar)
der Universität des Saarlandes
Campus, Gebäude A3 2
66123 Saarbrücken
Germany