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

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Dive into an extensive 40-minute tutorial on advanced PivotTable techniques in Excel. Learn 14 powerful reporting tricks, from using slicers to implementing various "Show Values As" options. Master data analysis concepts, proper dataset creation, and VLOOKUP for adding new fields. Explore cross-tabulated reports, date grouping, and connecting slicers to multiple PivotTables. Practice creating diverse reports, including revenue analysis, product comparisons, and running totals. Enhance your Excel skills with practical examples and comprehensive explanations, suitable for both beginners and experienced users looking to elevate their PivotTable proficiency.

Syllabus

) 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.