Pivot Tables Power

Pivot Tables Fundamentals – How a PT achieves faster data analysis and presentation?
3 of 14
Pivot Tables definition – Learn what a Pivot Table is
4 of 14
How to create a Pivot Table report step by step
5 of 14
Pivot Tables interface explained in less than 12 min
6 of 14
Understanding Data relationships – How to improve your relationship with Data (PART 1)
7 of 14
Understanding Data relationships – How to improve your relationship with Data (PART 2)
8 of 14
Example – Office supplies
9 of 14
Example – World population
10 of 14
Example – Adventures stores
11 of 14
Pivotable tables – What tables can and can’t be used to generate Pivot Tables
12 of 14
Data sourcing fundamentals – How to control the source of your Pivot Tables
13 of 14
The 2 types of Pivot Table fields – How to find and use them
14 of 14
The 7 new Pivot Tables perspectives – How to think like PTs and take advantage of them

1 – Assign a result-oriented macro name


Start simple, without typing any bit of VBA code yet. Just name your macro the right way

Lesson learning duration: 14 min | Implementation time: 5 min

Comments on this entry are closed.