Excel PivotTablesLesson 64Free preview

Excel Create PivotTable

This lesson is part of Excel · All levels

Summary

Creating a PivotTable starts by selecting the source data, then Insert > PivotTable, then determining the result location: new sheet or existing sheet. After that, it's just dragging the field from the Field list to the Rows, Columns, Values, and Filters area. The report structure can be changed at any time without rearranging the original data.

Key points

Insert > PivotTable after selecting the source range
Select New Worksheet for separate reports or Existing Worksheet for in-place
Drag the field to Rows, Columns, Values, and Filters
The layout can be changed at any time without changing the original data.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.