Advanced Excel Development, Training and Support

Links to useful sites

Software development links

http://www.cc2e.com/ - Website of Steve McConnell of Code Complete fame - lots of useful software development information

http://agilemanifesto.org/ - Website of the Agile Alliance, go and read the manifesto

http://alistair.cockburn.us/ - Website of Alistair Cockburn, Agile software development author

http://pragmaticprogrammer.com/ppbook/index.shtml - Website of the pragmatic programmers, purveyors of very sound development advice.

http://www.mcbreen.ab.ca/SoftwareCraftsmanship/ - Website of Pete McBreen, author of Software craftsmanship.

http://www.gnome.org/projects/gnumeric/ - Website of Gnumeric, an open source spreadsheet - Fast Accurate and Free, very compatible with Excel.

http://www.codeproject.com/ - Website dedicated to sharing knowledge and source code, mainly Visual Studio, mainly .net related, great articles, great code.

Spreadsheet links

http://www.eusprig.org/ - European Spreadsheet Risk Interest Group, a group of academic and business professionals dedicated to highlighting some of the dangers lurking in commercial spreadsheets.

http://www.sysmod.com/ - Patrick O'Beirnes website, home of scanxls and plenty of software development and spreadsheet errors (hes the author of Spreadsheet Check and Control)

http://www.louisepryor.com/show.do?page=home - Louise Pryors spreadsheet quality site.

http://www.exceluser.com/index.htm - Charley Kyds Excel site, lots of useful information on integrating Excel with OLAP.

http://blogs.msdn.com/excel/ - All the latest Excel 2007 info from David Gainer, a program manager on the Excel team.

http://www.j-walk.com/ - John Walkenbachs site, loads of great Excel content and plenty of links.

http://www.excelkb.com/ - xlDennis website content focused towards the more technical aspect of Excel like database manipulation.

http://www.appspro.com/ - Rob Boveys (joint author of PED) consulting site, home of his very useful Excel utilities.

http://www.oaltd.co.uk/ - Stephen Bullens (joint author of PED) consulting site, plenty of good excel content including lots of free tools and utilities.

http://www.decisionmodels.com/index.htm - Charles Williams site discussing the full depth of Excel calculation issues, incredible amount of information and home of FastExcel.

http://www.andypope.info - Andy Popes web site, lots of great Excel and data presentation content.

Risk Management links

http://www.theirm.org/ - Website of The Institute of Risk Management.

http://www.systemsguild.com/riskology/ - Atlantic System Guild home of Tom DeMarco (Peopleware, Slack among others) and some very powerful knowledge - this section in particular is to do with risk assessment and management.

Useful tools

http://www.mztools.com/ - very useful and free Excel VBA IDE add-in that provides some very useful features.

http://www.as-ltd.co.uk/xllplus/whatsnew.htm - Planatech, the authors of xll+ used to create C based xlls.

http://xlw.sourceforge.net/html/main.html - open source C++ framework to wrap up some of the complexity and dangers of the Excel C API .