Links to other spreadsheet pages

The following sites contain spreadsheet research, information, books or utilities. They are difficult to categorize because most sites offer several of the above. Please let us know if you have or know of other good Excel related links that should be added to this list.

Spreadsheet Risks

Australian CPA Article: Error Free? Spreadsheet Risks and Techniques.
Article discussing spreadsheet auditing.

Ray Panko's Spreadsheet Research
A Survey of many academic papers and anecdotes on the nature and effect of spreasheet errors

Systems Modelling Limited
Patrick O'Beirne's site with an overview of spreadsheet risks. Consultant based in Ireland.

Pricewaterhouse Coopers Site
Papers on how to build spreadsheet models.

http://www.louisepryor.com - Louise Pryor's site.

Ferret Out Spreadsheet Errors
Good general paper on basic debugging techniques. No coverage of advanced audit tools.

http://www.eusprig.org/ European Spreasheet Risk Interest Group
They have an active mailing list and annual conference, whose papers are available online.

Lists and Forums

Usenet microsoft.public.excel.programming etc.
The usenet news groups. Still one of the best resources. Can be accessed via http://groups.google.com/group/microsoft.public.excel.programming

EXCEL-G (for General Excel questions) EXCEL-L (for Excel developers)
Old Mailing lists that are still well subscribed.

http://www.mrexcel.com/
Web forums that are well subscribed.

http://www.exceltip.com/ , http://www.excelforum.com/
Another well subscribed web forum. Also some articles.

Spreadsheet Articles, Hints and Tips

JWalk and Associates
Books, old but good tips and help, and the power utility pack spreadsheet utilities. Giood links.

http://blogs.msdn.com/excel/default.aspx
The blog of the Excel development team. Sometimes interesting.

http://www.dailydoseofexcel.com Daily Dose of Excel
Good articles by many authors.

http://excel.tips.net/ (Allen Wyatt)
Many articles, plus newsletter. Not to be confused with www.exceltip.com!

Vertex42 - The Excel Nexus
Provides Excel templates, tutorials, spreadsheets , and articles for business, home, and educational use. Plus, an extensive directory of Excel links.

USF Spreadsheet Analytics
Many links from the University of San Francisco.

Decision Models
Charles Williams site. Does consulting, and useful info and a FastExcel utility for optimizing spreadsheet performance.

Pearson Software Consulting
Expert VBA Consulting. Lots of tips.

http://excelhints.com/
Some articles.

http://www.codeforexcelandoutlook.com/
Articles, and answers VBA queries. (Does development.)

http://monsieur-excel.blogspot.com/
General thoughts on auditing. In French.

Spreadsheet Tools

David Nixon's EuSpRIG Paper
Compares various Excel auditing tools.

TechHackers
@nalyst library of financial functions, also Quant Tools. Fairly widely used.

Decisioneering/Crystal Ball
Monte Carlo - like, plus Cystal Ball Pro that does optimization

Macro Systems (Add-Ins.com)
Bob Flannagan's Spreadsheet Assistant, Neat utilities, plus Risk Analyser.

Viziware Navipane
Utility that helps navigate through a spreadsheet

Duplicate Remover
Finds and removes duplicate rows from Microsoft Excel spreadsheets.

SQL Excel
Import data from ODBC data sources (ie. most databases). Query builder.

http://quick-xl.com/
Automatically builds a handy user form to help manually enter data.

http://www.distributedspreadsheet.com/
Manage distribution (via email) of spreadsheets for update and consolodation of results.

Model Correctness Services

BPM Analytical
Best practices in model development. (Initiated by Salomon Smith Barney.)

Other Consulting

http://expertexcelconsultants.com/ Help with all Office applications, including Macro/VBA development.

Data Mining

StarProbe Data Miner
Intelligent data mining tools: hotspot profiling, clustering, segmentation, predictive modeling, visualization, ...

Database Marketing
Advanced data mining software for complete analytic database marketing: predictive modeling, segmentation, profiling, visualization, ...

Models

Free Option Pricing Spreadsheet
For european otpions.

Beyond Spreadhsheets

Sumwise Modeler
A new type of spreadsheet language that puts more structure back into the model, so that names can be used directly. Strong emphasis on semi-repetitive structures used in financial models.

Non Spreadsheet

Productivity: Why it is Important that Software Projects Fail
How does software really affect society?

Artifical Intelligence will Kill Our Grandchildren
Looking at the bigger picture.

Instep Personal Finance
Access application for budgeting and investment tracking.

Excel Training

http://www.exceleverest.com/ Cool interactive training software, from basic formulas to pivot tables. Many exercises, 87 embedded videos. Beginning to intermediate.

Unclassified

Computergaga Excel Training Provide Excel training.

Corality Independent model audit services and financial modelling blog.

Navigator Project Finance Financial modelling and project finance training courses.

Widgenie
Visualization tools, for web 2.0.

Improve Your Excel
Free Excel Tutorials,Tips and Tricks

Cimaware Software or ExcelFix
Cimaware Software offers programs for the recovery of corrupt Excel, Access, and Word files.

Simtools and Formlist
Free simulation tool. Roger Myerson, Northwestern University.

