Excel conference

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

Advertisements

3 Responses to “Excel conference”

  1. Marcus Says:

    Aww Shucks Simon, you’re making me blush (but Picasso I ain’t).

    Cheers – Marcus

  2. Dennis Wallentin Says:

    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

  3. Simon Says:

    Thanks Dennis

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: