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
Expert traditional VBA articles. Lots of quality articles.
JWalk and Associates
Books, old but good tips and help, and the power utility pack spreadsheet utilities. Good links.
- The Excel Nexus
Provides Excel templates, tutorials, spreadsheets , and articles for business, home, and educational use. Plus, an extensive directory of Excel links.
Online book on VBA programming with Excel.
http://powerspreadsheets.com/ Some articles on advanced Excel techniques.
@nalyst library of financial functions, also Quant Tools. Fairly widely used.
Monte Carlo - like, plus Cystal Ball Pro that does optimization
Bob Flannagan's Spreadsheet Assistant, Neat utilities, plus Risk Analyser.
Utility that helps navigate through a spreadsheet
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.
Synkronizer compares, updates and synchronizes Excel spreadsheets.
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, ...
Free simulation tool. Roger Myerson, Northwestern University.
Produces The Excel Sheet magazine and courses etc.
Excel VBA consultant. Tips provided in an Excel Solutions Newsletter by Rodney Powell.
Chris Heinrich spreadsheet consultant (Oz).
Simple statistics functions add-in.
Statistical package. Parametric, non-parametric, and clinical research statistics. Also a book.
Tips plus some code samples
Rob Bovey, Consultant. Has tips and VBA utlities such as Code Cleaner which strip comments and compresses .xlas.
A Consultant, Tips and examples
Focus on Maths/Science. References to books, journals etc.
Source of general internet reources for auditors (much wider than just Excel).
General utilities, Risk/Sensitivity analysis, but no Auditing
Advanced tools for synchronizing different versions of a spreadsheet.
General utilities, Risk/Sensitivity analysis
Technical computing portal for scientific and engineering. Lots of links to other sites.
& E Research
Financial Workbooks, Investment, Finance, Option Pricing. Consulting
Business Planning Spreadsheets
Maps for Excel. Mainly USA. Includes Zip Centroids.
Excel courses, broad range of VBA based products and services.
Management Accounting and Forecasting Reporting Software
Process control software, including Shewhart X Bar & R etc.
UDA Construction cost estimation templates.
Case Based Training authoring tool for Excel
Howie Goodell's page, various academic analysis.
Lots of hints and articles, including the fate of DejaNews.
Provides free software for moving serial data feeds into Excel. (Eg. GPS).
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.
A technical computing portal for scientific and engineering.
& Dirty Task Guides
Provides FREE help with some not-so-obvious tasks in Microsoft Excel and Word. From OneOnOne Computer Training.
Spreadsheet xlNavigator 2002 helps track precedents and dependents.
General list of software.
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.
Pivot Table AutoFormat XL is an Excel add-in that allows creating your own collection of autoformats.
General help and info about Excel.
Enable a simple spreadsheet/data grid to be edited using simple web forms.
Provide spreadsheet services and spreadsheets.