Excel Ninja skills – September 2009

The Content

• 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: Adintelligence
• Bonus tips: Google docs

View all recordings.