Course number: 252-300405

each Wednesday: 15.10. + 22.10. + 29.10. + 05.11. + 12.11. + 19.11. + 26.11. + 03.12.2025

each 13:35 - 15:15 (incl. breaks)

Course level:
On the one hand, the course aims to teach important basics in order to be able to use the program sensibly, but on the other hand, advanced content for daily work should not be neglected. The focus of the course is on overcoming difficulties that frequently arise in everyday working life at work or during internships.

Course description:

• How do I design my tables and diagrams in a consistent and clear way?
• How do I create calculations as efficiently as possible?
• How do I get tables and diagrams 1:1 on paper?
• How do I keep an overview even with large tables?
• How can I use EXCEL for data management (also for WORD mail merge)?

These are just some of the questions that users ask themselves in their daily work. This course is dedicated to answering them - and of course to imparting solid, comprehensive knowledge of EXCEL.

First, the efficient handling of the program, e.g. with shortcuts, the input of text and numbers and the formatting of tables are discussed. This is followed by the creation of calculations and formulas. The use of various functions (e.g. sum, mean value, if-then, S-reference, rounding) and calculating with dates and times are covered in detail.

The use of diagrams (circle, line, column, bar and special diagram types) is another important section, as is the insertion of graphics and other objects.

The linking of tables and data management with sorting and filter functions will be further topics. Important aspects of printing are also covered (print areas, headers and footers, page layout).

Finally, options for adapting the program (ribbon/toolbars, macro recorder) and the creation of templates (e.g. time recording, invoices) will be discussed.

All content can be practiced in detail using sample tasks.

Prerequisite for participation: Windows knowledge