This evaluation is used to determine whether you have the requirements for a seminar, or whether you are already working on it.

To be able to send you the test results, we need your e-mail address. This is stored together with your test results on our server in order to be able to submit suitable seminar proposals to you. Your data will not be passed on to third parties.

The basis for data processing is Art. 6 para. 1 lit. f DSGVO. You will find further information in our data protection declaration.

 10%

Frage / Question 1 von 10

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?

 
 
 

Frage / Question 1 von 10

Frage / Question 2 von 10

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?

 
 
 
 

Frage / Question 2 von 10

Frage / Question 3 von 10

Text functions:

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

 
 
 

Frage / Question 3 von 10

Frage / Question 4 von 10

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).

 
 
 

Frage / Question 4 von 10

Frage / Question 5 von 10

Date Functions:

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

 
 
 

Frage / Question 5 von 10

Frage / Question 6 von 10

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.

 
 
 
 

Frage / Question 6 von 10

Frage / Question 7 von 10

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?

 
 

Frage / Question 7 von 10

Frage / Question 8 von 10

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.

 

 
 
 

Frage / Question 8 von 10

Frage / Question 9 von 10

Pivot:

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

 
 
 

Frage / Question 9 von 10

Frage / Question 10 von 10

File Management:

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

 
 
 

Frage / Question 10 von 10