by Nate Moore | Oct 8, 2012 | Pivot Tables
Excel Video 299 introduces a powerful way to look at trends over time by using percentages in your Pivot Table. Instead of putting numbers in the values area of the Pivot Table, today we’ll replace the numbers with percentages to see how the mix of clinic locations...
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...
