The internet library
Whatever you need to know, the information will be somewhere on the internet. One way to find it is by using a search engine, but often the best source is a subject-specific reference site listing other relevant websites. This page is specifically devoted to sites relevant to spreadsheets and financial modelling.
The sites listed below will open in a new browser window; simply close this to return to The Model Answer.
AbleBits.com and Office-Addins.com
Related sites offering Excel add-ins for pivot table formatting, advanced search & replace, managing multiple spreadsheets and much more, plus a wide range of plugins for Microsoft Outlook.
European Spreadsheet Risk Interest Group
EuSpRIG works to increase awareness of spreadsheet errors in academia and industry and to promote research into methods of preventing and detecting errors.
Recover your lost or damaged Excel files in a few minutes with ExcelFIX.
Very clear and easy-to-follow Excel tutorial (Introduction, Basics, Functions and Data Analysis), fully illustrated with step-by-step screenshots.
A range of free Excel templates, including to-do list, invoice, budget, and calendar applications, with tutorials for customizing the files.
Excel Tips for Data Analysts
Very practical and detailed tips for data cleaning, analysis and visualization, optionally using Power Query features.
Jabsoft and Model Advisor
Two related sites offering a very wide range of add-ins, templates and other products for Excel, including many third-party products as well as those developed in-house by Jabsoft.
John Walkenbach’s “The Spreadsheet Page”
A large site with information on many spreadsheets and spreadsheet-related material.
Ozgrid Business Applications
Helpful hints on a wide range of Excel topics, plus custom add-ins and training.
Spreadsheet Research (SSR)
A repository for research on spreadsheet development, testing, use, and technology, maintained by Dr. Ray Panko of the University of Hawaii.
Systems Modelling Ltd
Useful information on spreadsheet risks, and a comprehensive set of links to other spreadsheet resources.
Microsoft Excel training courses provided by Activia at your offices UK wide or at our training centres in London Birmingham Berkshire and Buckinghamshire.
Acuity’s Microsoft Excel training courses can take you from being a complete beginner, who has never used Microsoft Excel, all the way through to an advanced user.
AMT offers financial modelling training for the banking and finance sector, providing in-house training for many large organisations as well as public courses around the world.
Excel Training London and UK wide with Microsoft Certified trainers. Learn to use MS Excel at London centres or on-site UK wide.
Comprehensive online tutorials covering basic and advanced Excel (and many other core IT topics).
Free online Excel training that adapts to different skill levels, from complete beginner to advanced.
Business and finance
CNNfn financial network
US financial news, including search and stock quotes.
Includes forms, and live search of CH database during office hours.
The FT online, including search engine, global archive and business directory.
Official UK statistics site, with a vast store of latest and archived statistics, the StatBase database of government statistics, and free copies of recent publications in PDF format.
Accounting and regulation
Financial Reporting Council
Useful summaries of standards and other publications, though does not provide the full text.
News service, directories and other resources for accountants.
Institute of Chartered Accountants
Useful information for accountants in England and Wales.
HM Revenue & Customs
A wide range of helpful tax-related information, including press releases, publications and technical information.
International Financial Reporting Standards
Details of global accounting standards.
Wachowicz’s Web World
Financial management web sites, plus spreadsheet templates.