Microsoft Office Tutorials and References
In Depth Information
This topic's website contains a workbook, reverse pivot.xlsm, which has a macro that will convert any two-way
summary table into a three-column normalized table.
Creating a Pivot Table Automatically
How easy is it to create a pivot table? This task requires practically no effort if you choose a recommended
Recommended pivot tables is a new feature in Excel 2013.
If your data is in a worksheet, select any cell within the data range and choose Insert Insert ⇒ Tables ⇒ Recom-
mended PivotTables, Excel quickly scans your data, and the Recommended PivotTables dialog box presents
thumbnails that depict some pivot tables that you can choose from (see Figure 18-7).