Amazon, 2019. — 173 p.
With this practical and to-the-point guide on Pivot Tables and basic Dashboards, you'll develop the skills to build and modify reports with
step-by-step examples and screenshots including how to:Organize and summarize data
Format & filter Pivot Table results
Create Pivot Charts
Display averages & percentages
Group data into predefined ranges
Use Slicers, Timelines, and Sparklines
Rank results
Apply calculated fields
Use Power Query to create and combine Pivot Table reports from imported files
And more!
How To Use This Book
Introduction To PivotTables
Creating your first PivotTable
Basic PivotTable Functionality
Displaying Percentages In PivotTables
Grouping PivotTable Data
Slicers, Timelines, & Filtering
Pivot Charts
Ranking & Sorting PivotTable Results
PivotTables from Imported Files & The Excel Data Model
Consolidating Data From Separate Workbooks To Create A Single PivotTable
Introduction To Dashboards
Social Media Dashboard Example
Auto Parts Dashboard Example
Refreshing PivotTable and Dashboard Data
Protecting Your Dashboard