Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start & Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB05-PivotTableCalculationsLayout.xlsx
Download Full Written Notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Office2016Class17-ExcelBasics05PivotTableCalculationsLayout.pdf
Class web page link: https://people.highline.edu/mgirvin/AllClasses/216v2016/Content/04Excel/Excel2016.htm
Topics in this video:
1. (00:01) Introduction
2. (01:46) Keyboard for PivotTable
3. (04:00) Why a PivotTable is called a PivotTable
4. (04:25) Cross Tabulated Report (Adding with 2 Criteria)
5. (05:15) Calculations with Conditions or Criteria
6. (07:40) Change Calculation in Values area
7. (09:18) Drop Number or Text fields in Values area
8. (11:43) PivotTables on Large Data Set is Easy!!
9. (12:00) Keyboard to jump to bottom of column
10. (13:00) Keyboard for PivotTable on New Sheet
11. (15:30) Format PivotTable with Style
12. (16:05) Slicer to Filter who PivotTable
13. (19:24) Summary - Conclusion

PivotTable Basics, Pivot Table Basics, Learn PivotTables, Learn Pivot Tables, Lesson in Pivot Tables, How to create a PivotTable, PivotTables Are Easy! Pivot Tables Are Easy! How to Create a PivotTable Report, Pivot Table Reports