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 obtain 1 credit for additive key competencies for this course at  . For this, the submission of the processed Excel files (see above) is obligatory, in addition  a study achievement, in the form of a homework assignment, must be provided.

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

For more information and to register, please click here.