Главная
Study mode:
on
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
Description:
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.

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

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Data Visualization #Data Interpretation #Computer Science #Information Technology #Data Management #Data Formatting #Slicers #Spreadsheets #VLOOKUP #PivotTables
0:00 / 0:00
1 of 24

) Introduction