Edwin's Power Tools
Miscellaneous utilities, including fancy 3-D cell shading.

AbleOwl (was Spreadsheet User Group)
Produces The Excel Sheet magazine and courses etc.

Beyond Technology
Excel VBA consultant. Tips provided in an Excel Solutions Newsletter by Rodney Powell.

Hotsheets
Chris Heinrich spreadsheet consultant (Oz).

slStat
Simple statistics functions add-in.

Analyse-It
Statistical package. Parametric, non-parametric, and clinical research statistics. Also a book.

Simon Benninga
Writes Financial books, free financial journal.

Ole Erlandsen's Pages
Tips plus some code samples

ZDNet's Office Page
Includes Excel stuff

Application Professionals
Rob Bovey, Consultant. Has tips and VBA utlities such as Code Cleaner which strip comments and compresses .xlas.

Alans Excel Goodies
A Consultant, Tips and examples

Nathans Excel Page
Excel VBA developer with useful hints and tips.

Spreadsheets in Education
Focus on Maths/Science. References to books, journals etc.

AuditNet Auditors Resource Page
Source of general internet reources for auditors (much wider than just Excel).

BeaconWare/SQLPro
Loads data into Excel (Only in Danish?)

Excel Spreadsheet Solutions
General utilities, Risk/Sensitivity analysis, but no Auditing

Synkronizer
Advanced tools for synchronizing different versions of a spreadsheet.

Excel Spreadsheet Solutions
General utilities, Risk/Sensitivity analysis

Mathtools.net
Technical computing portal for scientific and engineering. Lots of links to other sites.

J & E Research
Financial Workbooks, Investment, Finance, Option Pricing. Consulting

Maus Business Systems
Business Planning Spreadsheets

Concept Data
Tools to recover corrupted spreadsheets, XL95 and XL97

Software Illustrated (Mapland)
Maps for Excel. Mainly USA. Includes Zip Centroids.

Spreadsheet World
Excel courses, broad range of VBA based products and services.

G L W Software
Management Accounting and Forecasting Reporting Software

SPC Orchestra
Process control software, including Shewhart X Bar & R etc.

United Design Marketplace
UDA Construction cost estimation templates.

xlCBT
Case Based Training authoring tool for Excel

CNet's Excel Page
Links into Microsoft, plus several utilities and reviews.

ZDJourna Publications
Includes Inside Excel and Microsoft Office Developers Journal.

ZDNet Spreadsheet Downloads
Lots of utilites, many of which are also in this link page.

Windows Magazine Shareware
Includes some spreadsheet programs.

End User Programming
Howie Goodell's page, various academic analysis.

Franz Hormann
Research in the risks and right techniques of using spreadsheets.

Erlandsen Data Consulting
Consultant (Norway).

Dave McRitchie's site
Lots of hints and articles, including the fate of DejaNews.

Windmill Software
Provides free software for moving serial data feeds into Excel. (Eg. GPS).

OzGrid Microsoft Excel Training
Professional Excel consultant providing services in all aspects of excel from remote training to custom enhancement. Also some add-ins and utilities.

www.mathtools.net
A technical computing portal for scientific and engineering.

Qwik & Dirty Task Guides
Provides FREE help with some not-so-obvious tasks in Microsoft Excel and Word. From OneOnOne Computer Training.

www.Brandywine-Software.com
Spreadsheet xlNavigator 2002 helps track precedents and dependents.

SoftBase http://www.softbase.150m.com/top79.html
General list of software.

www.excel-vba.com
Pierre Leclerc page of tips and tricks. Offers consulting.

www.neuroxl.com
This company offers add-ins for Microsoft Excel that peform neural network forecasting and classification using simple or complex data.

4 Tops
Access/Excel Tools, including importer.

Able Bits
Pivot Table AutoFormat XL is an Excel add-in that allows creating your own collection of autoformats.

Better Solutions
General help and info about Excel.

Solver.com -- Frontline Systems
They wrote the Excel Solver, and have a much faster, more powerful versions. It provides several algorithms that can solve huge linear and quadratic problems, integer problems and can handle (smaller) non linear or even non continuous spaces. The interval solver can even assure that global optimals have been found.

Peoria Design
Enable a simple spreadsheet/data grid to be edited using simple web forms.

Spreadsheet123.com

Provide spreadsheet services and spreadsheets.

Hilton Bombing
Interesting link.

<>Extras 4 Excel
Articles and Newsletters on Excel.

Synkronizer
Synkronizer compares, updates and synchronizes Excel spreadsheets.

XL Tutor
Does XL Training.

Glynn Consulting
Builds Excel and Access applications.

XL Project
Creates gantt charts and administrates your projects

i-Spreadsheet
Excel-like web based spreadsheet..

Office-Addins.com
A wide range of addins & plugins for Microsoft Excel grouped by categories.

www.worksheet.nl
Excel site in Dutch.

http://www.forgram.com/
XML to Excel converter

SimpleORM

www.Berglas.org
XL Detective

Woody's Office Watch
Was a regular free newsletter with some Office gossip. Also books and some Office utilities.

<>Home Page