Number of reports by person and type
Your previous work found the number of reports, total expenditure, and average expenditure for each person, but being able to see a breakdown by person and type of expenditure would reveal even greater insights.
In this exercise, you'll calculate the total number of reports for each person and expense type, which are stored in the grid, G8:K11.
Diese Übung ist Teil des Kurses
Datenanalyse in Google Sheets
Anleitung zur Übung
- In
H9:K11, count the number of expense reports for each person/expense type pair.
Interaktive Übung zum Anfassen
Setzen Sie die Theorie mit einer unserer interaktiven Übungen in die Tat um
Beginnen Sie mit dem Training