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