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 | Wednesday, 23 October 2024, 6.00 – 7.30 p.m. |
| Registration | until Wednesday, 16 October 2024, 10.00 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 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.