Systems Modelling Ltd.
Free spreadsheet software

Home ] Spreadsheet Best Practices ] Consulting ] Book List ] Euro Index ] Search ]

 

 

Related Pages: Agile Spreadsheet Development ] Spreadsheet resources ] Inventory your Spreadsheets ] [ Free spreadsheet software ]


Free spreadsheet software resources

This is a selection of spreadsheet resources - some free, some commercial -  to do with Microsoft Excel, its clones, spreadsheet add-ins, and support for Excel developers and users. For a list of websites to do with spreadsheet development quality, financial and other modelling, see our spreadsheet links page and our Book list on Excel, Financial modeling, and related topics with links to Amazon.

On this page:

Spreadsheet application software for Windows and Linux
Useful spreadsheet templates for budgeting, planning, etc.
Excel VBA code examples, tools, freeware, shareware, commercial
Excel Tips, tricks, traps, bugs, bug fixes, user groups
Buy online: our SCANXLS utility to collect an inventory of spreadsheet usage

Spreadsheet Auditing Masterclass Dublin, London 2006
Spreadsheet Check and Control : key techniques to detect and prevent errors
New book on how to detect and prevent spreadsheet errors

Free Microsoft Excel Compatible Programs

Email us to let us know of more!

Windows

Open Office www.openoffice.org

OpenOffice.org is both a free open-source application and project. The product is a multi-platform office productivity suite compatible with all major file formats.

Gnumeric www.gnumeric.org  build 1.4.3 is available on Windows, see below.

SpreadCE www.byedesign.freeserve.co.uk/ 

Win95 and above, 400K. The only difference between the free Shareware and Registered versions is that the Shareware version has a message that is displayed each time you use one of the File menu options. SpreadCE has won the ZDNet PDA Software Award for best Windows CE Application.

Sphygmic Spreadsheet www.ds.unifi.it/~stefanin/AGR_2001/SH/sssheet.htm

Sphygmic Software Spreadsheet (1998, Win 3.1 16bit style) has 125 built-in functions, including text handling, statistical, date/time, and financial functions. Worksheets can span 256 columns and 16,384 rows. You can import industry standard CSV files and read and write Excel 4.0 files. (Direct download link, 4MB)

Excel Viewer 2003 from Microsoft.com (9MB)

Download Excel Viewer 2003, a freely distributable program that lets users open, view, and print Excel workbooks, even if you don't have Excel installed. This download is a replacement for Excel Viewer 97/2000 and all previous Excel Viewer versions.

   

Linux

Gnumeric www.gnumeric.org Current build is 1.4.3

Gnumeric, originally a free spreadsheet for Linux, is now also available on Windows. It aims to replace proprietary closed source spreadsheets. Coupled with the constant effort to ensure handling of major file formats, Gnumeric incorporates innumerable plug-ins which ensure user feedback by means of custom plug-in libraries. It includes a comprehensive array of filters (from txt to XML, HTML etc) to aid an effort in file sharing and cross suite compatibility.

PlanMaker for Linux www.softmaker.de/pml_en.htm 

Linux users now have an Microsoft Excel-compatible spreadsheet program from Germany's Softmaker. A free beta of PlanMaker for Linux is now available for download.

Christopher Browne's list www.ntlug.org/~cbbrowne/spreadsheets.html

1. Historical Background of Spreadsheets
2. Free Linux-Based Spreadsheets
3. Commercial Linux Spreadsheets
4. Other Spreadsheet Tools for Linux


 

Free spreadsheet templates

http://pages.stern.nyu.edu/~adamodar/ NYU Professor of Finance Aswath Damodaran provides a number of models for corporate finance, valuation, and option pricing, along with data sets, research papers, seminars, and webcasts.

www.exinfm.com/free_spreadsheets.html

About 70 free Excel spreadsheets for financial analysis from Matt Evans, CPA, CMA, CFM.

www.olin.wustl.edu/faculty/coon/spreadsheets.html

Free Business Plans, Spreadsheet Templates, Financial Spreadsheets, Marketing Plans, and Strategic Plans from William P. Coon (now retired) of Olin school of management, Washington University.

www.global-derivatives.com/spreadsheets.php

Global Derivatives Option Pricing Spreadsheets with simple models and those which rely on simulation techniques or advanced modeling. (Black-Scholes, Monte Carlo, Asset, Binomial/Trinomial, etc)

