Links to other spreadsheet pages
The following sites contain spreadsheet research,
information,
books or utilities. Please let us know if you have
or know of other good Excel related links that should be added to
this list.
Spreadsheet Risks
Concrete Spreadsheet
Errors
The author's own folly.
Australian CPA Article: Error Free? Spreadsheet Risks and Techniques.
Article discussing spreadsheet auditing.
European Spreadsheet Risk Interest
Group
They have an active mailing list and annual conference, whose papers
are available online.
12
of the Biggest Spreadsheet Fails in History -- Oracle
Including the Reinhart-Rogoff "Growth in the time of debt", TransAlta
$24 million overbuy, London Olympics oversell and a curious MI5 blunder.
5
Greatest Spreadsheet Errors of All Time
Including the Barclay overpayment of Lehman brothers and the JP Morgan
Chase London Whale.
Prof. Ray Panko's site
Panko pioneered academic research into the source and nature of
spreadsheet errors. His classic paper "What we know about
spreadsheet errors" is here.
Systems Modelling Limited
Patrick O'Beirne's site with an overview of spreadsheet risks.
Consultant based in Ireland.
AuditNet Auditors Resource Page
Source of general internet resources for auditors (much wider than
just Excel).
Lists and Forums
Microsoft's
Forum
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.
Mr Excel
Web forums that are well subscribed.
http://www.excelforum.com/
Another well subscribed web forum. Also some articles.
Spreadsheet Articles, Hints and Tips
Daily Dose of Excel
Good articles by many authors.
Decision Models
Charles Williams site. Does consulting, and useful info and a
FastExcel utility for optimizing spreadsheet performance.
Pearson Software Consulting
Expert traditional VBA articles. Lots of quality articles.
May now need to find this on archive.org
JKP Application Development
Several good technical articles.
Spreadsheets To
General blog on Excel. Beginner tutorials.
ExcelTips.com
Advanced Excel techniques.
Excel.Tips
Allen Wyatt's many articles, plus newsletter. Not to be confused with
www.exceltip.com!
Vertex42
- The Excel Nexus
Provides Excel templates, tutorials,
spreadsheet and articles for
business, home, and educational use. Plus, an extensive directory of
Excel
links.
Excel Hints
Some articles.
Automate Excel
VBA, Articles, and answers VBA queries. (Does development.)
Improve Your Excel
Free Excel Tutorials,Tips and Tricks
Excel VBA
Online book on VBA programming with Excel.
Power Spreadsheets
Some articles on advanced Excel techniques.
Excel Champs
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.
Excel Easy
Many free tutorials, including for beginners. Includes 300
examples.
Digital.com tutorials
This is an annotated list of other sites that have Excel Tutorials.
Spreadsheet Planet
Various tips and examples.
Computer Expert
Tutorials and a newsletter. Beginner to intermeidate.
Spreadsheet Tools
Cimaware Software
or ExcelFix
Cimaware Software offers programs for the recovery of corrupt Excel,
Access, and Word files.
TechHackers
@nalyst library of financial functions, also Quant Tools. Fairly
widely used.
Decisioneering/Crystal
Ball (now Oracle)
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
SQL Excel
Import data from ODBC data sources (ie. most databases).
Query builder.
Pdf
to Xls
PDF to Excel
Free web based PDF to spreadsheet converter.
Pdf
to Excel on iphone
Like it says.
PDF Tables
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.
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.
Synkronizer
Synkronizer compares, updates and synchronizes Excel spreadsheets.
Good for very large spreadsheets, but report is somewhat noisy.
Analyse-It
Statistical package. Parametric, non-parametric, and clinical
research statistics. Also a book.
xlStat
Statistics functions.
Windmill Software
Provides free software for moving serial data feeds into Excel.
(Eg. GPS).
NeurolXl
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, VBA writer, Access Mail Merge.
Able Bits
Many general Excel utilities.
Spreadsheet123
Templates, Spreadsheets, Documents, Calendars and Calculators.
SOS Click
Add in to save to multiple locations at once.
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, ...
Beyond Spreadsheets
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.
Productivity:
Why it is Important that Software Projects Fail
How does software really affect society?
Excel and Financial Modeling Training
Full Stack Modeller
A leading source of ongoing training for both Excel and financial modeling generally.
Plum Solutions
Danielle Stein Fairhurst's excelent financial modeling training and meetups.
F1F9
UK based respected trainers and developers. Focus on model clarity.
How to avoid Excel errors and keep your boss happy
Kate Bostock's excelent course.
Course Duck
List of Excel courses and Tutorials.
Excel Everest
Cool interactive training software, from basic formulas to pivot
tables. Many exercises, 87 embedded videos.
Beginning to
intermediate.
Excel University
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.
Global Corporate Finance Society
Professional association with training, certification etc.
AMT Training
Provides Excel financial modeling courses
Consultants
Access Analytics
Excel solutions, Business Intelligence and training. Spreadsheet
Detective reseller.
Corality
Independent model audit services and financial modelling blog.
Application Professionals
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
some
add-ins and utilities.
Glynn Consulting
Builds Excel and Access applications.
Unclassified
Louise Pryor's site
Papers and blog on spreadsheet risk.
Free Option Pricing Spreadsheet
For european otpions.
Ole Erlandsen's Pages
Tips plus some code samples
Alans Excel Goodies
A Consultant, Tips and examples.
Maus Business Systems
Business Planning Spreadsheets
Spreadsheet World
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
Consultant (Norway).
Better Solutions
"Users are developers." General help and info about Excel.
Peoria Design
Enable a simple spreadsheet/data grid to be edited using simple web
forms.
i-Spreadsheet
Excel-like web based spreadsheet..
Office-Addins
A wide range of addins & plugins for Microsoft Excel grouped by
categories.
Humor
Dilbert
The 6 month
review.
The Devil
One day in Heaven, Jesus and Satan are bickering nonstop about which of
them is better than the other. God says “ENOUGH! We’re going to
settle this right now. Whoever can fill up an Excel spreadsheet with the
most souls within 24 hours will officially be considered THE BEST.”
So Jesus
gets on his computer and starts meticulously typing in the names of each
soul, one-by-one, line-by-line, at his own slow and steady pace. Satan
on the other hand is using macros and going on the dark web and
illegally downloading thousands of lists of souls and is just filling
out his spreadsheet with all these different names. He’s feeling all
cocky and arrogant. “There’s no way Jesus can ever get more souls than
me!”
But then, with only 5 minutes to spare, the power in Heaven
goes out and comes back on. When Satan looks at his computer screen,
everything is empty! Satan is fuming with anger and cursing after every breath.
“It’s not fair, it’s not fair! I had so many souls! How could he have
won?!”
God then stops him and says “Satan, listen… Jesus saves.”
upjoke