Introduction Creating Microsoft Excel PivotTables Using the Query in Microsoft Excel 1. Start Excel and open a new worksheet. 2. Select the Data menu; then select PivotTable Report. AR Report Applet User’s Manual 1-17