by Nate Moore | Sep 26, 2012 | Pivot Tables
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...
by Nate Moore | Sep 24, 2012 | Pivot Tables
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...
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...
