~Get Your Files Here !

  Ex_Files_Excel_PivotTables_in_Depth

   Chapter01

    01_02_Data.xlsx

    01_04_Pivot.xlsx

    01_06_Connect.xlsx

    01_08_Manage.xlsx

    DataSource.xlsx

   Chapter02

    02_02_Summary.xlsx

    02_04_Dates.xlsx

    02_06_GetPivot.xlsx

    02_08_Group.xlsx

   Chapter03

    03_02_Custom.xlsx

    03_04_Rule.xlsx

    03_06_Slicer.xlsx

    03_08_ReportFilter.xlsx

    03_10_Timeline.xlsx

   Chapter04

    04_02_CreateNewStyle.xlsx

    04_04_DataFormat.xlsx

   Chapter05

    05_02_TopTen.xlsx

    05_04_ColorScale.xlsx

    05_06_EditRules.xlsx

    05_08_Delete.xlsx

   Chapter06

    06_02_Pivot.xlsx

    06_04_Format.xlsx

    06_06_Type.xlsx

   Chapter07

    07_02_Options.xlsx

    07_04_Chart.xlsx

   Chapter08

    08_02_Run.xlsm

    08_04_Keyboard.xlsx

   Chapter09

    09_02_Create.xlsx

    09_04_Delete.xlsx

  Glossary_Excel_PivotTablesinDepth

  [10] 9. Enabling and Adding Tables to the Data Model

   [1] Create relationships between tables.srt

   [2] Create a PivotTable using the data model.srt

   [3] Edit table relationships.srt

   [4] Deactivate and delete table relationships.srt

   [5] Define sets using the Data Model.srt

  [11] Conclusion

   [1] Additional resources.srt

  [1] Introduction

   [1] Apply the power of Excel PivotTables.srt

   [2] What you should know before starting.srt

   [3] The changing Excel interface.srt

  [2] 1. Creating and Pivoting PivotTables

   [1] Introduction to PivotTables.srt

   [2] Format data for use in a PivotTable.srt

   [3] Create a PivotTable.srt

   [4] Pivot a PivotTable.srt

   [5] Configure a PivotTable.srt

   [6] Connect to an external data source.srt

   [7] Consolidate data from multiple sources.srt

   [8] Manage PivotTables.srt

   [9] Define a default PivotTable layout.srt

  [3] 2. Summarizing PivotTable Data

   [1] Manage subtotals and grand totals.srt

   [2] Change the data field summary operation.srt

   [3] Summarize more than one data field.srt

   [4] Manage dates in a PivotTable.srt

   [5] Create a calculated field.srt

   [6] Use PivotTable data in a formula.srt

   [7] Drill down to the underlying data.srt

  [4] 3. Sorting and Filtering PivotTable Data

   [10] Filter a PivotTable using a Timeline.srt

   [1] Sort PivotTable data.srt

   [2] Create a custom sort order.srt

   [3] Filter a PivotTable field by selection.srt

   [4] Filter a PivotTable by rule.srt

   [5] Filter a PivotTable using a search filter.srt

   [6] Filter a PivotTable using slicers.srt

   [7] Format slicers.srt

   [8] Filter a PivotTable with report filter fields.srt

   [9] Clear and reapply PivotTable filters.srt

  [5] 4. Formatting PivotTables

   [1] Apply a PivotTable style.srt

   [2] Create a PivotTable style.srt

   [3] Change the PivotTable layout.srt

   [4] Change the data field number format.srt

  [6] 5. Applying Conditional Formats to PivotTables

   [1] Highlight cells by applying a rule.srt

   [2] Highlight the top or bottom values in a PivotTable.srt

   [3] Format cells using data bars.srt

   [4] Format cells using color scales.srt

   [5] Format cells using icon sets.srt

   [6] Edit a conditional formatting rule.srt

   [7] Control how multiple rules are applied.srt

   [8] Delete a conditional formatting rule.srt

  [7] 6. Creating and Formatting PivotCharts

   [1] Create a PivotChart.srt

   [2] Pivot a PivotChart.srt

   [3] Filter a PivotChart.srt

   [4] Format a PivotChart.srt

   [5] Change a PivotChart’s layout.srt

   [6] Change a PivotChart’s chart type.srt

   [7] Add a trendline to a PivotChart.srt

  [8] 7. Printing PivotTables

   [1] Print a PivotTable.srt

   [2] Set PivotTable print options.srt

   [3] Print each item on its own page.srt

   [4] Print a PivotChart.srt

  [9] 8. Manipulating PivotTables

   [1] Record and review an Excel macro.srt

   [2] Run an Excel macro.srt

   [3] Create a simple PivotTable presentation kit.srt

   [4] Change PivotTables using keyboard shortcuts.srt