From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Manipulating PivotTable data

Manipulating PivotTable data - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Manipulating PivotTable data

“

One of the best features of a Pivot Table is the ease with which you can manipulate the fields. We're looking at a worksheet called Manipulating, it's in the Workbook 13-PivotTables and we're looking at a Pivot Table that was created earlier and we're thinking of changing the layout of the fields as we see them here. The Pivot Table fields list is off to the right. Sometimes this is anchored, you can click and drag its title and place it above the data if you wish or closer to the data and also make it larger this way. Again, as we look at the Pivot Table field list Product, Items, Salesperson, that's the layout we see to the left. Imagine if you're making a presentation and the discussion about what we're seeing here has pretty much run it's course and the question that has come up, could we see this breakout by customer, possibly customer and region or customer and salesperson. So sometimes we want to make a change. What if I like to see Product down the left-hand side? I'm not…

Contents