by Nate Moore | Oct 3, 2012 | Pivot Tables
In Excel Video 298 we’re ready to start talking about calculations in a Pivot Table. Today we’re primarily working with the Values area in the Pivot Table. You can drag multiple fields to the Values area and you can even drag the same field to the Values more than...
by Nate Moore | Oct 1, 2012 | Pivot Tables
When you see how easy it is to expand and contract groups in Excel Video 297, you’ll wish it was this easy to contract your waistline! Today we’ll go through three ways to make your grouped items expand (show detailed data) or contract (show summary data). You can...
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,...
