Get startedGet started for free

Flashy filling

When preparing your dataset, keeping track of how large the file size will be and how easy it is to read and view the data when looking at sheets is important. The lookup sheets help make the file more efficient and readable, as you can reduce the number of columns in just one sheet. However, better ways exist to display the information in these lookup sheets. This might be a good time to use Excel's fill features!

If you lost progress, close any open reports and load 1_3_flashy_filling.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