Objectives

Based on Relevant functions for the Excel exam 2025.docxand Relevant content for the Python exam 2025.docx:

Excel

For the exam, you should be familiar with the following Excel functions:

  • SUM
  • IF
  • MIN
  • MAX
  • AVERAGE
  • COUNTIF
  • SUMIF
  • AVERAGEIF
  • VLOOKUP
  • XLOOKUP
  • SUBTOTAL (A table with the numbers for the first parameter will be provided in the exam)
Area Students must be able to…
Conditional formulas and references Translate business rules into IF formulas; distinguish relative and absolute references; create formulas that can be copied down; use adjustable parameter cells; calculate sums, averages, commissions, payments and taxes.
Lookups and combined calculations Use XLOOKUP, including nested lookups; fix lookup ranges with absolute references; combine lookups with IF; return empty cells when a condition is not satisfied; calculate VAT, bonuses, travel expenses and totals; make all formulas copyable.
Excel Tables and structured references Use Excel Table notation rather than conventional cell ranges; use SUBTOTAL with the correct function code; use current-row references such as [@Column]; apply SUMIF; and evaluate whether at least one table value satisfies a threshold condition.
PivotTables Place variables correctly in Filters, Columns, Rows and Values; select appropriate filters; use multiple value fields; and choose the required aggregation, particularly sums.

Python

Relevant content for Pandas:

All content of the part “Introduction to Pandas” with the exception of

  • chdir() function and the os module
  • dtypes property, pct_change() function, sort_values() function
  • all statistical functions other than count, sum, mean, min, max, var, and describe. If additional functions are needed, they will be specified in the exam.
  • all chart types other than line and bar charts. Also excluded are the parameters xticks and rot.
  • all slides with the topic “Making Predictions with Pandas and Scikit-Learn”, slides 66-71

Relevant content for Python:

All content on the remaining slides with the exception of

  • the functions: type(), bool()
  • the list operators “in” and “not in” as well as the methods: count(), extend(), index(), reverse()
  • tuples
  • the creation of own modules
  • the datatype Dictionary
  • combining Python and Pandas
  • using services from the Internet

If additional functions are needed, they will be specified in the exam.