Excel Pivot Table Tutorial Mac

Use slicers to filter data.

Excel pivot table tutorial mac. A pivot table is a summary of a large dataset that usually includes the total figures average minimum maximum etc. Your data should be organized in a tabular format and not have any blank rows or columns. In this tutorial well show you the ropes. Lets say you have a sales data for different regions with a pivot table you can summarize the data by region and find the average sales per region the maximum and minimum sale per region etc.

Tables are a great pivottable data source because rows added to a table are automatically included in the pivottable when you refresh the data and any new columns will be included in the pivottable fields list. In this example weve selected cell a1 on sheet2. Next select the data tab from the toolbar at the top of the screen. Believe it or not were already to the point in the process when you can insert a pivot table into your workbook.

Excel automatically selects the data for you. To insert a pivot table execute the following steps. The default location for a new pivot table is new worksheet. Click on the pivottable button and select create manual pivottable.

To do so highlight your entire data set including the column headers click insert on the ribbon and then click the pivot table button. Or maybe you tried using one and had difficulty. Then youll get an idea of the basic parts of a pivottable. If youre pivottable aficionado you will be in seventh heaven with the new pivottable capabilities in office 2011 for mac.

In this example the data for the pivot table resides on sheet1. Before you get started. Create a pivottable timeline to filter dates. How do i create a pivot table in microsoft excel 2011 for mac.

You might have heard the word pivottable before and wondered what it was. Ideally you can use an excel table like in our example above. Highlight the cell where youd like to see the pivot table. Pivot tables allow us to.

In excel 2011 for mac a pivottable is a special kind of table that summarizes data from a table data range or database external to the workbook. Use the field list to arrange fields in a pivottable. On the insert tab in the tables group click pivottable. Click any single cell inside the data set.

Choose where to place your pivot table. Insert a pivot table. The following dialog box appears.