Download files: https:\/\/people.highline.edu\/mgirvin\/AllClasses\/348\/348\/2024\/Content\/Week06\/Video03Files.zip<\/a> Pdf notes to read online: https:\/\/people.highline.edu\/mgirvin\/AllClasses\/348\/348\/2024\/Content\/Week06\/03-DAMEMPT.pdf<\/a>
\nFree YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike \u201cexcelisfun\u201d Girvin. This video teaches you the beauty and simplicity of PowerQuery yo get, transform, abd load the data to the location that you want\/.<\/p>\n

Topics:
\n1. (00:00) Introduction
\n2. (00:26) Free PivotTable Cheat Sheet in workbook file or pdf notes
\n3. (00:39) Toy sales Data Set
\n4. (01:21) Why use PivotTables?
\n5. (01:58) Basics of PivotTables
\n6. (02:35) PivotTable Cache
\n7. (04:02) Change Default PivotTable Layout
\n8. (04:40) PT Calculations: Summarize Values By, Show Values As and Calculated Fields
\n9. (05:53) Cross Tabulated Tables and the AND Logical Test
\n10. (06:23) What a Filter or Sliver does to PT calculations
\n11. (07:45) Name PivotTable
\n12. (09:00) Connect 2 PT to 1 Slicer
\n13. (09:15) Calculated Field
\n14. (11:07) Sort PT by Values
\n15. (11:30) Extract records from a PT cell
\n16. (12:06) Create PivotTable Styles
\n17. (13:37) What happens if you copy a PT?
\n18. (14:45) Group By Inconsistent Data Error
\n19. (15:38) Fix Text Dates with Hack in worksheet
\n20. (17:07) Group By Feature for 1) Integers Numbers or 2) Decimal Numbers
\n21. (20:56) Grouping persists in the PivotTable Cache
\n22. (21:27) Create New Grouping in new PivotTable Cache using 3-step PivotTable Wizard
\n23. (23:21) Modify PivotTable Styles
\n24. (23:42) Show Values As Calculations: % of Column Total, % of Parent Total, % of Row Parent Total
\n25. (26:05) Show Values As Calculations: Difference From and % Difference From
\n26. (27:18) Show Values As Calculations: Running Total, % Running Total
\n27. (29:00) Summarize Survey Data
\n28. (29:41) Create Cross Tabulated Report and Visual
\n29. (31:20) Create and Use a Joint Probability Table
\n30. (34:42) Load 7 million rows of data to PivotTable Cache to make simple Pivot Report
\n31. (37:01) Append csv files inti PivotTable Cache using From Folder and the C
\n32. (42:22) Create 5 reports with a single click: Show Report Filter Pages feature
\n33. (43:17) Summary
\n34. (44:11) Conclusion<\/p>\n","protected":false},"excerpt":{"rendered":"

Download files: https:\/\/people.highline.edu\/mgirvin\/AllClasses\/348\/348\/2024\/Content\/Week06\/Video03Files.zip Pdf notes to read online: https:\/\/people.highline.edu\/mgirvin\/AllClasses\/348\/348\/2024\/Content\/Week06\/03-DAMEMPT.pdf Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike \u201cexcelisfun\u201d Girvin. This video teaches you the beauty and simplicity of PowerQuery yo get, transform, abd load the data to the location that you want\/. Topics: […]<\/p>\n","protected":false},"author":3,"featured_media":6753,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[101,21],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2024\/04\/U8GJSjGLpLY.jpg?fit=480%2C360&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-1KT","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/6751"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=6751"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/6751\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/6753"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=6751"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=6751"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=6751"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}