00:00So over here, you can see that I got a range of data right here. And let's say what I want to do
00:10is to filter them out easily, I want to go ahead and insert out slices. So to do that, first of
00:16all, I need to go ahead and select out all of these contents right here, and then turn it into
00:22a table first. So as I select out all of these, I can go around onto the insert tab, and then I can
00:29go ahead and click on table. So once you do that, I can press OK, and then it gets converted into a
00:35table right here. So now what you can simply do is as you select the table, you can click on insert
00:41slicer. So over here, you can go ahead and filter it out. Let's say for example, I'm going to go ahead
00:46and add in reason over here, and I'm going to add in category right here and press OK. Then what you
00:53simply have is you get the slices for those two categories, as you can see, and you can go ahead
00:58and resize this out so that you can see both of the category right here, just like this. So if I
01:04were to click on accessories, then you can immediately see that it simply goes ahead and then filters it
01:12out as per accessories. Click on electronics, and this is what you have right here. Similarly, you can
01:18also go around over here and filter it out by reason. You can hold, let's say for example, control
01:24on your keyboard right here to select out both of the categories as well right here. So let's say for
01:30example, if I were to hold control and select all of these categories right here, then you can see
01:34that only selected categories show up. You can go around over here just like this, and if you were to
01:40click, it filters out accordingly. Hold control, and this is what you have as you can see. So this is how
01:47you can simply go ahead and filter out data with slices that you have in Microsoft Excel. So if you
01:54found this video useful, be sure to hit the like button. Don't forget to share this out with your
01:59friends and family. And for more contents like these, do follow simple tutorials.
