Administration and Executive AssistantTier 140 minbeginner

Fill and Flash Fill

Recognize patterns and let Excel finish the work.

What you will learn

• Use Fill Down to replicate formulas across rows
• Understand Flash Fill and when it applies
• Fill a series with patterns (days, months, numbers)
• Double-click fill handle to auto-fill

Excel skills

Fill Down, Fill Series, Flash Fill, fill handle · Pattern Filling

The task

New starter list, twenty names. I need an Employee ID for each one: first three letters of the surname, first two of the first name, a hyphen, then the three-letter department code. All uppercase.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free