Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise