Links to other spreadsheet pages
The following sites contain spreadsheet research,
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
The author's own folly.
Australian CPA Article: Error Free? Spreadsheet Risks and Techniques.
Article discussing spreadsheet auditing.
European Spreasheet Risk Interest Group
They have an active mailing list and annual conference, whose papers
are available online.
Ray Panko's Spreadsheet Research
A Survey of many academic papers and anecdotes on the nature and effect
of spreadsheet errors. Panko is/was a leader in the field.
Systems Modelling Limited
Patrick O'Beirne's site with an overview of spreadsheet risks.
Consultant based in Ireland.
Louise Pryor's site
Papers and blog on spreadsheet risk.
Lists and Forums
Technical forum monitored by Microsoft employees that occasionally provide useful information.
Microsoft's Excel Community
Another forum, more uer oriented.
Microsoft's Excel Blog
The blog of the Excel development team. Sometimes interesting.
EXCEL-G For General Excel questions.
EXCEL-L For Excel developers.
Old Mailing lists that are still well subscribed.
Web forums that are well subscribed.
Another well subscribed web forum. Also some articles.
Spreadsheet Articles, Hints and Tips
Pearson Software Consulting
Daily Dose of Excel
Expert traditional VBA articles. Lots of quality articles.
General blog on Excel. Beginner tutorials.
JWalk and Associates
Books, old but good tips and help, and the power utility pack spreadsheet
utilities. Good links.
Good articles by many authors.
Charles Williams site. Does consulting, and useful info and a
FastExcel utility for optimizing spreadsheet performance.
Advanced Excel techniques.
Allen Wyatt's many articles, plus newsletter. Not to be confused with
- The Excel Nexus
Provides Excel templates, tutorials,
spreadsheet and articles for
business, home, and educational use. Plus, an extensive directory of
VBA, Articles, and answers VBA queries. (Does development.)
Improve Your Excel
Free Excel Tutorials,Tips and Tricks
Online book on VBA programming with Excel.
Some articles on advanced Excel techniques.
New Indian E-Book with tutorals, blog, VBA etc.
Expert Excel Consultants
Help with all Office applications, including Macro/VBA development.
Dave McRitchie's site
Lots of hints and articles, including the fate of DejaNews.
Cimaware Software offers programs for the recovery of corrupt Excel,
Access, and Word files.
@nalyst library of financial functions, also Quant Tools. Fairly
Ball (now Oracle)
Monte Carlo - like, plus Cystal Ball Pro that does optimization
Bob Flannagan's Spreadsheet Assistant, Neat utilities, plus Risk
Utility that helps navigate through a spreadsheet
Import data from ODBC data sources (ie. most databases).
PDF to Excel
Free web based PDF to spreadsheet converter.
Pdf to Excel on iphone
Like it says.
Another PDF to Excel tool. Web based but can be used via an API.
Invest In Tech
Able2Extract tool for extracting spreadsheets from PDF documents.
On line tool for converting PDF data into xls files.
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
Synkronizer compares, updates and synchronizes Excel spreadsheets.
Good for very large spreadsheets, but report is somewhat noisy.
Statistical package. Parametric, non-parametric, and clinical
research statistics. Also a book.
Provides free software for moving serial data feeds into Excel.
This company offers add-ins for Microsoft Excel
that peform neural network forecasting and classification using
simple or complex data<
Access/Excel Tools, including importer, VBA writer, Access Mail Merge.
Many general Excel utilities.
Templates, Spreadsheets, Documents, Calendars and Calculators.
Creates gantt charts and administrates your projects
General tools, remove duplicates etc.
Intelligent data mining tools: hotspot profiling, clustering,
segmentation, predictive modeling, visualization, ...
Advanced data mining software for complete analytic database marketing:
predictive modeling, segmentation, profiling, visualization, ...
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.
Why it is Important that Software Projects Fail
How does software really affect society?
Cool interactive training software, from basic formulas to pivot
tables. Many exercises, 87 embedded videos.
Aimed at CPAs and accountants.
Walls Street Mojo
Free financial modeling course.
Computergaga Excel Training
Provide Excel training.
Qwik & Dirty Task Guides
Provides FREE help with some not-so-obvious tasks in Microsoft
Excel and Word. From OneOnOne Computer Training.
Independent model audit services and financial modelling blog.
UK based respected trainers and developers.
Focus on model clarity.
Rob Bovey, Consultant. Has tips and VBA utlities such as Code
Cleaner which strip comments and compresses .xlas.
OzGrid Microsoft Excel Training
Professional Excel consultant providing services in all aspects
of excel from remote training to custom enhancement. Also
add-ins and utilities.
Builds Excel and Access applications.
Free Option Pricing Spreadsheet
For european otpions.
Ole Erlandsen's Pages
Alans Excel Goodies
Tips plus some code samples
A Consultant, Tips and examples.
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
Maus Business Systems
Business Planning Spreadsheets
Excel courses, broad range of VBA based products and services.
United Design Marketplace
UDA Construction cost estimation templates.
End User Programming
Howie Goodell's page, various academic analysis.
Erlandsen Data Consulting
"Users are developers." General help and info about Excel.
Enable a simple spreadsheet/data grid to be edited using simple web
Excel-like web based spreadsheet..
A wide range of addins & plugins for Microsoft Excel grouped by