Cut Yourself Out a Slice of Data

As you probably know, Microsoft Excel can do much more than most people ever use it for but that doesn’t mean you shouldn't try and learn something new because it might come in handy! Then the more you know, the more you will be able to do with Excel in the future.

Since an Excel workbook is capable of holding a lot of data it's nice to be able to filter that data when needed to make things easier to find and also easier to see. Sure you can use the filtering options on the Data tab but Excel has another way to filter your data that is much cooler and it's called Slicers.

What Slicers does is take the data you want to view and slice it right out of the sheet so you only see what you want to see. Then you can fine tune these slices to filter things at an even more granular level making it very easy to see only the information you are interested in. Plus once you have your slices setup it's easy to edit them to change what information you will see in your filtered results.

To use Slicers go to the Filter section on the Insert tab and then go to Filters group. There you will see the Slicers button that you can use to slice out values that you want to filter on. As you can see below we have a spreadsheet with a lot of columns and rows and a ton of information. We need to filter this data so we can see the information we care about at the moment.

Excel Slicer

 

In our case we want to only see information about any number of units sold of the Paseo product in France. To do this simply click on the Slicers button and choose the categories from the list that you want displayed. So here we check the boxes for Country, Product and Units Sold since that’s the data we are looking for.

Excel Slicer

 

Once we click OK we are presented with a box for each of the "slices"  we chose and it shows all of the possible values we have from those columns.

Excel Slicer

 

Next we will filter on any value for units sold but for the product called Paseo that have been sold in France by highlighting only what we want to show by clicking on the ones we don't want to show so they are white. This will filter the sheet to only show these values under Country, Product and Units Sold that were selected.

Excel Slicer

 

As you can see in our results the sheet is filtered by any unit amount sold of the product called Paseo that was sold in France. We have cut off part of the sheet to make things easier to see and all of the columns will still be displayed but only the data we filtered on will be shown.

Excel Slicer

 

Once you create your Slices you can click on or off whichever values you choose to filter your data. It's a really efficient way to see only the data you want and at the same time have the ability to change your filters around as you need to. Using Slicers does not affect or remove any of your data so when it disappears don’t worry about it because it’s all still there. You can click on values to toggle them on and off and the results will update instantly. If you want to clear the filter for a particular slice then just click on the Clear Filter button on the top right. To remove a category all you need to do is right click on the slice you want gone and choose Remove "slice name" and it will disappear. Just be sure to clear the filter before doing so otherwise the data will remain filtered.

Pin It

Join Us On FaceBook

We Recommend:



Join Us On Twitter

Get insights into the computer industry and regular updates on our site. Click Here

OCT Youtube Channel

New tech tip videos posted on a regular basis. Subscribe today! Click Here

Sponsored

LATEST VIDEOS

Make your computer's name display correctly ever...

Dont limit yourself to booting from ISO files! ...

Use your computer as your phone!   When...

Overcome the VirtualBox 2TB Virutal Disk Limit! ...

Instantly give your VMs more hard drive space! ...

Freely copy files between your VirtualBox host a...

RECENT TIPS

Make your computer's name display correctly ever...

Give the gift of security this season!   ...

Dont limit yourself to booting from ISO files! ...

Is using a proxy the right choice for you? &nbs...

Make learning a little bit easier with the...

Being proactive is the first step to being spywa...

NEWS

Another reason to keep your devices up to date. If you ...

Try not to get the BlueKeep Blues Once again the Micros...

Are Your Chrome Credentials Secure? Many people like to...

Windows 10 Optional Updates Coming Soon If you can reme...

Is a Virtual Private Network right for you? &nb...

Use Some Cache to Speed Up Chrome If you use the popula...