Teamwork:

Several colleagues work with a workbook and the following picture appears:

Do you know how to work with multiple users at the same time in a workbook and lock individual areas for editing?

Validity / data validation:

You enter values in Excel and want to ensure that Excel only allows valid values, for example, only date values in the date column.

Can you do this?

Text functions:

You can edit values from your list of text functions, for example, to extract merchandise groups from an article match code.

Text functions

You can concatenate multiple cells (from column A and column B) with formulas and functions so that the information is merged into one cell (in column C).

Date Functions:

You can create annual, quarterly, monthly, and calendar week evaluations by creating the grouping values from a date column.

Pivot:

You can perform in a pivot table annual, quarterly, monthly and weekly calendar evaluations and can group them. You also know the disadvantages of this method.

Slicers:

They evaluate lists and often require different filters.

Are you already using slicers (and from version 2013 onwards also time axes) for your filters in pivot tables?

Dashboards:

You are proficient in creating and editing pivot tables and can generate evaluations using pivot tables, pivot charts, and slicers as in this picture.

Pivot:

You can calculate shares with pivot tables, and create calculated fields.

File Management:

You already work with Excel templates to create workbooks of the same type and to protect them from changes.