Excel 2019 Bible

Part IV: Managing and Analyzing Data

This workbook, named normalized data.xlsx, is available on this book’s website at www

.wiley.com/go/excel2019bible.

Creating a PivotTable Automatically

How easy is it to create a PivotTable? This task requires practically no effort if your data is

appropriately structured and you choose a Recommended PivotTable.

If your data is in a worksheet, select any cell within the data range and choose Insert ➪

Tables ➪ Recommended PivotTables. Excel quickly scans your data, and the Recommended

PivotTables dialog box presents thumbnails that depict some PivotTables from which you

can choose. Figure 29.7 shows the Recommended PivotTables dialog box for the bank

account data.

FIGURE 29.7

Selecting a Recommended PivotTable

The PivotTable thumbnails use your actual data, and there’s a good chance that one of

them will be exactly what you’re looking for—or at least close to what you’re looking for.

Select a thumbnail, click OK, and Excel creates the PivotTable on a new worksheet.

When any cell in a PivotTable is selected, Excel displays the PivotTable Fields task pane.

You can use this task pane to make changes to the layout of the PivotTable.