|
|
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.
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.
JWalk and Associates
Books, good tips and help, and the power utility pack spreadsheet
utilities.
Woody's Office Watch
A regular free newsletter with some Office gossip. Also books and
some Office utilities.
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.
Ferret
Out Spreadsheet Errors
Good general paper on basic debugging techniques. No coverage of
advanced audit 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.
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, ...
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).
Pearson Software Consulting
Expert VBA Consulting
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.