Completed
) Example 2: Create Country & Product Category Average Revenue Report
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Basics - PivotTable Power - Amazing PivotTable Reporting Tricks - Slicers to Show Values As
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Review of PivotTables we have already completed in this class.
- 3 ) What is Data Analysis in one sentence
- 4 ) What’s is Proper Data Set in Excel?
- 5 ) Example 1: Use VLOOKUP to Add New Fields/Column to the Data Set:
- 6 ) Example 2: Create Country & Product Category Average Revenue Report
- 7 ) How to interpret Criteria/conditions/filters in a Cross Tabulated Report
- 8 ) Indicate Until with Label, Not Number Formatting
- 9 ) Example 3: Change SUM Function to Average Function
- 10 ) Example 4: Change the PivotTable Style (If you want)
- 11 ) Example 5: Name PivotTable
- 12 ) Example 6: Group Daily Dates into Months and Years
- 13 ) Example 7: Add Year Slicer to our “Country Report” PivotTable and format the Slicer
- 14 ) How to Interpret Criteria / Conditions / Filters from Rows area, Columns area and Filter or Slicer area in a PivotTable.
- 15 ) Example 8: From "SalesData" Table, Create Product Revenue PivotTable Report with Multiple Calculations in One PivotTable
- 16 ) Example of Text Field in Values area of PivotTable
- 17 ) Example 9: Connect Slicer to 2 Pivots
- 18 ) Formulas to Test Show Values As PivotTable Calculations
- 19 ) Example 10: Add a “Show Values As” “Difference From”
- 20 ) Example 11: Add a “Show Values As” “% Difference From”
- 21 ) Example 12: Add a “Show Values As” Running Total”
- 22 ) Example 13: Count of Phones Purchased Report & % Phones Purchased Report
- 23 ) Example 14: Show Values As % of Row Total: Does CPA Prep Course Help? Report
- 24 ) Summary – Conclusion
