Excel 2019 Bible

xxxi

Contents

Formatting the PivotTable.......................................................................... 668

Modifying the PivotTable ........................................................................... 670

Seeing More PivotTable Examples ........................................................................ 672

What is the daily total new deposit amount for each branch? ........................ 672

Which day of the week accounts for the most deposits? ................................ 672

How many accounts were opened at each branch, broken

down by account type? .......................................................................... 674

How much money was used to open the accounts? ....................................... 674

What types of accounts do tellers open most often? ..................................... 675

In which branch do tellers open the most checking accounts

for new customers? ................................................................................ 676

Learning More ................................................................................................... 677

Chapter 30: Analyzing Data with PivotTables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  679

Working with Non-numeric Data .......................................................................... 679

Grouping PivotTable Items .................................................................................. 681

A manual grouping example ....................................................................... 681

Automatic grouping examples..................................................................... 683

Grouping by date .............................................................................. 683

Grouping by time .............................................................................. 688

Using a PivotTable to Create a Frequency Distribution .......................................... 689

Creating a Calculated Field or Calculated Item ...................................................... 691

Creating a calculated field .......................................................................... 693

Inserting a calculated item ........................................................................ 695

Filtering PivotTables with Slicers ........................................................................ 698

Filtering PivotTables with a Timeline .................................................................. 700

Referencing Cells within a PivotTable .................................................................. 701

Creating PivotCharts .......................................................................................... 703

A PivotChart example ................................................................................ 703

More about PivotCharts .............................................................................. 706

Using the Data Model ......................................................................................... 707

Chapter 31: Performing Spreadsheet What-If Analysis. . . . . . . . . . . . . . . . . . . . . . . . . .  715

Looking at a What-If Example ............................................................................. 715

Exploring Types of What-If Analyses .................................................................... 717

Performing manual what-if analysis ............................................................ 717

Creating data tables ................................................................................... 717

Creating a one-input data table .......................................................... 718

Creating a two-input data table ......................................................... 721

Using Scenario Manager ............................................................................. 725

Defining scenarios ............................................................................ 725

Displaying scenarios ......................................................................... 728

Modifying scenarios .......................................................................... 729

Merging scenarios ............................................................................. 729

Generating a scenario report .............................................................. 730