Excel Basics - Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set
ExcelIsFun via YouTube
Overview
Syllabus
) Introduction to Power Query and the examples in this video.
) Difference between Data Ribbon Tabs in Office 365 Excel 2016 and Non-Office 365 Excel 2016.
) Example #1: Convert "NOT a Proper Data Set" into a Proper Data Set & Make PivotTable Report.
) Compare Flash Fill and Power Query.
) What is a Delimiter?.
) What is a Query? In Power Query, Access and other programs?.
) Import data from an Excel sheet into the Query Editor using From Table Range button.
) Split By Delimiter.
) Rename columns.
) What is a Data Type?.
) Close Query and Load to Sheet.
) Queries Pane.
) Make PivotTable.
) Add New Data and Refresh.
) Example #2: Import Multiple Text Files & Transform into Proper Data Set.
) Download and unzip Text Files.
) What is a Text File and how are they used in Data Analysis?.
) Use From File, From Folder option to import multiple Text Files into Power Query and combine into a single Proper Data Set.
) Use Query Editor to finish combine query..
) How to edit or delete steps in a query..
) How to edit the folder path if location of folder changes.
) Close and Load straight to s Worksheet..
) Add new Text Files to Folder and update in Excel.
) Summary.
Taught by
ExcelIsFun