www.optiontradingtips.com/pricing/free-spreadsheet.html 

Peter McPhee's option pricing calculator to price European call and put options. VBA is unlocked, free to reuse.

www.accountingnet.ie/channels/audit&accounting/spreadsheets.htm

Capital budgeting analysis, merger valuation model, cash flow, seven examples in Business Finance

www.cortrapar.com/ExcelTemplates.htm

Forecasting, Price Analysis, Universal Trend Charter, NPV Solution, Break-Even Visualizer.

http://office.microsoft.com/en-gb/templates/CT011377021033.aspx

Microsoft Office Templates - only a few.

Also see the Statistics section of our Spreadsheets page for teaching materials for student practice.

Commercial Excel templates and workbooks

| |

Check the Google advertisements above for Excel templates and packages for financial plans, cash flow forecasting, annual budgeting, business planning,  5 year projections, sales analysis, cost accounting, and simulation; some with free samples. Also see the list of Excel ready-to-use spreadsheets and add-ins below.


Amazon.com USA Amazon UK

Scan and Inventory directories of Excel files and links

Do you ever wonder how many spreadsheet files you actually have on your hard disk or network, who wrote them, or how complex or interlinked they are? The answer is SCANXLS - Spreadsheet Links and Quality Metrics.

It is an Excel workbook that creates a listing of .XLS files in a drive and subdirectories along with their properties and complexity statistics. Its most important feature is to show how all these workbooks are linked together. Excel tells you what a workbook links to, but not what other workbooks use it as a source.


 

Excel VBA code examples, tools, utilities, shareware, commercial addins

Also see our spreadsheet links page for spreadsheet auditing tools and add-ins.

www.cpearson.com/excel.htm Chip Pearson's Excel Page is an important resource

www.mvps.org/links.html#excel  Microsoft Most Valued Professional pages include:

www.mvps.org/dmcritchie/excel/ David McRitchie's Excel Pages with articles, tips, resources, help ... a long page.

www.ozgrid.com OzGrid business applications by Dave Hawley has free advice, downloads and a very large template collection.

www.planware.org/ Templates for writing a business plan, making financial projections, and useful white papers.

www.add-ins.com/ Excel macros, assistants, charting, data, and a free downloadable book of time saving tips

www.VBAExpress.com VBA Express is a combined efforts of many expert VBA coders to provide VBA code, discussion forums, and a knowledgebase of examples.

www.dslimited.biz  Excel add-ins for auditing and detecting spreadsheet errors, and tutorials available.

www.bygsoftware.com/default.htm
The Excel Auditor and Tools to help you manage, document, trace and comment your VBA code.

www.spreadsheetworld.com/ Spreadsheet Aided Engineering Analysis

www.structural-engineering.fsnet.co.uk/spread.htm Spreadsheets for Structural Engineering

http://edc.bizhosting.com/  EDC Erlandsen Data Consulting Excel VBA code library.

www.oaltd.co.uk Office Automation (previously Business Modelling Solutions) is Stephen Bullen's independent consultancy. He supports the Compuserve Excel forum and provides a number of example Excel files.

www.users.bigpond.com/nathjohn/ Nathan's Excel site focuses on the presentation and formatting (usability) aspects of Excel systems.

http://ukww.net/patools/excel/da.htm  PATools Data Toolkit Manipulate and analyze data within Microsoft Excel.

www.oraxcel.com/ SQL * XL Bridge between Excel and databases

www.vbapro.com/ Information, links, and resources for Microsoft Excel and Visual Basic for Applications (VBA).

www.mindspring.com/~tflynn/excelvba.html Microsoft Excel VBA Examples

http://xl.barasch.com/index.htm Alan's Excel Goodies

www.beyondtechnology.com/geeks.shtml Microsoft Excel - Visual Basic for Applications code examples.

http://longre.free.fr/pages/telecharge/index.html  (France) XLL 33 add-in worksheet functions.

www.prodomosua.it/ (Italy) modulo VBA per Excel: many graphical data analysis utilities.

www.turedata.se/excel/ (Sweden) The Excel Site by Ture Magnusson - some quick tips

www.xldennis.com/ (Sweden) Dennis Wallentin Swedish site Tips & Tricks för MS Excel & VBA

www.erlandsendata.no/english/  (Norway) Ole P.'s Excel Tips


