Excel 2013 Statistical Analysis #11: Power Query Import Multiple Text Files, Grade Histogram by Year
HTML-код
- Опубликовано: 11 сен 2024
- Download files: people.highlin...
Zipped Files Link: people.highlin...
Topics in this video:
1. (00:16) Over View of File Import and Histogram Creation
2. (00:56) Look at Zipped Folder from class download then unzip it with Right-click, “Extract All”
3. (01:15) Text Files for communication between databases and data analysis programs like Excel
4. (02:06) Use Power Query to Import Multiple Files
5. (02:10) Get External Data Tab in Power Query, From File Button, From Folder Button
6. (02:33) We only need to keep “Content” Column, so right-click “Content” Field Name and point to “Remove Other Columns”
7. (02:51) To reveal data in imported tables, click the button with the Two Downward Point Arrows.
8. (02:58) Filter out Field Name.
9. (04:10) Name Query
10. (04:17) Close and Load To a cell in our worksheet (this brings table of data from the Power Query editor window into our worksheet)
11. (04:51) Build Frequency Distribution with a PivotTable
12. (05:28) Use Find and Replace feature to create non-ambiguous labels in a Grouped Decimal Number PivotTable.
13. (06:31) Add a Slicer for the Year Variable to the PivotTable
14. (07:26) Create Histogram
Excel 2013 Statistical Analysis #11: Power Query Import Multiple Text Files, Grade Histogram by Year
Download files: people.highline.edu/mgirvin/excelisfun.htm
Topics in this video:
1. (00:16) Over View of File Import and Histogram Creation
2. (00:56) Look at Zipped Folder from class download then unzip it with Right-click, “Extract All”
3. (01:15) Text Files for communication between databases and data analysis programs like Excel
4. (02:06) Use Power Query to Import Multiple Files
5. (02:10) Get External Data Tab in Power Query, From File Button, From Folder Button
6. (02:33) We only need to keep “Content” Column, so right-click “Content” Field Name and point to “Remove Other Columns”
7. (02:51) To reveal data in imported tables, click the button with the Two Downward Point Arrows.
8. (02:58) Filter out Field Name.
9. (04:10) Name Query
10. (04:17) Close and Load To a cell in our worksheet (this brings table of data from the Power Query editor window into our worksheet)
11. (04:51) Build Frequency Distribution with a PivotTable
12. (05:28) Use Find and Replace feature to create non-ambiguous labels in a Grouped Decimal Number PivotTable.
13. (06:31) Add a Slicer for the Year Variable to the PivotTable
14. (07:26) Create Histogram
Thank you so much for so many tips. I'm looking for a way to get and accumulate daily data in a web using power query but not yet success. Would you show us how to do it? Thank you very much
Can’t thank you enough for uploading all these videos for free.
Happy to! Thanks for your support, kenzer : )
I think power query is one of the most important inventions and improvements Microsoft did for excel
Yes, best since the PivotTable : )
I really love you.
Thanks so much for refreshing my mind on the best way possible.
Good morning from Kroea and thank you so much in advance.
Thanks!
I love your Videos so much. thanks a lot
+Quynh Nguyen You are welcome a lot!!!!
Thanks so much. This was very informational.
+Daffy Duck Glad you like it!
nice
Thanks
You are welcome, Excel Master clifford : )