
Excel 2010 Pivot Table Formulas Playlist
Excel Video 298 Calculations in a Pivot Table
In Excel Video 298 we’re ready to start talking about calculations in a Pivot Table. Today we’re...
Excel Video 299 Percentages of the Total
Excel Video 299 introduces a powerful way to look at trends over time by using percentages in your Pivot...
Excel Video 300 Percentages of the Parent Row Total
As we hit the milestone of Excel Video 300, I’ll pause for a minute to say thanks for watching. I realize...
Excel Video 301 Percentages of the Parent Column Total
Excel Video 301 is very similar to Excel Video 300, using parent columns instead of rows. It can be a little...
Excel Video 302 “Show Values As” Shortcuts
Excel Video 302 has two shortcuts to make the percentage calculations we’ve been discussing easier to...
Excel Video 303 Percentage of a Baseline
Excel Video 303 introduces another way to calculate percentages in a Pivot Table. Today we’ll select a...
Excel Video 304 Difference From a Baseline
Would you like to show the actual distance from a baseline instead of a percentage distance in your Pivot...
Excel Video 305 Percentage Difference from a Baseline
Excel Video 305 shows you another way to look at percentage differences in a Pivot Table. If you watched...
Excel Video 306 Running Totals
If you’d like to add running totals to a Pivot Table, watch Excel Video 306. It’s easy to add running...
Excel Video 307 Ranking in Pivot Tables
If you’d like to see how components of your Pivot Table change over time, try ranking the values in Excel...
Excel Video 308 Show Values as an Index in Pivot Tables
Excel Video 308 gives us one more way to show values in a Pivot Table. Truth be told, we didn’t...
Excel Video 309 Basic Formulas with Pivot Table Data
Excel Video 309 transitions to a different way to do calculations with Pivot Table data. We’ll start with...
Excel Video 310 GETPIVOTDATA Part 1
Excel Video 310 is the first step in our effort to demystify GETPIVOTDATA. As you’ll remember from our...
Excel Video 311 GETPIVOTDATA Part 2
Now that we’re a little more familiar with GETPIVOTDATA, let’s see what else it can do for us in Excel...
Excel Video 312 GETPIVOTDATA Part 3
Excel Video 312 covers a few more things to know about GETPIVOTDATA. We’ll start where we left off in...
Excel Video 313 Calculated Fields in Pivot Tables Part 1
Excel Video 313 introduces a third way to make calculations with Pivot Table data. Calculated fields take a...