Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB20-PivotTablesStart.xlsm
Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB20-PivotTablesFinished.xlsm
Download Full Written Notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Office2016Class32-ExcelBasics20PivotTables.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:51) Review of PivotTables we have already completed in this class.
3. (03:15) What is Data Analysis in one sentence
4. (03:34) What’s is Proper Data Set in Excel?
5. (03:50) Example 1: Use VLOOKUP to Add New Fields/Column to the Data Set:
6. (06:50) Example 2: Create Country & Product Category Average Revenue Report
7. (08:14) How to interpret Criteria/conditions/filters in a Cross Tabulated Report
8. (10:00) Indicate Until with Label, Not Number Formatting
9. (10:32) Example 3: Change SUM Function to Average Function
10. (11:34) Example 4: Change the PivotTable Style (If you want)
11. (12:33) Example 5: Name PivotTable
12. (13:23) Example 6: Group Daily Dates into Months and Years
13. (16:54) Example 7: Add Year Slicer to our “Country Report” PivotTable and format the Slicer
14. (18:18) How to Interpret Criteria / Conditions / Filters from Rows area, Columns area and Filter or Slicer area in a PivotTable.
15. (20:00) Example 8: From "SalesData" Table, Create Product Revenue PivotTable Report with Multiple Calculations in One PivotTable
16. (22:08) Example of Text Field in Values area of PivotTable
17. (23:25) Example 9: Connect Slicer to 2 Pivots
18. (25:00) Formulas to Test Show Values As PivotTable Calculations
19. (26:30) Example 10: Add a “Show Values As” “Difference From”
20. (29:40) Example 11: Add a “Show Values As” “% Difference From”
21. (30:22) Example 12: Add a “Show Values As” Running Total”
22. (32:22) Example 13: Count of Phones Purchased Report & % Phones Purchased Report
23. (35:21) Example 14: Show Values As % of Row Total: Does CPA Prep Course Help? Report
24. (37:56) Summary – Conclusion