Select the range of data for the pivot table and click on the OK button. Click on the PivotTable button and select Create Manual PivotTable from the popup menu.Ī Create PivotTable window should appear. Next, select the Data tab from the toolbar at the top of the screen. In this example, we've selected cell A1 on Sheet2. Highlight the cell where you'd like to see the pivot table. Select “Descriptive Statistics” from the window below.Question: How do I create a pivot table in Microsoft Excel 2011 for Mac?Īnswer: In this example, the data for the pivot table resides on Sheet1. Click on the Data tab and then the “Data Analysis” option on the right side. To generate the output for BMI as shown above, go to the worksheet with the data. Once the Data ToolPak is installed, there will be a “Data Analysis” option on the right side of the sub-menu from the Data tab on the main menu.
Click the Tools menu, and then click Excel Add-ins.(Note: The Analysis ToolPak is not available for Excel for Mac 2011. If you are prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.
In the Add-Ins box, check the Analysis ToolPak check box, and then click OK.In the Manage box, select Excel Add-ins and then click Go.Click the File tab, click Options, and then click the Add-Ins category.Installing the Data Analysis ToolPak into Excel For PC: The ToolPak is available, but needs to be installed before it can be used.
0 kommentar(er)