http://duncanwil.co.uk/spread.htm Duncan Williamson Spreadsheet examples page includes a Powerpoint presentation on designing spreadsheets

http://PrecisionCalc.com xlPrecision provides up to 32,767 significant digits of precision (compared to 15 with Excel) in 73 functions, including root, power, and all comparision operators.

www.bayfieldtraining.com/bayfieldtraining.asp?pg=4 Learner Resources from Bayfield Training, financial modelling training & consultancy for the real-estate sector. Natalie Bayfield is the author of Estate Gazette's Excel for Surveyors and Advanced Excel for Surveyors. 

www.cimaware.com ExcelFIX restores corrupt Excel files, also AccessFIX and WordFIX.

www.exceluser.com  Just How Bad Is Excel?, Why Excel Matters, Strategic solutions, OLAP and Excel. "Late nights? Conflicting spreadsheet databases? Broken links? Manual data entry? Embarrassing errors? Hand-carved reports? Broken macros? Monster spreadsheets? Organized confusion? Welcome to Spreadsheet Hell!"

http://www33.brinkster.com/rbad/ Rob's Excel VBA Pages and a lighthearted Excel Crash section.

www.geocities.com/xl_tutor/ Elias Koumides's site includes ACCPRO2005.xls (853 KB) an accounting program in VBA appropriate for small companies;  post transaction and make accounting reports such as Trial Balance and Statement of Account.

www.glynnconsulting.co.uk Robin Glynn has free downloads of business utilities and games.

 

 

www.cpadvantage.com/articlestech/spreadsheetudf.asp Article: "Pump Up Your Spreadsheets With UDFs" (not found Aug 2002)

www.intelligentapps.com/product_spreadsheet_risk.asp IntelligentApps 4excel data management add-in to Excel 2000 or Excel XP (not found Feb 2004)

 


Excel Tips, tricks, traps, bugs, bug fixes, user groups, blogs

http://blogs.msdn.com/excel/default.aspx Microsoft Product Manager David Gainer's blog about Excel 12

http://msdn.microsoft.com/office/ Microsoft Office Development Center

www.microsoft.com/office/excel/default.htm Microsoft's Excel site

www.MrExcel.com Bill Jelen's site has an extensive discussion board plus a section in Spanish.

http://wopr.com/ Woody's Office Watch: Office Tips,Bug Alerts & Fixes

http://monsieur-excel.blogspot.com/ Nombreux trucs et astuces pour Excel, par Hervé Thiriez (France)

www.sheet.com  AbleOwl software "The Excel Sheet" magazine (formerly the Spreadsheet User Group)

www.exceltip.com Joseph Rubin's long list of tips (no connection with below)

http://exceltips.vitalnews.com/  Free weekly Excel newsletter (no connection with above)

www.exceltips.net/ Brian Sheridan's categorised Excel tips (no connection with above)

www.puremis.net/excel/ Excel forum

www.excelbanter.com/ Forum gateway to Excel newsgroup discussions

www.dotxls.com/ Excel tips and Free Excel Calendar Templates

www.j-walk.com/ss/excel/eee/index.htm Excel Experts E-letter (or EEE), by David Hager.

http://chicago.sourceforge.net/devel/docs/excel/ Documentation and Source Code to deal with the Excel File Format

http://sc.openoffice.org/excelfileformat.pdf Open Office documentation on the internal Excel file BIFF format.

www.torry.net/vcl/reports/reportdesigners/agexcelreport.zip Contains BIFF Editor utility to show the binary record structure of .XLS files.

Up ]

  Traduisez / Übersetzen / Tradurre / Traduza / Traduzca Babelfish translator 

These pages are provided subject to Copyright and a disclaimer
Copyright © 2000-2006 Systems Modelling Ltd., Tara Hill, Gorey, Co. Wexford, Ireland.
Telephone +353-5394-22294  Fax +353-5394-22165 
Email Send email to enquiry at sysmod dot com  provided subject to the terms and conditions below.

PRIVACY: Your email address is treated as confidential and never disclosed without your explicit permission.
OPT-OUT: The phone and fax numbers and email addresses at sysmod.com provided on this web site are provided solely for one-to-one communications to Systems Modelling Ltd. We forbid any harvesting of email addresses from this site, or the inclusion of any sysmod.com address in any mail list without our explicit permission.
SPAM: Unsolicited bulk email to sysmod.com will be reported to SpamCop.

Last updated December 12, 2006