Excel 2013 Statistical Analysis #11: Power Query Import Multiple Text Files, Grade Histogram by Year

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

[@excelisfun]

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

[@hoangbachdao]

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

[@kenham5324]

Can’t thank you enough for uploading all these videos for free.

[@excelisfun]

Happy to! Thanks for your support, kenzer : )

[@DIGITAL_COOKING]

I think power query is one of the most important inventions and improvements Microsoft did for excel

[@excelisfun]

Yes, best since the PivotTable : )

[@CryptoQuantum]

I really love you.
Thanks so much for refreshing my mind on the best way possible.

[@Chamchijjige]

Good morning from Kroea and thank you so much in advance.

[@pphong]

Thanks!

[@pucca9090]

I love your Videos so much. thanks a lot

[@excelisfun]

+Quynh Nguyen You are welcome a lot!!!!

[@hodgej]

Thanks so much. This was very informational.

[@excelisfun]

+Daffy Duck Glad you like it!

[@vijaysahal4556]

nice

[@Clifffffffffford]

Thanks

[@excelisfun]

You are welcome, Excel Master clifford : )