Lesson 14 demonstrates another, simpler way to create formulas based on Pivot Table data. When you want relative formulas that change cell references as the formulas are copied, instead of GETPIVOTDATA, try typing the cell references directly into the formula. This method is a lot easier when you have a lot of formulas based on Pivot Table data.
I hope you’re enjoying these videos. Please feel free to comment with suggestions for future Excel video subjects, not just limited to Pivot Tables.