#Microsoft office pivot table tutorial how to#

In this example, we have Department first and Location second in the Rows box which is how theyвЂ™re grouped in the table.Д«ut by moving Location above Department, we see each of our locations as the main fields instead, which is what we want. If you have more than one field in a box, the order determines the placement in the pivot table as well. Alternatively, you can use the drop-down arrows next to the fields to move them. You simply drag that field from the Rows box to the Columns box and your table will update accordingly.

#Microsoft office pivot table tutorial how to#

RELATED: How to Change Date Formats in Microsoft ExcelДЄs an example, we want to see our Months as columns instead of rows. These are the defaults for those types of data, but you can move them where you want them. This is where you will decide how you want to place them in your table.Дepending on the type of data in your sheet, youвЂ™ll see things like numbers in the Values box, dates and times in the Columns box, and textual data in the Rows box. Note: You can check and uncheck boxes for the fields you want to use at any time.Д®xcel then drops those fields into the boxes at the bottom of the sidebar where it believes they belong. Using the PivotTable Fields sidebar, start by choosing the fields at the top you want to include by checking the boxes.

YouвЂ™ll then see the pivot table and the PivotTable Fields sidebar, ready for you to build your table or edit the recommended table you inserted. For analyzing multiple tables, you can check the box to add it to the Data Model. Then, decide if you want the table in a new worksheet or your existing one. At the top, confirm the data set in the Table/Range box.

YouвЂ™ll see a window appear for PivotTable From Table or Range.