Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start & Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB04-SUMIFSandPivotTables.xlsx
Download Full Written Notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Office2016Class16-ExcelBasics04-IntroductionToExcel04.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:22) What Excel can do: 1) Calculations, Data Analysis
3. (01:58 and 03:22) What is Data Analysis?
4. (04:00) What is a Proper Data Set?
5. (06:26) SUMIFS for Regional Sales Report, Daily Sales Report and Sales Rep Report
6. (18:32) PivotTable for Regional Sales Report, Daily Sales Report and Sales Rep Report
7. (21:31) Format PivotTable with Tabular Layout
8. (22:18) Add Number Formatting to Values area
9. (30:00) Compare SUMIFS and PivotTable
10. (32:40) Summary - Conclusion
PivotTable Basics, PivotTables 101, PivotTable Lessons, Free PivotTable Lessons, Learn PivotTables Quickly, Efficient PivotTables, PivotTables Are Easy!