by Nate Moore | Sep 3, 2012 | Pivot Tables
You might need an extra batch of popcorn for Excel Video 289. I’m discussing Slicers, a clever new feature in Excel 2010 to manually filter Pivot Table data. Slicers are a great visual way to easily filter data. You’ll see how it’s much easier to see which data is...
by Nate Moore | Aug 29, 2012 | Pivot Tables
It’s not Letterman, but Excel Video 288 has way to get Top 10 Lists in Pivot Tables. Just because it’s called Top 10 doesn’t mean you’re limited to top or 10. You can easily select the bottom 5 instead of the top 10. You can also choose whether you want items,...
by Nate Moore | Aug 27, 2012 | Pivot Tables
Excel Video 287 showcases a third way to filter your Pivot Table data, Value Filters. Where Label Filters focused on what was in the row or column label, Value Filters look at the data in the Values area of the Pivot Table. It’s easy to filter for values that are...
by Nate Moore | Aug 22, 2012 | Pivot Tables
Watch Excel Video 286 to see how Excel customizes your filter options based on the type of data in your rows and columns. When we looked at label filters in the last Excel Video, we had a text field in the Row Label field we were filtering, so Excel gave us text based...
by Nate Moore | Aug 20, 2012 | Pivot Tables
Excel Video 285 adds some real power to your filtering skills by introducing Label Filters. Label Filters allow you to filter by whatever is in the Row or Column Label. In our example today, we’ll filter text data. It’s easy to select labels that begin with, don’t...