Microsoft Excel 2019 pivot table data crunching
Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if...
| Main Authors: | , |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
[Place of publication not identified]
Published with the authorization of Microsoft Corporation by Pearson Education
2019
|
| Series: | MrExcel Library
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Cover Page
- Title Page
- Copyright Page
- Dedication Page
- Contents at a Glance
- Contents
- Acknowledgments
- About the Authors
- Introduction
- Chapter 1 Pivot table fundamentals
- Why you should use a pivot table
- When to use a pivot table
- Anatomy of a pivot table
- Values area
- Rows area
- Columns area
- Filters area
- Pivot tables behind the scenes
- Pivot table backward compatibility
- A word about compatibility
- Next steps
- Chapter 2 Creating a basic pivot table
- Ensuring that data is in a Tabular layout
- Avoiding storing data in section headings
- Avoiding repeating groups as columns
- Eliminating gaps and blank cells in the data source
- Applying appropriate type formatting to fields
- Summary of good data source design
- How to create a basic pivot table
- Adding fields to a report
- Fundamentals of laying out a pivot table report
- Adding layers to a pivot table
- Rearranging a pivot table
- Creating a report filter
- Understanding the Recommended PivotTable and the Ideas features
- Using slicers
- Creating a standard slicer
- Creating a Timeline slicer
- Keeping up with changes in the data source
- Displaying a change from a previous field
- Tracking the percentage of a parent item
- Tracking relative importance with the Index option
- Adding and removing subtotals
- Suppressing subtotals with many row fields
- Adding multiple subtotals for one field
- Formatting one cell is new in Office 365
- Next steps
- Chapter 4 Grouping, sorting, and filtering pivot data
- Using the PivotTable Fields list
- Docking and undocking the PivotTable Fields list
- Rearranging the PivotTable Fields list
- Using the Areas section drop-downs
- Sorting in a pivot table
- Making report layout changes
- Using the Compact layout
- Using the Outline layout
- Using the traditional Tabular layout
- Controlling blank lines, grand totals, and other settings
- Customizing a pivot table's appearance with styles and themes
- Customizing a style
- Modifying styles with document themes
- Changing summary calculations
- The Excel team fixed the Count Of Revenue bug
- Changing the calculation in a value field
- Showing percentage of total
- Using % Of to compare one line to another line
- Showing rank
- Tracking running total and percentage of running total
- Dealing with changes made to the existing data source
- Dealing with an expanded data source range due to the addition of rows or columns
- Sharing the pivot cache
- Side effects of sharing a pivot cache
- Saving time with new PivotTable tools
- Deferring layout updates
- Starting over with one click
- Relocating a pivot table
- Next steps
- Chapter 3 Customizing a pivot table
- Making common cosmetic changes
- Applying a table style to restore gridlines
- Changing the number format to add thousands separators
- Replacing blanks with zeros
- Changing a field name