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.