- How to use a pivot table (plus a few gotchas)
- What to watch out for when working with Excel and pivot tables
- Quick tips on how to use index and match
- How to use them in conjunction with pivot tables
- Array formulae – how they work and how you can break them
- Handy plug-ins including:
- Bonus tips: Google docs
View all recordings.