PivotTables Are Easy! 30 Examples for Highline College Professional Development Day 2014

Download: Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/PivotTablesAreEasyHighlineCollegeProDevDayStartFile.xlsx (Workbook with blank templates) Download: Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/PivotTablesAreEasyHighlineCollegeProDevDayFinishedFile.xlsx (Completed Examples of Video Demonstrations) Download Data Source File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/HugeDataSetHighlineCollegeProDevDay.xlsx Download Finished Example of 4th file created during video: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/PowerPivot-BigDataIsMadeSmallFinished.xlsx Excel 2013 PivotTable Topics Covered in Video: Time Hyperlinked Table of Contents for Video: 1. (00:18 minute mark) Excel 2013 is used for this video, but most on the concepts can be used in any version. 2. (00:40 min mark) Essence of What a PivotTable does: Calculations with Criteria & Creating Summary reports 3. (04:34 min mark) Proper Data Set? 4. (06:41 min mark) Conceptual Keys to making PivotTables easy (10:32 min mark) PivotTable Basics on Student Grade Data: 5. (11:26 min mark) Create PivotTable: INSERT Ribbon Tab, PivotTable 6. (12:09 min mark) PivotTable Field List 7. (12:30 min mark) Drag and Drop Fields from PivotTable Field List to ROW, COLUMN, FILTER (these are the criteria). Drag and Drop Fields that you want to make calculations upon to VALUES (Calculations with Criteria) 8. (13:42 min mark) Values Field Settings: Change Calculation Name, Function, Number Formatting 9. (14:39 min mark) Number Formatting, Not "Cell Formatting" 10. (16:04 min mark) Format Report with: Design Ribbon Tab, Report Layout button, "Show in Tabular" 11. (17:32 Cross Tabulated Table. Average Calculation with 2 Criteria. GPA calculation by Major and Class. 12. (19:29 min mark) Filter & Slicer. Slicer is in Analyze Ribbon Tab. Average Calculation with 2 Criteria. GPA calculation by Major and Class. 13. (21:46 min mark) Format Slicer. 14. (22:53 min mark) Human Resource Data Example: How Many In Each Department? Total Hours per Department. 15. (23:08 min mark) Calculations on TEXT. 16. (25:12 min mark) Business Data Example: Sum Product by Month and Year (Group by Month & Year) 17. (26:21 min mark) Group by Date: Month and Year. 18. (27:50 min mark) Pivot the PivotTable.. 19. (28:13 min mark) Create 12 Reports Instantly with Criteria in Filter 20. (29:01 min mark) Show Report Filter Pages: Analyze Ribbon Tab, PivotTable group, Options drop-down arrow, Show Report Filter Pages 21. (30:34 min mark) Library Data Example: How Many Times Each Book Checked Out? Total Days For Each Book? 22. (33:04 min mark) Multiple Tables in One PivotTable Field List with Excel 2013 & Table Feature 23. (34:45 min mark) Create Excel Table. 24. (35:47 min mark) Get two tables into PivotTable Field List. 25. (36:55 min mark) Create Relationships between two tables. 26. (38:56 min mark) Bring Huge Data into Excel 2013 PowerPivot to reduce File Size 27. (41:07 min mark) Versions of Excel 2013 that have PowerPivot 28. (41:24 min mark) Get External Data dialog box: Import Table. 29. (41:58 min mark) Columnar In Memory Database (XVelocity engine in PowerPivot) 30. (42:52 min mark) Create PivotTable from PowerPivot Data Model. 31. (43:22 min mark) Summary Highline College Professional Development Day 2014. October 17, 2014.