How to Clean Messy Data for Quick Analysis in Excel? - Using Power Query

How to clean messy data for analysis in Excel? - Using Power Query. Power Query is a fantastic tool enabling you to clean up your Excel Data. Understand how to unpivot Excel Data. Learn how to fill data down. All this by using Power Query.

Exercise file:

Chapters
00:00 - Intro
00:24 - How not to analyse data in Excel
00:53 - How to structure data in Excel
01:20 - What is unpivoted data?
01:45 - Download clean up messy date exercise file
02:00 - How to import data into Power Query?
02:44 - How to fill down in Power Query?
03:19 - Removing Totals from the Data using Power Query
03:41 - How to use Applied Steps in Power Query
04:40 - How to remove totals & nulls from the rows?
05:14 - How to unpivot data using Power Query?
06:30 - Changing column headers and data types in Power Query
07:28 - Loading the data back into Microsoft Excel
08:04 - Create a Pivot Table
09:07 - How to change the format of numbers to accounting in a Pivot Table?
09:39 - Use a custom list with a Pivot Table
11:55 - Create a clustered column chart from the Pivot Table
13:14 - Create a line Chart tracking sales by month
15:10 - How to make the line on a line chart smooth?
15:36 - Create a bar chart from a Pivot Table
17:49 - How to create and use a Slicer in Excel?
18:49 - How to change the orientation of the buttons on a slicer?
19:25 - How to insert a formula into a shape in MS Excel?
20:55 - How to get a slicer to control multiple Pivot Charts?
21:40 - How do you analyse data by season in Excel?
25:30 - How to create a stacked bar chart to analyse by Season in Excel?
28:30 - Add data labels to a stacked bar chart in Excel
29:26 - Changing chart colours in Excel
30:50 - What's Next?

#fyp #computertutoring #excel

😊 Check out my website and social media to keep up to date - enjoy learning 😊

[cindycubbin]

That's pretty cool! Thanks so much!!!

[Balistis]

There are lots of information in this video that we can't even get from many paid lessons. Thank you so much!

[cosminanton]

This here is a very good excel tutorial. Many shortcuts, many high quality information, watch it and you won't regret it, if you want to upgrade your excel skills in 30 minutes.

[sheiladillon]

I didn't know anything about unpivoting data before - thanks!

[xltraining]

Love the fact that you can deal with the merged cells nightmare. Love Power Query

[soft.developer]

I started learn about power query and how to clear messy data yesterday, there are website where i can download to pratice ?

[taimoorzulqarnain]

Great, the actual file is not given by sir, its different one