by Nate Moore | Nov 12, 2012 | Pivot Tables
Excel Video 309 transitions to a different way to do calculations with Pivot Table data. We’ll start with a little housekeeping to get the data the way we’d like it, and then the first thing I want to show you is that you can put multiple fields in the Values area of...
by Nate Moore | Nov 7, 2012 | Pivot Tables
Excel Video 308 gives us one more way to show values in a Pivot Table. Truth be told, we didn’t necessarily save the best for last, but we did save the most complicated calculation for last. Microsoft uses the index calculation we’ll discuss today to describe the...
by Nate Moore | Nov 5, 2012 | Pivot Tables
If you’d like to see how components of your Pivot Table change over time, try ranking the values in Excel Video 307. Excel will let you rank from lowest to highest or from highest to lowest based on whatever baseline value you choose in your Pivot Table. You’ll see in...
