Excel Basics - PivotTable Power - Amazing PivotTable Reporting Tricks - Slicers to Show Values As

) Introduction.
) Review of PivotTables we have already completed in this class..
) What is Data Analysis in one sentence.
) What’s is Proper Data Set in Excel?.
) Example 1: Use VLOOKUP to Add New Fields/Column to the Data Set:.
) Example 2: Create Country & Product Category Average Revenue Report.
) How to interpret Criteria/conditions/filters in a Cross Tabulated Report.
) Indicate Until with Label, Not Number Formatting.
) Example 3: Change SUM Function to Average Function.
) Example 4: Change the PivotTable Style (If you want).
) Example 5: Name PivotTable.
) Example 6: Group Daily Dates into Months and Years.
) Example 7: Add Year Slicer to our “Country Report” PivotTable and format the Slicer.
) How to Interpret Criteria / Conditions / Filters from Rows area, Columns area and Filter or Slicer area in a PivotTable..
) Example 8: From "SalesData" Table, Create Product Revenue PivotTable Report with Multiple Calculations in One PivotTable.
) Example of Text Field in Values area of PivotTable.
) Example 9: Connect Slicer to 2 Pivots.
) Formulas to Test Show Values As PivotTable Calculations.
) Example 10: Add a “Show Values As” “Difference From”.
) Example 11: Add a “Show Values As” “% Difference From”.
) Example 12: Add a “Show Values As” Running Total” .
) Example 13: Count of Phones Purchased Report & % Phones Purchased Report.
) Example 14: Show Values As % of Row Total: Does CPA Prep Course Help? Report.
) Summary – Conclusion.