This event is being organised by Simon and the presenters as a community event. There is no profit motive, if we can refund the presenters their travel and accommodation costs that will be excellent.

Agenda:

Time	Topic	Presenter

08:30 – 08:45	Tea, coffee, small talk and any nice biscuits anyone brings	all
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	all
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 VB.net and ExcelDNA. - Writing VBA UDF's 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	all
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	all
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 conference close	all
18:00 - late	P-U-B	all
	Drinking and arguing

Conference Location

The Skills Matter Exchange
116-120 Goswell Road
London, EC1V 7DP
Phone +44 (0)207 183 9040
Link/Map here

(Link goes to simple PayPal button to pay Codematic Ltd 250 GBP.) We will confirm your booking by email, generally within a couple of hours.

Full VAT receipts for conference bookings are available in pdf format on request.

Please note this is one of the very few Excel community training and social events of the year.You are sure to learn something new and meet someone new, with a shared interest in Excel.

Upcoming Events:

25 January 2012 - UK Excel Developer Conference - London

Products for sale:

Products coming soon:

Link Manager

(Find and control external links in Excel Workbooks)

Due by Q1 2111.

XLAnalyst Pro

(Excel VBA based spreadsheet auditing tool)

Due before the end of 2111.

;-)

This page was last reviewed on December 21, 2011

Rapid Application Development / Advanced Excel Development

UK Excel Developer Conference - Wednesday 25th January 2012 - London