Advanced Pivot Tables - Video Training Pack  This package includes both Excel 2007 and 2003 versions  If you are already comfortable with the basics of Pivot Tables, or have completed our Introduction to Pivot Tables course, then this course will help you to master some of the more advanced aspects of this incredibly powerful Excel tool.  You will learn:  How to use lookup formulae to combine data from multiple sources for your pivot table; How to use calculated fields and items; How to manipulate the layout of a pivot table; How to use Pivot Charts; How to extract information from pivot tables to populate complex reports, including a method of reducing management accounts production from trial balance to two clicks of the mouse; Invaluable insights into real world applications from an experienced consultant.  The pack includes:  5 step-by-step videos taking you through the above; A 24-page illustrated manual to accompany the videos; Spreadsheets of data to allow you to try the examples yourself; A 20-minute video interview with myself (Glen Feechan) discussing the real-world application of what you have learned. This complete package is available for immediate download at just £27.50 (or $39.50) (incl. VAT where appropriate), just click the button below (This package includes two versions of the course - for Excel 2003 and 2007):  Download for £27.50: Download for $39.50: Purchasing this course entitles you to use it for your own personal use and to share it with colleagues within your company.  If you are not sure if this course meets your requirements, please get in touch on +44 (0)845 6439693 or via njn@feechan.co.uk to discuss.  If you want to learn more about Excel, why not sign up to the  Not Just Numbers  blog.