Often when I look at an Excel file, it just has way too much information. Rows upon rows of data. How do I make heads or tails of it? Lately, I have been using tables and slicers to assist in the sorting and filtering of my data. The great thing about tables and slicers is that I can quickly get down to the granularity level that I need. I also don't need to create as many tabs as I can filter the data. Please follow the steps below to create your first table and slicer.
As always, reach out if you have any questions.
Setup a table
Filter and sort within the table
Use the arrows in the headers to sort and filter the table data.
Setup a slicer