Get startedGet started for free

Series filling

You used Flash-fill to populate a column in Excel easily. But what if you haven't got existing data that can be used to find a pattern? The Fill Series feature of Excel can help here. You might have seen that the Orders sheet has a date column present. It is good practice to create a date lookup sheet that you can use for date preparation later on.

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