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/ex...


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/

  / thecomptutor  

‍‍‍   / computertutoring.co.uk   ‍‍‍

  / ct_tutoring  

  / computer_tutoring  

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