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.