Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
\nDownload Excel Start & Finished File: http:\/\/ift.tt\/2yLoyFx
\nDownload Full Written Notes: http:\/\/ift.tt\/2y3kPPW
\nClass web page link: http:\/\/ift.tt\/2kPyedk
\nTopics in this video:
\n1. (00:01) Introduction
\n2. (01:46) Keyboard for PivotTable
\n3. (04:00) Why a PivotTable is called a PivotTable
\n4. (04:25) Cross Tabulated Report (Adding with 2 Criteria)
\n5. (05:15) Calculations with Conditions or Criteria
\n6. (07:40) Change Calculation in Values area
\n7. (09:18) Drop Number or Text fields in Values area
\n8. (11:43) PivotTables on Large Data Set is Easy!!
\n9. (12:00) Keyboard to jump to bottom of column
\n10. (13:00) Keyboard for PivotTable on New Sheet
\n11. (15:30) Format PivotTable with Style
\n12. (16:05) Slicer to Filter who PivotTable
\n13. (19:24) Summary – Conclusion<\/p>\n
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<\/p>\n