From the course: Excel 2010 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Modifying a PivotTable - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
Modifying a PivotTable
In this workbook we have a simple PivotTable on Sheet 1 and if you want you can take a peek here down in the Data tab, so you can see the underlying data there, but let's go back here to Sheet 1. First thing we want to do in editing the PivotTable is let's change this sheet name to something useful. Instead of Sheet 1 you can double-click it. Maybe call it PivotTable or call it Summary. Something a little bit more useful and understandable. Now let's go and do some filtering, and you see up here we have these little down arrows for our column and row labels and report filters. Let's start by filtering the months. Click this down arrow and right now you can see we have all three months showing, but maybe we just want to see January. Perhaps this is the beginning of the year and we want to see how sales are going just for this month, or perhaps data are not complete for the other months. Click OK and now you can see were filtered just by January. Maybe we want to see two months. So…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.