Select Page

Excel Video 296 Grouping Text Part 2

If you liked the ability to group text in the last Excel Video, you’ll like the additional grouping options we’ll discuss today in Excel Video 296. The first trick we’ll discuss is how to group groups. You can create levels of grouping to get exactly the analysis...

Excel Video 295 Grouping Text Part 1

Now that you’re familiar with grouping dates, watch Excel Video 295 to see how to group text in a Pivot Table. When we grouped dates in Excel Video 294, we grouped by month and year so Excel knew the names of the months and called the new field “Years” for us. When we...

Excel Video 294 Grouping Dates

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

Excel Video 293 Drill Down to Detail

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

Excel Video 292 Search Box Filter, Part 2

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