Download Zipped Folder with All Files: https://excelisfun.net/files/13-M365ExcelClassVideoFiles.zip

This video is a comprehensive lesson in Power Query Importing & Transformation Data in Excel & Power BI. This video shows extensive M Code to create formulas to convert bad data into proper data sets that can be used for analysis.

This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW

This video covers.
1. (00:00) Introduction and video topics
2. (02:24) On-Premise Folder and File Path
3. (03:11) Importing TXT and CSV files
4. (08:08) Create Dynamic File Path in Excel
5. (15:13) Import CSV File with Extra Rows at Top
6. (16:34) Import PDF File
7. (18:22) Import from a Picture
8. (19:30) Import XML File
9. (20:48) Import JSON File
10. (22:24) Import Web Site
11. (25:43) Import Excel File.
12. (26:31) Excel.Workbook function
13. (28:14) Dataflows (Online Power Query) to Import & Transform
14. (35:20) Import Dataflow Tables (Dynamic Data Source)
15. (37:16) Connect to Power BI Data (Single Source of Truth)
16. (39:31) Import Dataverse Data
17. (39:52) Import SQL data & Query Folding
18. (44:51) From Folder for TXT files (Automatic Feature)
19. (49:53) From Folder for 1 Sheet Excel files (Automatic Feature)
20. (51:43) Create Dynamic Folder Path
21. (52:33) Folder.Contents & Folder.Files functions
22. (53:20) From Folder for CSV files (Custom Formula)
23. (56:55) Power BI Parameter for Folder Path
24. (58:33) From Folder for Multiple Object Excel files(Custom Formulas)
25. (01:04:29) Consolidate Excel Tables in Current File using Excel.CurrentWorkbook
26. (01:09:27) Universal Dynamic Folder Path
27. (01:11:44) Fix Inconsistent Field Names in Append (Custom Formulas). Code created in Excel.
28. (01:13:41) Csv.Documnet (Secret Tricks)
29. (01:24:06) Fix Inconsistent Field Names in Power BI Desktop (Custom Formula)
30. (01:25:05) Remove Blank Rows & Columns, Fix Field Names and Add Dynamic Data Types with Custom Column let statement (replaces Custom Function)
31. (01:48:26) Video Summary and Conclusions
32. (01:49:11) Closing and Video Links

Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/ . Artist: http://audionautix.com/

#excel
#excelisfun
#analytics
#analysis
#dataanalysis
#dataanalytics
#excelmvp
#powerbi
#powerquery
#powerbidesktop
#mcode
#mcoder
#importdata
#transformation
#freeclass
#freecourse
#freeclasses
#excelclasses
#powerbicourse
#powerquery
#powerquerytutorial
#microsoftexcel
#microsoftmvp
#datamodel
#datamodeling