Completed
) Close and Load straight to s Worksheet.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Basics - Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction to Power Query and the examples in this video
- 2 ) Difference between Data Ribbon Tabs in Office 365 Excel 2016 and Non-Office 365 Excel 2016
- 3 ) Example #1: Convert "NOT a Proper Data Set" into a Proper Data Set & Make PivotTable Report
- 4 ) Compare Flash Fill and Power Query
- 5 ) What is a Delimiter?
- 6 ) What is a Query? In Power Query, Access and other programs?
- 7 ) Import data from an Excel sheet into the Query Editor using From Table Range button
- 8 ) Split By Delimiter
- 9 ) Rename columns
- 10 ) What is a Data Type?
- 11 ) Close Query and Load to Sheet
- 12 ) Queries Pane
- 13 ) Make PivotTable
- 14 ) Add New Data and Refresh
- 15 ) Example #2: Import Multiple Text Files & Transform into Proper Data Set
- 16 ) Download and unzip Text Files
- 17 ) What is a Text File and how are they used in Data Analysis?
- 18 ) Use From File, From Folder option to import multiple Text Files into Power Query and combine into a single Proper Data Set
- 19 ) Use Query Editor to finish combine query.
- 20 ) How to edit or delete steps in a query.
- 21 ) How to edit the folder path if location of folder changes
- 22 ) Close and Load straight to s Worksheet.
- 23 ) Add new Text Files to Folder and update in Excel
- 24 ) Summary
