Excel Basics - Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set

Overview

Learn how to use Power Query to clean and transform data into a proper data set in Excel. The course covers topics such as converting data sets, working with delimiters, importing and combining text files, and editing queries. The teaching method includes practical examples and demonstrations. This course is intended for individuals looking to enhance their data cleaning and transformation skills using Excel's Power Query feature.

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.