online

online

Wednesdays:

March 19 + 26, 2025
April 02 + 09 + 30, 2025
May 07 + 21 + 28, 2025

In each case:
13:45 - 15:15

16 LESSONS

Course description:

• How do I design my tables and diagrams in a uniform 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 will be 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