by Nate Moore | Sep 12, 2012 | Pivot Tables
The search box gives you filter even more power when you know the trick I’ll share in Excel Video 292. It’s hard to do OR filters in Pivot Tables. It’s easy to get all of the patients from Dr. Rook AND in the North location, but it’s hard to get all of the patients...
by Nate Moore | Sep 10, 2012 | Pivot Tables
There’s one more filter for Pivot Tables I’d like to show you in Excel Video 291. The filter’s a search box, and it’s new in Excel 2010. It’s easy to type what you’re looking for in the search box and Excel will look through the labels in the row (columns work too)...
by Nate Moore | Sep 5, 2012 | Pivot Tables
Watch Excel Video 290 today to see several more clever tricks with Slicers. We’ll spend most of this video in the Slicer Tools menu working through a variety of Slicer options to get the Slicers to look just the way you want. I’ve seen some dashboards constructed with...
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...
