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...

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,...

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...

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)...

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...

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...

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,...

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...

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...

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...

Excel Video 284 shares an easy way to filter your Pivot Table data. There are several ways to filter, or limit the amount of data in your Pivot Table. Today we’ll discuss the easiest way to filter, simply by checking boxes. I call this way of filtering a manual filter...

When sorting A-Z or Z-A isn’t good enough, watch Excel Video 283. Today we’ll discuss how manually sort data. When you need data in a different order then ascending or descending, just turn on manual sort and you can drag items in your list to rearrange them just the...

Sorting Pivot Table data, as we’ll do in Excel Video 282, is much easier than sorting regular data in Excel. You’re probably aware that if you sort regular data in Excel you have to be very careful to select the entire range of data to sort in order to avoid...

If you’ve wondered why Microsoft calls it a Pivot Table, watch Excel Video 281 today to see how easy it is to pivot rows and columns around a value. It’s easy to add and remove data from a Pivot Table. It’s just as easy to move data between rows and columns. Notice...

I’ve decided to go back and cover Pivot Tables again, starting in Excel Video 280. Since I recorded the first Excel Video almost 3 years ago, I’ve made almost 25 presentations across the country on using Pivot Tables in a medical practice. I know a little more about...