CommencerCommencer gratuitement

Pivot. Pivot!

Your Orders sheet is looking great! You've cleaned the data, sorted, created new variables, and even brought in columns from other sheets. Now is a good time to start viewing the prepared data from a different angle and summarize it differently. You can do this by unleashing the power of PivotTables and looking at possible insights related to DataCo orders.

If you lost progress, close any open reports and load 4_2_pivot_pivot.xlsx from the Workbooks folder. If a message appears saying "Security Warning - External Data Connections have been disabled", click on Enable Content and continue.

Cet exercice fait partie du cours

Préparation des données dans Excel

Afficher le cours

Exercice interactif pratique

Passez de la théorie à la pratique avec l’un de nos exercices interactifs

Commencer l’exercice