I’ve just posted a more in-depth outline of the Excel Pivot table session I’ll be presenting at the conference. Its here (on the dedicated conference blog).
I’ve got a half built VBA utility that makes it easy to build pivot table data sources from workbooks structures that would normally not pivot well. I’m planning on polishing that up (that would be ‘polish’ to my ‘agricultural’ level rather than Marcus’s work of art level) as a give away, and demoing it as part of getting data into a usable format.
Of course I’m delighted to be the opening speaker – I don’t normally wake up properly until 11, I guess this is what coffee was invented for.
Let me know if you think I’ve missed anything critical out of my session outline.
cheers
simon
Wednesday, 7th November, 2007 at 2:14 pm |
Aww Shucks Simon, you’re making me blush (but Picasso I ain’t).
Cheers – Marcus
Wednesday, 7th November, 2007 at 4:05 pm |
Debra Dagleish has a nice basic section about VBA & P/T that may be of interest including some tools for it as well:
http://www.contextures.com/tiptech.html
In addition, I believe it’s good to introduce the PivotCache to the targeting audience. This is the key to all kind of automation through VBA.
Kind regards,
Dennis
Wednesday, 7th November, 2007 at 9:38 pm |
Thanks Dennis