PivotTable. PivotTable is a functionality in Excel which helps you organize and analyze data. It lets you add and remove values, perform calculations, and to filter and sort data sets. PivotTable helps you structure and organize data to understand large data sets. The data that you use needs to be in tabular format. 4. Create Pandas Pivot Table 4.1 Group the Data into Pivot Table using Index Param. Using the Pandas pivot_table() function we can reshape the DataFrame in the form of an Excel pivot table in the simplest way. If you want to dive right in and create your own pivot table instead, go to the Insert tab and pick "PivotTable" in the ribbon. You'll see a window appear for PivotTable From Table or Range. At the top, confirm the data set in the Table/Range box. Then, decide if you want the table in a new worksheet or your existing one. Click on the “Insert” tab located on the Excel Ribbon. Select the “Pivot Table” choice from the available options in the drop-down menu. Select the range of data you wish to include in your Pivot Table. Choose the location where you want to place your Pivot Table. Lastly, click on “OK” to create the Pivot Table. We’ll cover some very basic things about creating a Pivot Table. Let’s start with a blank Excel file and source data. It’s very easy to add a pivot table: Select your source data and go to Insert > Pivot Table > From Table/range. Click "Insert" at the top of the screen. 2. Click the "PivotTable" button on the Ribbon. 3. Select the first table you want to add to the pivot table. 4. Check the box labeled "Add this data to Pivot tables are one of Excel’s most powerful data analysis tools, used extensively by financial analysts around the world. In a pivot table, Excel essentially runs a database behind the scenes, allowing you to easily manipulate large amounts of information. How to Use a Pivot Table in Excel. Below is a step by step guide of how to insert a Select all the data in your pivot table sheet by clicking on the triangle in the upper left corner of your worksheet. Hold Ctrl + C to copy the sheet to your clipboard. Select cell A1 in the new sheet you created to analyze your pivot table data. Right click and select the Values (V) icon under Paste Options. Format the new sheet. Code: Dim PRange As Range. Step 4: To insert a Pivot Table, we need a separate sheet to add worksheets for the Pivot Table to declare the variable as a “Worksheet.”. Code: Dim PSheet As Worksheet. Step 5: Similarly, to reference the worksheet data, declare one more variable as “Worksheet.”. Code: You create the pivot table by defining which fields to view and how the information should display. Then, based on your field selections, Excel organizes the data to see a different view of your data. For example, I’ve uploaded a data file with information on 4000 fictitious voters that include the following data fields: Voter ID. zSg72D4.