Codematic Excel developers logo
Codematic spreadsheet-excel development image

Rapid Application Development / Advanced Excel Development

 
Products for Excel
Commercial Products:
  - Classic Ribbon
  - Alt-FileSearch
  - Password Remover
Spreadsheet Quality Products
Free Products
Excel Development
Excel Development Index
Excel VBA
- VBA IDE (editor)
- VBA Training
- VBA Best Practice
- VBA Performance
- COM Performance
- VBA Security
Excel and Databases
Excel and Pivot Tables
Excel Add-ins
Worksheet Functions
Excel and xlls
Excel (in)security
Excel testing
Excel and .net
Excel External Links
Excel Developer Types
Professional Excel Development
Excel 2007
Excel 2010
Excel Development Archive
Spreadsheet Services
Spreadsheet Development
Spreadsheet Migration
Spreadsheet Maintenance
Spreadsheet Review
Spreadsheet Management
Resources
Excel User Confs
Consultant Profile
Book Reviews
Links
Other
Site Map

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

[Note due to venue constraints places are strictly limited - Last few places available]. See below to book.

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.

Excel Developer Conference
Standard rate

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:

AltFileSearch

Office 2007 FileSearch replacement logo

New information about the missing FileSearch feature in Office 2007 and details of our pragmatic solution (Current price GBP 30.00)


wsUnprotector

worksheet password remover logo

Instant Excel worksheet protection remover and password recovery (Current price GBP 15.00)


Classic Ribbon Tab

classic ribbon for office 2007 logo

Add Excel 97/2000/2002/2003 compatible menu structure to Excel 2007
(Current Price GBP 10.00)


 

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

©Codematic Ltd 1999-2011