To take this course participants must know the topics in Excel Course 5 before taking this course.

Build on your PivotTable know-how with practical techniques for creating customized reports and adding visual elements that make your data easier to understand—and more impactful.

Data Source & Details

Table vs Range / Refresh vs Refresh All
Add PivotTable to Existing Sheet
Move & Copy PivotTables
Creating Filter Pages
Showing Details / Disable Details

Grouping & Calculations

Date Grouping / Using Formulas Instead
Number Grouping / Custom Groups
Calculated Fields / Calculated Items
What is GetPivotData

Printing & Appearance

Print Options / Print Titles
Blank Lines & Page Breaks
Using and Basic Creating Styles
Adding Conditional Formatting

Slicers & PivotCharts

Add Slicers / Slicer Settings & Options
Connect Slicers to Multiple PivotTables
Create PivotCharts

1287 - Excel Course 6: Pivot Tables Part 2