Get startedGet started for free

Functions two by two

Getting products to customers on time is very important for DataCo, especially for customers who pay extra for "Same Day" delivery. The Orders sheet has a column called Shipping Mode that contains the different delivery modes for each order - including "Same Day" deliveries. You want to add a new category to the data to indicate if priority orders arrive on time.

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

This exercise is part of the course

Data Preparation in Excel

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise