Cleaning up data with the ribbon
IntermediateAdvanced
8 questions, about 15 minutes
Split columns, fill in a pattern, remove duplicate rows and replace words in one go, without formulas.
What we'll do
- Text to Columns
- Flash Fill
- Remove Duplicates
- Find and Replace
What you'll use
- The Excel menus
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
8questionsYou do it yourself