2019 Microsoft Excel® Pivot Tables & Introduction To Dashboards The Step-By-Step Guide

CHAPTER 1
How To Use This Book
	Files For Exercises
CHAPTER 2
Introduction To PivotTables
	What Are PivotTables?
	What Are The Main Parts Of A PivotTable?
CHAPTER 3
Creating your first PivotTable
	Preparing the worksheet
	The Recommended PivotTables feature
CHAPTER 4
Basic PivotTable Functionality
	Summarizing Data
	Why Do The ‘∑ Values’ Fields sometimes default to Count instead of Sum?
	How To Drill-Down PivotTable Data
	Adding Additional Rows (categories) To Your PivotTable
CHAPTER 5
Displaying Percentages In PivotTables
CHAPTER 6
Grouping PivotTable Data
	Grouping Records
	Count Function
CHAPTER 7
Slicers, Timelines, & Filtering
	Timeline
	Slicer
	Report Connections
	Formatting Timelines & Slicers
	Ungrouping Date Data
	Conditional Filters
		Value Filters (Top & Bottom Performers)
	Removing Filters
CHAPTER 8
Pivot Charts
	Pie Chart Example
		Quick Layout Options
	Bar Chart Example
		Value Filters & PivotCharts
		Chart Styles
		Stacked Bar Chart
	Line Chart Example
		Grouping Pivot Chart Date Data
	Column Chart Example
		Positive & Negative Values When Charting
CHAPTER 9
Ranking & Sorting PivotTable Results
CHAPTER 10
PivotTables from Imported Files & The Excel® Data Model
	The Excel® Data Model
CHAPTER 11
Consolidating Data From Separate Workbooks To Create A Single PivotTable
	Power Query
	Append vs. Merge in Power Query
CHAPTER 12
Introduction To Dashboards
	What is a Dashboard?
	Dashboard Design
	Dashboard Graphics
		Doughnut Chart
		>Doughnut Chart Example
		Geographic (Maps)
		>Map Example
		Icons (Graphics)
		>Icon Example
		People (Add-Ins)
		>People Graph Example
		Sparklines
		Icon Sets (Conditional Formatting)
CHAPTER 13
Social Media Dashboard Example
	Preparing The Data
	Adding Sparklines To The Dashboard
	Conditional Formatting & Icon Sets
	Formatting The Dashboard
CHAPTER 14
Auto Parts Dashboard Example
	Adding Multiple PivotTables To A Single Workbook
	Calculated Fields
		Removing Or Changing Calculated Fields
		Calculated Field Limitations
	Adding Sparklines To The Dashboard
	Adding a Chart To The Dashboard
	Adding a Timeline To The Dashboard
		Report Connections
CHAPTER 15
Refreshing PivotTable and Dashboard Data
	Appending An Existing (internal) Data Source
	Refresh vs. Refresh All
	Overriding Existing Data (Manually)
	Refreshing Data From An External Source
CHAPTER 16
Protecting Your Dashboard
	Concealing Your PivotTable Source Data
	Protecting The Dashboard Or Any Other Worksheet
Thank you!
More Books Available From This Author
Questions / Feedback