Tricks with Pivot Tables Creating a Frequency Tabulation Unlinking a Pivot Table from its Source Data Converting a Summary Table to a List Controlling References to Pivot Table Cells Replicating a Pivot Table for Report Filter Items Sorting a Pivot Table Manuallyġ. Charting Pivot Tables Creating Pivot Charts Customizing Pivot Charts 7. Calculations and Custom Formulas Calculating Common Statistics Calculating Multiple Statistics Adding Custom Calculations 5. Grouping Items Grouping by Selected Items Grouping by Time Periods Grouping by Numbers 4. Nesting Fields Adding Nested Fields Showing and Hiding Levels 3. Pivot Table Basics Downloading the Sample Workbook Data Requirements for Pivot Tables Creating Pivot Tables Laying Out Pivot Tables Refreshing Pivot Tables Formatting Pivot Tables Showing a Value’s Source Data Changing a Pivot Table’s Source Data 2.
Editor: Kevin Debenjak Proofreader: Janet Ott Compositor: Kim Frees Cover: Questing Vole Pressīy the Same Author Excel 2016 for Mac Pivot Tables Excel Pivot Tables (2007, 2010, 2011, 2013) Mastering Excel Loan & Mortgage Formulas Mastering Excel Sum & Count Formulas Mastering Excel Date & Time Formulas Essential Algebra: A Self-Teaching Guide Essential Trigonometry: A Self-Teaching Guide For a complete list of titles, go to. Excel 2016 for Windows Pivot Tables by Tim Hill Copyright © 2016 by Questing Vole Press.
