UK Excel Developer Conference London January 2012


08:30 – 08:45
Tea, coffee, small talk and any nice biscuits anyone brings
08:45 – 09:15
The Excel Window
Excel is the window to most corporate data, and most corporate logic.
This session looks at trade offs you make by placing different elements at the various layers.

Simon Murphy
09:15 – 09:45
Keeping track of development with working papers.
Branched arguments and conclusions from an Excel Workbook – a
management concept in VBA

Stephen Allen
09:45 – 10:00
Questions and answers & Tea and Coffee
10:00 – 11:15
Will Self-Service BI Happen?
– Excel as the BI presentation layer
– PowerPivot as an end-user tool
– Bringing it all together.

Bob Phillips
11:15 – 12:15
VBA to ExcelDNA The trials and tribulations of migrating from VBA to and ExcelDNA.
– Writing VBA UDFs that convert to C# and C++
– Using ExcelDNA to create XLLs
– Running VB.NET without Visual Studio

Mike Staunton
12:15 – 13:30
Dinner/Lunch PUB
13:30 – 13:50
Managing the development process
Excel Development is RAD.
What does that mean?
how does it impact project management and planning?
The good and bad of RAD
And how to maximise one and minimise the other

Simon Murphy
13:50 – 15:05
The .NET hammer: VSTO for Excel
Compared to other Excel automation approaches, VSTO (Visual Studio Tools
for Office) is heavyweight. We’ll illustrate some of its benefits (full
access to all the power of .NET, modern IDE and development languages, team
development, testable code, automated deployment), and discuss when using
VSTO is and isn’t a good idea.

Mathias Brandewinder
15:05 – 15:30
Break Questions and answers over Tea and Coffee
15:30 – 16:30
VBA to C : Pratfalls and Perils
– Stories based on a c++ newby’s efforts to convert 10K lines of VBA UDFs to
C++ XLLs.
– Demonstrations and examples using Visual Studio 2010 and Planatech XLL+

Charles Williams
16:30 – 17:30
The FAST spreadsheet modelling standard
An industry proven, easily accessible, collaboratively developed, set of guidelines and recommendations to facilitate building robust spreadsheet models efficiently.

Morten Siersted
17:30 – 18:00
Questions and answers and general lurking and conf close
18:00 – late
    Drinking and arguing    

18 Responses to “UK Excel Developer Conference London January 2012”

  1. Excel Developer conference update « Smurf on Spreadsheets Says:

    […] I have published the latest draft agenda here. […]

  2. Jon Says:

    I’m still interested in seeing the video for this. Hope you remember to push record and put it on the net!

  3. SpreadsheetConverter (@excel2web) Says:

    When I look at the presentation list, there is a lot of programming. Do you think it would be interesting to look at a simpler approach, more targeted to non-programmers?

    We develop SpreadsheetConverter, see

    We are based in Sweden, so UK is not that far away.

    • Bob Phillips Says:

      There are lots of conferences/seminar/training sessions of that ilk, but few targetted at Excel/VBA developers. That is why this exists, trying to fill that gap.

    • Bob Phillips Says:

      I see a BA flight from Stockholm Arlanda Apt to London City (which is very convenient) on 24th return 26th fro £126, so maybe we will see you there.

  4. Basavaraj K H Says:

    I am Basavaraj K H, Interested in learning Excel, VBA Macro
    Plz send articles for Excel.

    Thanks & Regards
    Basavaraj K H

  5. Simon Says:

    Jon, the venue might have working AV. so you wont need to rely on me.

    Excel2Web, this is a dev conf hence the development focus, I am planning a more user oriented one in July.
    Although if your snow is better than ours this year, I might be visiting you for a demo…

  6. Excel Developer Conference in London, Jan 2012 Says:

    […] took shape. As of now, the planned date is in the January 24 to 26 range, with a pretty cool agenda, covering most of the recent developments Excel developers should know about. I am looking forward […]

  7. Erikafromamerica Says:

    Wish I could travel to UK, but funding is unavailable. Have fun without me.
    Come to Dallas next year 🙂

  8. Daily Dose of Excel » Blog Archive » UK Excel User Conference Says:

    […] If you’re in or around London in late January, don’t miss the UK Excel User Conference. It’s Wednesday, January 25th at Skills Matter Here’s the agenda. […]

  9. UK Excel Developer Conference: London January25 « Excel and UDF Performance Stuff Says:

    […] agenda is here (subject to change of course), and you can sign up here. (its an absolute bargain at […]

  10. Optimus29 Says:

    Hello Sir,

    I am from India and highly interested in this conference. Of course I would not be able to attend it. Will be sharing a video or any document which will summarize all the discussions of this conference
    It would be helpful for people like me in sharpening the Excel skills

    Thanks in Advance!

  11. Simon Says:

    Yes there is a loose plan to video the event, not sure yet how that will be made available.
    I guess some of the presenters may make their slides and demos available too.
    Keep checking back as we sort ourselves out…

  12. Create an Excel chart in C# without worksheet data Says:

    […] data by Mathias 14. January 2012 14:16 I am putting together a demo VSTO add-in for my talk at the Excel Developer Conference. I wanted to play with charts a bit, and given that I am working off a .NET model, I figured it […]

  13. Excel Developers’ Conference Jan 25 London report | Patrick O'Beirne @ sysmod Says:

    […] […]

  14. VSTO: code traceability with Source Control Says:

    […] part of a series providing commentary on the VSTO Stocks project. I initially developed it for the Excel Developers Conference in London, to illustrate some of the benefits or interesting features of VSTO add-ins compared to […]

  15. VSTO: solution organization Says:

    […] part of a series providing commentary on the VSTO Stocks project. I initially developed it for theExcel Developers Conference in London, to illustrate some of the benefits or interesting features of VSTO add-ins compared to […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: