by Nate Moore | Sep 19, 2012 | Pivot Tables
Grouping is another powerful way to analyze data in Pivot Tables and it’s the topic of Excel Video 294. We’ll start our discussion of grouping data by using a date. Notice how when I click on a date in a Pivot Table Excel recognizes that it’s a date and gives me...
by Nate Moore | Sep 17, 2012 | Pivot Tables
If Excel Video 293 doesn’t cover the best feature in a Pivot Table, it’s certainly in the top three. Pivot Tables are great for data analysis, but if you’re like me, you’ve had the experience of taking a report to a physician or an administrator and having them say,...
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...
