0:00
hi everyone my name is Barbara welcome
0:02
back to my YouTube channel and welcome
0:03
if it's your first time here I make Exel
0:05
video so let's get started with today's
0:07
and we're going to look at slices so if
0:10
you've heard of slices it's probably
0:11
because you've used them with pivot
0:13
tables but actually they're really
0:15
useful for Excel data tables as well so
0:21
using filtering like this what you can
0:24
actually do is you can use
0:27
slices so the first thing you have to do
0:29
is select your data and we want to
0:31
convert this into a data table to get
0:33
that functionality so what you can do is
0:37
T and then you can create a table
0:40
confirm your table has headers and this
0:42
will take the first line of your data as
0:45
headers if you didn't want to use the
0:47
shortcut contrl T you can actually put
0:49
your cursor inside the data and then
0:51
insert table and it takes you to the
0:54
same popup menu so now we have an Excel
0:57
data table so we can still use the
1:00
traditional the traditional
1:02
filtering but what we can do now is go
1:07
slicer it looks just like you get for a
1:09
pivot table and we can now have a slicer
1:13
manufacturer the model and the
1:16
fuel and just like in an Excel pivot
1:20
table you can now use slices the only
1:24
thing you have to remember is you have
1:25
to convert your data into a table to get
1:28
that functionality so hope you enjoyed
1:30
the video if it if you did give it a
1:32
thumbs up and I'll see you next time for
