Number formats:

In lists, it is sometimes necessary to display the weekday of a date.

Can you show a date as a weekday?

Example: 15.06.2017 -> "Thursday"

Evaluate Lists:

Can you make this list...

...into such partial results?

Lists or tables?

Excel can move lists into tables. These are already formatted, have activated filters and have a name. They look like this:

Are you already working with dynamic tables that are automatically formatted and do you know the requirement that they 'work'?

Printing options:

Suppose a list consists of several pages:

Do you make the column headings print out on each page?

Structure:

Let's say you have a very wide and / or a very long list

Can you divide columns and cells to show / hide column or cell ranges?

Functions:

Which of the following formulas do you enter in field B11 to get the same result?

Pivot tables:

You work with lists and want to evaluate them (totals, number etc.).

Do you already solve this with Pivot Tables?

Pivot:

I use pivot tables for simple evaluations and can change them.

Pivot:

I can change the layout of a pivot table and hide the subtotals.

Pivot:

You know drilldowns to create individual tables from a pivot table.