Excel Basics 5: PivotTable Power to Create Reports with Various Calculations & Layouts

Excel 2016 Basics Free Course - Learn to Efficiently Use Excel at Work and to Get a Job. - Excel Basics 5: PivotTable Power to Create Reports with Various Calculations & Layouts

4.0 (3)

24 learners

What you'll learn

This course includes

12.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

Highline College Busn 216 Mike Girvin excelisfun Excel Basics Learn Excel Excel Excel 2016 Learn Excel for Free Learn Excel Online Complete Lesson in Excel Basic Excel

Full Transcript

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