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

New book on how to detect and prevent spreadsheet errors

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.

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.