Using Excel correctly: From the basics to advanced techniques*

This online workshop introduces the structure of the program as well as various calculation and display options in Excel. Participants will practise the practical use of the presented functions on their own computers using small, concrete example tasks.

This course is offered exclusively for FB 02 Humanities and Cultural Studies. A certificate of attendance will be issued for successful participation (proof by submitting the Excel files you have worked on during the workshop).

It is also possible to receive 1 credit for additive key competencies for this course. For this, it is obligatory to hand in the Excel files you have worked on (see above), and you must also complete a piece of coursework in the form of a homework assignment.

Please note your examination regulations, as not every degree program requires the acquisition of additive key competencies.

Contents include

• Getting to know the Excel user interface
• Basics of table editing
• Working with files, folders and tables
• Data entry in Excel (manual, importing data, formatting data)
• Use of function wizards
• Calculating across spreadsheets with simple formulas and functions
  (e.g. basic arithmetic operations, calculating sums, averages, minimum, maximum)
• Using autocomplete with the help of fixed cell references in functions
• Creating and editing diagrams
• Special features when saving and printing, page breaks, creating headers and footers with field functions
• Use and syntax of complex (nested) functions (e.g. SUM, OR, IDENTICAL, REFERENCE, LEFT, LENGTH; TEXT, SEARCH; DIVIDE, FIND)
• Array and matrix formulas
• Effective working with textual cell content (e.g. for participant or address lists)
• Structuring, organizing and monitoring table contents
• Structuring, sorting and filtering according to cell content and formatting
• Create drop-down fields
• Helpful displays for large amounts of data (e.g. "freeze window")
• Create user-defined number formats and lists
• Conditional formatting of cells
• Add comments to cells
• Complex data analyses (e.g. pivot tables, database functions)
• Combine and consolidate data
• Inserting protection and security functions
• Using placeholders/wildcards and comparison operators

No basic knowledge of Excel is required. The exercises are held in Excel 2019 or the corresponding Office 365 version (or Excel Mac). Corresponding explanations for earlier versions can be given on a case-by-case basis. Open Office, light or online versions of the software cannot be used in this course. If you use "Excel" with a different language setting, we recommend that you install the German language pack before the course.

Office365 (incl. Excel) is available free of charge via the ITS website(https://www.uni-kassel.de/its/dienstleistungen/it-arbeitsplatz-management/software-campuslizenzen/microsoft365).

Please allow some time for the installation.

Attention: If you reinstall the program, please remember that the updates may be initialized at the next restart.
The use of a computer mouse and a second screen is recommended so that you can follow the tutorials in parallel.

The course will be held with the "Panopto" program licensed by the University of Kassel. Participating students do not have to download this software, but will receive a link to a video playlist via Moodle. The videos contain individual learning units that can be viewed in the internet browser. The videos contain exercises to be completed during the course. There are videos of sample solutions to the exercises for checking purposes.

The videos are activated for all registered students and can be worked on over several days if required. If you have any questions, the lecturer will help you on three dates via support chats and Zoom.

Registration in the Moodle course is mandatory, as this is where the video playlist, further information and announcements are sent to the participants and the submission of workbooks and certificates of achievement (credit) are organized.

The link for the Moodle course will be sent to you after registration.

Duration:
The videos will be activated on Monday, June 16 (10:00 a.m.) until June 29, 2025 (6:00 p.m.).

The lecturer will answer your questions in the support chats and Zoom on the following days at the times indicated:

Monday, June 16 4:00 p.m. to 5:00 p.m.

Saturday, June 21 10:00 a.m. to 4:00 p.m.

Monday, June 23 2:00 p.m. to 3:00 p.m.

Deadlines:

For the certificate of attendance:

• Processed Excel files for the certificate of attendance by June 29, 6:00 p.m.

For the 1 credit additive key competence:

• Processed Excel files for the certificate of attendance by June 29, 6:00 p.m.
• Processed Excel files for the certificate of achievement by August 03, 18:00

Speaker:
Dipl.-Biol. Nicole Burghardt, MSc. Landscape Planning

Registration via Campus Events