MS 365 Excel Basics 10: Power Query, FlashFill, XLOOKUP, PivotTables Sort & Filter! 7 DA Examples.

Download Excel Zipped Folder with all files (including pdf notes): https://people.highline.edu/mgirvin/AllClasses/218M365/Content/MECS04DownloadFiles.zip Free YouTube Excel & Data Analysis class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo The Only App That Matters book by Mike Girvin at Amazon: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ccs_id=70eb6de0-afb4-4979-a9a7-a1bdc0089ad3 In this video learn about important Excel Data Analysis Tools: Topics in video: 1. (00:00) Introduction 2. (01:05) Download practice files from zipped folder 3. (02:05) On-Premise folder and file paths 4. (03:52) Preview of all examples in videos 10, 11, 12, and 13 5. (05:42) What is Data Analysis? 6. (06:25) Sorting Feature Example 1 7. (10:23) Filtering. Feature Example 2 8. (15:07) FlashFill. Example 3. 9. (17:41) Standard PivotTable with Summarize Values By and Show Values As calculations. Example 4. 10. (22:03) Power Query to import, clean, transform and refresh data and load to Excel Worksheet. Complete Introduction to Power Query. Example 5. 11. (33:27) First look at Power Query’s Functional Language: M Code 12. (48:19) Adding Worksheet formulas to a query in the worksheet 13. (51:30) Updating query when you get new data 14. (54:30) Power Query to Import and combine 12 tables into one table and load directly to a PivotTable Report & Excel Chart Visualization. Example 6. 15. (01:04:10) Load Query to PivotTable 16. (01:05:55) Show Values As Calculations in PivptTable 17. (01:09:45) Excel Line Chart Visualization based on PivotTable 18. (01:13:20) Look at similarities between the Data Models for the Examples 7, 8 & 9 19. (01:17:06) XLOOKUP function, PivotTable and Excel Charts to build report and visualization. Example 7. 20. (01:27:25) Summary of video 21. (01:27:55) Three Practice Problems on the worksheets: HW(1), HW(2), HW(3) 22. (01:28:32) Closing Using the gear icon setting button below the video, you can watch subtitles in these languages: Afrikaans, Arabic, Bengali (some videos), Bangla, Dutch, Filipino, French, Hindi, Indonesian, Khmer, Malay, Malayalam, Nepali, Persian, Polish, Spanish, Swahili, Tamil, Telugu, Thai, Tibetan, Urdu, Vietnamese. Using the gear icon setting button below the video, you can listen to an audio track in these translated languages: French, German, Hindi, Indonesian, Italian, Japanese, Portuguese, and Spanish. #excel #excelisfun #groupby #dataanalysis #Sort #filter #excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions #dataanalysis #powerquery #pivottable #excelbasics