Главная
Study mode:
on
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
Description:
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.

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

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Data Cleaning #Data Processing #Data Transformation #Business Intelligence #Power Query #Spreadsheets #PivotTables
0:00 / 0:00
1 of 24

) Introduction to Power Query and the examples in this video