How to Clean Messy Data for Quick Analysis in Excel? - Using Power Query
Channel: Computer Tutoring
Date: 2022-09-12

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:
https://www.computertutoring.co.uk/excel-tutorials/excel-summary-sheet/clean-messy-data-power-query/


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 😊

 📱 http://www.computertutoring.co.uk/ 📱

 📽 https://www.tiktok.com/@thecomptutor 📽

👨‍👩‍👧‍👦  https://www.facebook.com/ComputerTutoring.co.uk/ 👨‍👩‍👧‍👦

 🦉 https://twitter.com/CT_Tutoring 🦉

  📷https://www.instagram.com/computer_tutoring/ 📷

  📌https://www.pinterest.co.uk/CT_Training/ 📌