Sub-totals
Carrying out quick calculations of numerical values within our dataset is a great way to sense-check that things are in order and ready for much deeper analysis later on. We don't even need to start creating formulas by hand - Excel provides us with features that make it easy for us to check our data.
The management team would like to understand whether there is a significant difference between each country's order to the delivery period. In this exercise, we'll use Sub-Totals to work this out.
If you lost progress, close any open reports and load 2_2_sub_totals.xlsx
from the Workbooks
folder on your local computer.
This exercise is part of the course
Introduction to Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
