Goodwill Community Foundation creating
opportunities for a better life
in part one we talked about the basics
of creating a pivot table in this video
we're going to take a look at three more
features called report filters slicers
and pivotcharts right now this pivot
table is showing us the regional sales
totals for all the salespeople in our
worksheet however I'd like to try
removing certain people so we can see
how their sales are impacting their
regions we can do this by adding a
report filter which can be used to
narrow down the data in your pivot table
first drag the salesperson field to the
filters area then look to your pivot
table and click the filter that's been
added to the upper right corner next
check the option that says select
multiple items now we can check or
uncheck the salespeople above depending
on who we want to include I'm going to
remove Michael Brennan Richard doom Lao
and Shannon Thompson when you're ready
click OK and the filter will be applied
in this case that means the totals have
changed and two of the regions have also
been filtered out based on the people
that we unchecked if you like the way
filters work you might want to try
adding a slicer next slicers make
filtering even faster and easier by
giving you access to the filters in
their own separate pane first make sure
you're on the analyse tab then click the
insert slicer command
a dialog box will appear where you can
check the filter you want we'll use
salesperson like before now we can just
click the salespeople we want to see
without having to go to the filtering
menu you can even select multiple
adjacent people by clicking and dragging
your mouse to select more than one non
adjacent item hold ctrl on your keyboard
while you click as you can see the pivot
table changes each time to reflect the
data you've selected the last thing I'd
like to show you is a neat feature
called pivot charts pivot charts are
basically the same as regular charts
except they show whatever is in your
pivot table to get started click any
cell in your pivot table then go to the
insert tab and click the pivot chart
command a dialog box will appear where
you can select the chart type you want
then go ahead and click OK now any
changes you make to the pivottable will
show up in the pivot chart as well for
example let's see what happens when we
move these fields around a bit so we can
view each person's monthly sales data
with a pivot table a pivot chart and a
slicer we can look at the data in so
many different ways all without changing
or deleting any of the original content
it's a great way to find whatever
information you're looking for or you
can just experiment to see if you
discover something new