We break the process down into several easy-to-follow steps. First, you’ll learn how to create a date table that keeps track of the dates for the periods you’d like to see in your calendar. Next comes making the PivotTable, then formatting it, and then you’re on your way to creating a responsive graphical calendar! Create a "Multiple Consolidation Ranges PivotTable." (Only on Pivot Table Wizard. Callup with ALT + D, P on Excel 2007) Select "I will create my own page fields". Select your data. Double click on the grand total value - the one at the intersection of Row Grand and Column Grand, all the way on the lower right hand corner of your pivot table 1. Click any single cell inside the data set. 2. On the Insert tab, in the Tables group, click Table (or simply press Ctrl + T). The Create Table dialog box appears. 3. Excel automatically selects the data for you. Check 'My table has headers' and click on OK. Select Table/Range Option. To begin, select any cell of the dataset. Then open the Insert Tab >> select PivotTable >> click on From Table/Range. PivotTable from table or range dialog box will open up. The Table/Range will be automatically set as you clicked the cell of the dataset previously. If the pivot_table argument is a range that includes two or more PivotTables, data will be retrieved from whichever PivotTable was created most recently. If the field and item arguments describe a single cell, then the value of that cell is returned regardless of whether it is a string, number, error, or blank cell. tables that allow you to manage and summarize substantial amounts of data, in a concise format for easy reporting and analysis. Therefore, this manual is an introduction to Excel Pivot Tables 2016. These instructions illustrate how you can summarize and manipulate your worksheet data by using Pivot Tables, Filters, Slicers, and Pivot Charts Just highlight the items you want in your group, e.g., Salary, Contract and Interest. Then right-click and select Group, or select it from the menu or Ribbon. You can then choose to show the detail (your original groupings) or not. Note that you can change the default name that is assigned from the new grouping from "Group1" to whatever you choose. Step 1: First of all, we must need to select any particular cell in the given table (data set) within our worksheet. After that, we are required to go to the Insert tab and then will click on the 'PivotTable' button. This will launch the 'Create PivotTable' window where our data range (table) will already be written. F1J1.