by Nate Moore | Oct 15, 2012 | Pivot Tables
Excel Video 301 is very similar to Excel Video 300, using parent columns instead of rows. It can be a little confusing to understand how Excel is doing these parent calculations, so I did one more video calculating the percentage of the parent column total instead of...
by Nate Moore | Oct 10, 2012 | Pivot Tables
As we hit the milestone of Excel Video 300, I’ll pause for a minute to say thanks for watching. I realize quite a few of you have watched all 300 videos. Thanks for watching and for spreading the word about these Excel Videos. The percentages we discussed last time...
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...
