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

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn how to use Excel's Power Query (Get & Transform) feature to clean and transform data into proper data sets in this comprehensive 31-minute tutorial. Explore the differences between Data Ribbon Tabs in various Excel versions, convert unstructured data into a proper data set, and create PivotTable reports. Discover the power of Flash Fill, understand delimiters and queries, and master data importing techniques. Dive into data types, column renaming, and efficient use of the Query Editor. Learn to import and combine multiple text files, edit query steps, and update data seamlessly. Perfect for Excel users looking to enhance their data manipulation and analysis skills.

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.