Look up, not down
When you first received your data, it was split into different files to allow quicker sharing. Therefore, your workbook has several lookup sheets with useful information for analysis. Eventually, you want to carry out some analysis on the products DataCo sold. Time to bring the product information into your Orders
sheet.
If you lost progress, close any open reports and load 4_1_look_up.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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
