How to clean messy data for quick analysis in Excel?

Have you ever inherited a spreadsheet and not been able to make head nor tail of it and your tempted to completely start from scratch and enter all the information again. No matter how crazy your spreadsheet is, there is a way to restructure it in the correct way, and hence data analysis will be a breeze.

A video poster file for how to clean up messy data, with  a picture of someone scratching their head.

How to clean messy data for analysis in Excel using Power Query?
You have heard of Power Query and no doubt you have come across your fair share of messy data in Microsoft Excel. The question you might have asked yourself just 'How do you use Power Query to clean up messy data in Excel.

In this free training video you'll find out the do's and dont's of Excel data including:

  • What makes messy data?
  • What advantage is there to cleaning up messy data?
  • How to get data into Power Query?
  • How to analyse my data?

Written step by step instructions are also available:
How to clean messy data for analysis in Excel using Power Query?



Looking for something specific?