Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Media » Non Excel Files » Videos » Working with Pivot Tables (Part 1)

Working with Pivot Tables (Part 1)

Browse Media

Tags

View more

Previous | Next | View all files | View Slideshow
posted by Nick Hodge
Fri, Feb 15 2008
Downloads: 150
File size: 20.8MB
Views: 542
Working with Pivot Tables (Part 1)

This is the first of a series of pivot table videos, showing how to build and manipulate them using external data. Specifically an Access Database.

It is also a trial for me to see how it works and how popular they are. In this first one, I apologise for the typewriter-like keyboard presses. I have a laptop with internal microphone.

Hope you enjoy this and I'll try and get around to a few more, on this subject and others.

Comments

Alex J wrote re: Working with Pivot Tables (Part 1)
on Sun, Feb 17 2008 7:04 PM
Nick, This is a really excellent tutorial. Clear, well delivered, straightforward. Well done! A couple comments: Although I have lots of excel, vba, and pivot table experien, I had not tried the link to Access yet. So it was really instructive. Also my first real exposue to 2007 - I like the new pivot features, at least. (In 2003 and earlier I have used the group/outline features on pivot tables to get the collapse/expand effect) My current questions are more along the lines of data updating, such as: does refreshing the pivot source cause the query to execute on new data in the access tables,?, how to easily re-direct the same link to a different access file, or a different query in the same file?, etc. I hope these topics will be covered in future installments.
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.