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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
