I Finally Tried This Excel Feature Everyone Knows But Ignores—It's Much More Useful Than I Thought
1 min read
Summary
Power Query is an underutilised Excel tool that cleans dirty data and turns it into a consistent, well-structured spreadsheet, saving the user time that would be spend on manual data cleaning.
The author’s data was inconsistent with different formatting, column names and price points amongst other things.
With a few simple steps, the data was cleaned in Power Query Editor, including standardising date formats, replacing values and standardised prices for easy comparison.
The great thing about Power Query is that every step of the cleaning process is recorded, meaning it can be repeated over and over again, saving significant time for future uses and turning burdensome data cleaning into an automated process.
