Arbeiten mit Microsoft Excel

Lehrende/Lecturer/s: Prof. Dr. Martin Missong
Zeitraum/Time period: Anytime
Credit Points: 3 CP
Workload: 90 hours
Sprache/Language: deutsch
VAK-Nr./Course No.: eGS-AME-08
Anbieter/Supplier: eGS
Lizenz/License: CC BY SA
Open course

Content of the Course

With the introductory module "Why Excel", the event is aimed at those who have never worked with the program. The remaining eight modules can be worked through according to need and interest. In addition to the design of worksheets, the formatting of tables and the sensible use of conditional formatting will be explained. The structuring of calculations as well as the visualization of cell references are presented and basic skills for the evaluation of Excel lists are taught. In addition, possibilities for printing Excel folders are shown and in which form they can be transferred to other users.

Acquisition of Competences

You are familiar with the basic functionalities of the Microsoft Excel spreadsheet program. You will set up workbooks in a structured manner to ensure smooth teamwork, i.e. with changing editors of the workbooks, in the subsequent creation phases. You will be familiar with important organizational and security aspects when passing on workbooks.

Exam Information

To receive a certificate of achievement and credit points, you must complete the course with an electronic exam. You can choose the examination date freely from several examination times in the semester. The examination takes place in the university's test center in presence.

Target Group

The course is open to students of all disciplines. The offer is especially addressed to students of the University of Bremen and students of Higher Education Institutes in the state of Bremen. The content is designed as OER (Open Educational Resources) and therefore available for all interested parties. In principle, the learning videos can also be used in non-university settings. Thus, learners from other groups (e.g. companies) also have the opportunity to benefit from them.

Lecturers of the Course

Prof. Dr. Martin Missong is Professor of Empirical Economic Research and Applied Statistics at the University of Bremen. His research focuses on answering current questions in business and economics using modern quantitative methods with an emphasis on the development and application of time series models in finance and risk management. Furthermore, Prof. Dr. Missong researches how basic statistical knowledge and quantitative skills can help lawyers to improve the quality of jurisprudence.

Course Management

This course is managed by the eGeneral Studies team. If you have any questions, please contact: info@egs.uni-bremen.de

Duration

This course is a self-paced course. It takes place only online; you can start with the course at any time.

Requirements

None, Course for basic knowledge