This page is no longer maintained. Last updated 17 Dec 2002.This page is no longer maintained. Last updated 17 Dec 2002.
We do not pursue many links for VBA. VBA is a much bigger topic than Excel.
"OR" means operations research.
A very few sites deserve 5-star rating. These sites have extensive libraries of information.
1. Auditing.
2. Style: how you should write a spreadsheet.
3. How do I use Excel? Basic tutorials and tips.
4. How do I do something complicated with Excel? Advanced tips.
5. Free tips and code, often consultants.
6. Consultants with no tips, or tips for sale, or only software for sale.
7. Links to links.
8. Spreadsheet models, mostly free.
9. Sites for spreadsheets in education, especially primary school.
10. Research about spreadsheets.
11. A few non-English language sites.
The Excel community is dreadfully short on resources for auditing spreadsheets! If you know of any related links, send them in!
| Link | Review | Type | Content | Style |
|---|---|---|---|---|
| AuditNet.org | Great site for financial auditing (not just auditing Excel). See his page on spreadsheets! | org | **** | **** |
| Excelerated Consulting - Spreadsheet Professional | Highly-rated spreadsheet auditing tool. Free demo. | com | **** | **** |
| The Excel Logic Page | Great auditing tool, plus charts, finance, tips. | nam | **** | *** |
| Home Office Computing Auditing for Accuracy | Basic how-to of auditing. | com | **** | *** |
| Byg Software's home page | Audit add-in sellers. 40+ free spreadsheets | com | **** | *** |
| GETTING THE OOPS! OUT OF SPREADSHEETS | Basics of spreadsheet auditing. | org | **** | ** |
| An easy way to audit a formula's references | Basics of auditing. Nice keyboard shortcuts. | com | *** | *** |
| Chapter 10: Fixing Formula Problems | One free chapter from "Complete Idiot." Fortunately it's on auditing. | com | *** | *** |
| Master Excel Spreadsheets | A couple good ideas for auditing. | com | *** | *** |
| Slicing Spreadsheets: An Integrated Methodology for Spreadsheet Testing and Debugging | Technical, academic, very interesting. | org | *** | *** |
| Operis - Leading the Business Revolution | Consultants who sell an audit tool. A few good tips. | com | *** | *** |
| Brandywine Software LLC | Audit add-in gives a flow-chart view. | com | *** | *** |
| The Spreadsheet Detective | Clever but loud auditing tool. | com | *** | * |
| Canada Computes - Spreadsheet audit | Short article. "Healthy distrust" - I agree! | com | ** | *** |
| Spreadsheet Comprehension Through Visualization | Academic with audit tool. | edu | ** | *** |
| Auditing for Accuracy | Rather basic. Not all wise. | com | ** | *** |
| TheModelANSWER | Consultant. Free auditing add-in, Rainbow Analyst. | com | ** | ** |
| Software-Expert | LinkMaster auditing shareware add-in. | com | ** | ** |
| Link | Review | Type | Content | Style |
|---|---|---|---|---|
| PriceWaterhouseCoopers Publications - Spreadsheet Modelling Best Practice | Outstanding 100-page document (PDF) on spreadsheet style. Developers, pay attention. | com | ***** | **** |
| The New Guidelines for Writing Spreadsheets | My academic site on readability. | edu | You | decide |
| Guidelines for Formatting Worksheets | Short, sweet, right. | edu | **** | **** |
| spreadsheet design | Simple yet effective, by an academic. | edu | **** | **** |
| Guidelines for Natural Resources Projects | Good suggestions on data entry; cautions on Excel's statistical functions. | edu | **** | *** |
| Spreadsheeting | Nicely done basic tutorial. | com | *** | **** |
| The Spreadsheet Challenge | Some very good ideas, some bad. | com | *** | *** |
| FrontLine Systems readability hints | Good suggestions for modeling. | com | *** | *** |
| The Power of Spreadsheets | Lots of good info, some bad style. | com | *** | *** |
| The Fortress - Joseph Moosman | Personal web page with lots on Excel | nam | *** | ** |
| University of Leeds computer help | Lots good, but they like modular style. | edu | ** | *** |
| Monash Univ. Financial Modelling | Nicely written bad advice. | edu | * | *** |
| Information Integrity Research Centre | Academics studying user errors. | edu | * | *** |
| Spreadsheets and Business | Elementary, modular style, PowerPoint. | edu | * | 0 |
| Standard Spreadsheet Design Guide | Perfect example How Not To Do It (sorry, mate). | edu | 0 | *** |
You can get high-quality help from newsgroups. First read Pearson's tips for new posters.
microsoft.public.excel.programming. Not just geeks; the highest-use Excel newsgroup.
microsoft.public.excel.misc. General Excel stuff. Second highest-use Excel newsgroup.
microsoft.public.excel.charting. Less used.
The rest of Microsoft's newsgroups. Much less used.
Excel-G: MS Excel General A & A List. Infuriating to sign on or off.
Excel-L: Microsoft Excel Developers List. Ditto.
See also comps.apps.spreadsheets.
Try a Q & A web site, such as AllExperts.Com.
I list here some consultants who have lots of tips, rather than in the Consultants table.
| Link | Review | Type | Content | Style |
|---|---|---|---|---|
| Microsoft's Excel site | Always some new ideas. | com | **** | **** |
| Lotus 1-2-3 | Ver. 9!? 2.1 was my favorite, then God made Excel. | com | **** | **** |
| Inside Learner Center | Outstanding basic tutorial by Microsoft. | com | **** | **** |
| Education - Excel 2000 | Another outstanding tutorial by Microsoft. Nobody does it better. | com | **** | **** |
| Undiscovered Tips About Excel | Clever shortcuts by Microsoft. | com | **** | **** |
| Frequently Asked Questions for Excel for Windows | Microsoft's Excel FAQ. | com | **** | **** |
| Table of Contents for Tutorials | Outstanding, very large set of advanced tutorials by John Lacher. | com | **** | **** |
| Qwik & Dirty Task Guides | Beautiful set of tutorials by specialists in training. | com | **** | **** |
| comp.apps.spreadsheets FAQ | Excellent, interesting, many links. | com | **** | **** |
| A Spreadsheet Tutorial | Elementary, but well done. | edu | **** | **** |
| Info 130 Fall 2000 Lecture Schedule | Detailed basic Excel tutorial. | edu | **** | **** |
| Getting Started with Microsoft Excel | Detailed basic Excel tutorial. Apparent mirror here. | edu | **** | **** |
| Additional & Tutorial Materials | Mix of Excel tutorials, in PowerPoint, PDF, xls. | edu | **** | **** |
| Learning Microsoft Excel | Basic Excel tutorial. | edu | *** | **** |
| The Best Keyboard Shortcuts for Selecting Data | Some basic shortcuts by Microsoft. | com | *** | **** |
| Neville Hunt's Publications available online | Using Excel to teach statistics, draw box plots. Nice! | edu | *** | **** |
| Excel Basics (Weather Watch Sample) | Elementary but well done tutorial. | edu | *** | **** |
| Data Crunching 101 for Journalists | Nice Excel tutorial. | nam | *** | **** |
| Ed's Excel Pages | Charming personal site. Charting tools & great pivot table tutorial. | nam | *** | **** |
| The Easter Egg Archive | Check out Excel Flight Simulator. | com | *** | **** |
| Bernard V. Liengme | Chemistry prof with Excel tips. | edu | *** | *** |
| Microsoft Excel '97 "How To" Guide | Brief how-to of some of the basics. | edu | *** | *** |
| Microsoft Excel Tip | Long list of Excel tips pinched from www.techrepublic.com. | com | *** | *** |
| Chi-Square, a lesson by Amar Patel | Tutorial on chi square with Excel. | edu | *** | *** |
| Statistics and Spreadsheets by John P. Crotty | Basic Excel tutorial. | edu | *** | *** |
| Excel Basics - A CCSO Student Free Computer Course | Elementary. Good, except for the bad HTML. | edu | *** | ** |
| Spreadsheet Basics | Elementary, for Macs. | edu | ** | *** |
| Lesson 4b | How to use a spreadsheet. | com | ** | *** |
| Excel tutorial. | Elementary. Some bad ideas: "Spreadsheets can be pretty dry, so we need ...to dress them up a little." | edu | ** | ** |
| Computer Operation Tutorials - Spreadsheet/Graphing | If you're this far, you don't need it. | com | * | **** |
| Planning-Designing a Spreadsheet | How to use Excel. | edu | * | ** |
| Spreadsheets - History & Introduction | Not much there. | edu | * | ** |
| Spreadsheet Software | How to use Excel, but all PDF documents. | edu | * | * |
| Qarbon Viewlet Library - Excel | Overbasic ("How to italicize text"), with a heavy app to see it. | edu | * | 0 |
| SPREADSHEET/DATABASE | Go hunt for your own help. | com | 0 | *** |
| Spreadsheet Hangman - Terms used in Spreadsheet Creation and Use | Stupid, but try it. | com | 0 | *** |
| spreadsheet | Dictionary definition of spreadsheet. | com | 0 | *** |
| Link | Review | Type | Content | Style |
|---|---|---|---|---|
| Microsoft Office Development Center | Title says it. | com | ***** | **** |
| EDC Erlandsen Data Consulting | Big library of Excel VBA code. Well-organized! | com | ***** | **** |
| ZDNet - Where Technology Takes You | Tons! News, tips, free code, shareware. Not well-organized, too many ads. Still worth a search. Example: Export Excel to LaTeX. | com | ***** | *** |
| David McRitchie | Outstanding. Heaps of macros, tips, links. Nice job! | nam | **** | **** |
| Putting XML to Work | Microsoft's How to use XML with Excel. | com | **** | **** |
| Embedding Your Spreadsheet Data into Web Pages | Good info, but advanced. Links to more. | com | **** | **** |
| Excel Tips | Lots of tips from consultants. See their pivot table tutorial, too. | com | **** | **** |
| Baarns Consulting | See the archive for heaps of tips and free code. | com | **** | **** |
| Rob's Excel VBA Utilities | Lots of handy VBA utilities. | nam | **** | **** |
| OR-Notes, J E Beasley | Excellent tutorial in OR, some with Excel. | edu | **** | **** |
| Neville Hunt - Producing Statistical Tables using Excel | Academic how-to on statistics. | edu | **** | **** |
| tushar-mehta.com | Operations mgmt consultant with a nice site. Tutorials, free functions, free VBA, simulation, Gantt charts. | com | **** | *** |
| PC Magazine Online - Spreadsheets | List of well-written Excel tricks. | com | **** | **** |
| Willow Solutions, Inc. | Excel for traders, but see the Willow Tips. Gorgeous site. | com | **** | **** |
| Excel-VBA.com | Lots to connect Excel to Access. And a nice guy. | com | **** | *** |
| Flynn Home Page | Lots of VBA code. | nam | **** | *** |
| Accounting Advisors, Inc. | Faintly annoying, but content-rich. | com | **** | *** |
| Spreadsheets Incorporated | You like range names? Read his tips first. | com | *** | **** |
| Excel tips | A long list of arcane Excel tips. | com | *** | **** |
| Excel spreadsheets for mathematics teaching | Graphs - interactive, biology. Astronomy. But his Mystic Rose made my day. Other cool non-Excel stuff. | edu | *** | **** |
| Fred Cumming's EXCEL Page | Some utilities. | nam | *** | *** |
| ASAP Utilities | An add-in and a few tips. | com | *** | *** |
| Computer Tutorials | Tutorials on pivot tables & Solver. | edu | *** | *** |
| Anthony's VBA Page | Random number generators, Monte Carlo, Black-Scholes, portfolio optimization, multiple regression. Lovely code, but I hate frames. | com | *** | ** |
| Updating Excel from the Web | Lovely article about web queries. You need this. | nam | ** | **** |
| Igor Kolupaev's Visual Basic | Some VBA utilities. | nam | ** | ** |
| XSolutions of Rockland Consulting Services | MS Office consulting | com | ** | * |
| The Spreadsheet Web | Some VB tips. | com | * | **** |
| Link | Review | Type | Content | Style |
|---|---|---|---|---|
| Windows API Guide | I said no VBA, but this is great. | com | ***** | **** |
| The Excel MVP Page | Free code from Microsoft's MVPs. | com | **** | **** |
| JWalk & Associates, "The Spreadsheet Page" | Among the very best, from a consultant. | com | **** | **** |
| John F. Lacher, CPA | Great web site, from a consultant. See his tutorials. | com | **** | **** |
| Pearson Software Consulting | Another consultant's great web site. | com | **** | **** |
| fernando cinquegrani: pagine personali | Personal page, Italian. A variety of free code: statistics, graphing, Delaunay triangles, trees, encoding, banners, etc. Also fun non-Excel - see the palindrome maker. Most beautiful web site I've ever seen. | com | **** | ***** |
| Using Excel's Solver with Visual Basic (Microsoft) | Almost pure data, well done. | com | **** | **** |
| OzGrid Business Applications | Consultant. Brilliant tips on validation, arrays, more. Also at Ozgrid.com | com | **** | **** |
| Business Modelling Solutions, Ltd. | Hard-working consultant. Lots of free stuff. | edu | **** | **** |
| VBA Pro | VBA consultant. Great links. | edu | **** | **** |
| Spreadsheet Add-ins Survey | A list of add-ins for OR. | com | **** | **** |
| Financial Analysis & Spreadsheet Design | Consultants with lots of tips. | com | **** | *** |
| Simtools and Formlist | Statistics, simulation, decision analysis, tornado diagrams. | edu | **** | *** |
| Beyond Technology | Consultants, lots of interesting tips. | com | **** | *** |
| LINDO Systems | Great solver add-in, with many templates. (Disclosure: my PhD advisor wrote it.) | com | **** | *** |
| Alan | Lots of free code & tips. Cheerful site, but the mouse hover bothers me. | nam | **** | ** |
| Linking Domino to Excel via XML | Converts xls to xml. | com | *** | **** |
| Fast Formulas | Consultants. Ready-made spreadsheets in finance, marketing, accounting, economics, operations mgt, engineering. | com | *** | **** |
| SpreadsheetWorld.Com | Training, consulting, a few add-ins. | com | *** | **** |
| Tucows | Thin selection of for-pay add-ins from an early patron of shareware. Hard to get to Excel stuff. | com | *** | **** |
| looking glass training | Lots of good tutorials. Aimed at accountants. | com | *** | *** |
| Welcome to Application Professionals | Microsoft MVP with some helpful VB utilities. | com | *** | *** |
| Filters Project Web pages | Converts xls to xml. | org | *** | *** |
| Export an Excel Worksheet to XML (Excel Macro) | Converts xls to xml. | com | *** | *** |
| Welcome to Kents Excelpage | Swedish consultant with some VB tips. | com | *** | *** |
| DirtSoft - Construction Solutions using Excel | For-pay spreadsheets: estimating, admin, end area plotter, gantt. | com | *** | *** |
| Excel add-ins | Interesting matrix functions. | nam | *** | *** |
| Decision Modeling Add-Ins for Excel | The title says it. | com | *** | *** |
| ZDNet Software Library | List of add-ins to download. | com | *** | *** |
| Spreadsheet Risks | Consultants. Some good links. | com | *** | *** |
| Array functions | Free array functions. | nam | *** | *** |
| Einar Ståle Huse | Norwegian researcher has free Excel password buster & XLA decompiler. | nam | *** | *** |
| AlphaWorks Excel Accessor Bean | IBM. Use Java to read Excel files. | com | ** | *** |
| Nathan's Excel Page | Consultant. A couple apps, huge images. | com | ** | * |
| LCL Resources | Consultant. Hard-to-read tips about presentation. | com | ** | * |
| Habermann Stuff | Just one item, maybe very useful: retrieve HTML tables into Excel. | com | * | **** |
| Graph CoOrdinates | Add-in shows coordinates on a scatter plot. | nam | * | ** |
| Link | Review | Type | Content | Style |
|---|---|---|---|---|
| CNet Downloads | Over a hundred downloads, only a dozen free. | com | **** | **** |
| Palisade - Complete Risk and Decision Analysis for Excel! | A serious tool for managing risk. | com | **** | **** |
| Element K Journals - Inside Microsoft Excel | Variety of tips, a few free. | edu | **** | **** |
| Excel Add-Ons | Lots of shareware add-ins. Some freeware. | com | **** | **** |
| AnalyCorp | Hard-working OR prof can teach you risk analysis. See his tutorial. | com | **** | **** |
| Octavian Micro Development Inc. | Engineering add-ins: image & signal processing, matrices, unit conversion, chemistry. | com | **** | *** |
| Emagenit | For sale: add-ins, training, consulting. | com | *** | **** |
| Windmill Software Ltd | Control lab instruments & get real-time data into Excel. Nice site! | com | *** | **** |
| Decisioneering - Crystal Ball 2000 | Another serious tool for managing risk. | com | *** | **** |
| Applied Decision Analysis - PriceWaterhouseCoopers | Decision tree software. | com | *** | **** |
| Decision Models - The Excel Calculation Site | A smart consultant. Interesting add-in speeds up Excel's recalculation. | com | *** | *** |
| Edwin Tam's Home Page | An add-in that does everything except make lunch. | com | *** | *** |
| BizOffice MS Office Excel Software | Some add-ins for sale, Gantt, math, budgets, images, fonts. | com | *** | *** |
| Drillingsoftware | Spreadsheets to help drill for oil. | com | *** | *** |
| Spinnaker Software Solutions | Highly-rated shareware add-ins. | com | *** | ** |
| Save time and make Excel Easier To Use | Spreadsheet Detective, other add-ins and stuff to buy. | com | *** | ** |
| Rodney Carr's home page | Academic with spreadsheets and training to download: statistics, math, genetics, student grade book. Low powered free, high powered dear. | edu | *** | ** |
| Spreadsheet Consulting & Design | 1-2-3 macros, spreadsheet repair, password removal. | com | *** | ** |
| Softbase Software Information | List of spreadsheet-related software. Frightening HTML style. | com | *** | 0 |
| Spreadsheet World | Consultant. Retrieve corrupt Lotus files, Lotus tips, password cracker. | com | ** | **** |
| Analyse-it! | Statistical add-in. Free trial version. Scientific links. | com | ** | **** |
| exForecaster | Forecasting add-in. | com | ** | **** |
| Spredgar Software | Use Excel to process data from any EDGAR-based quarterly filing or annual report. | com | ** | **** |
| Tech Vision | Add-in converts paper forms to Excel. | com | ** | **** |
| ZDNet Downloads | Shareware business plans, statistics, loans. | com | ** | *** |
| Synkronizer | Compare spreadsheets. Synchronize to databases. | com | ** | *** |
| MapLand | Maps for Excel. | com | ** | *** |
| Light Blue Computers | Ticker and highlighting for Excel. | com | ** | *** |
| Excel 2000 Print On-Demand Computer Courseware | Excel training for sale. Free quick reference. | com | ** | *** |
| Adarus - All You Need Is A Good Idea! | High-rated add-in to help write a business plan. | com | ** | *** |
| ANM, Pliable Display Technology, Visual Decisions | A couple add-ins for sale: engineering conversions, highlighter/magnifier. | com | ** | *** |
| Spreadsheet Change Management System | Add-in to help track changes. | com | ** | **** |
| SPC Orchestra | Statistical process control in a spreadsheet. | com | ** | ** |
| Professional's Guide to Robust Spreadsheets | Book ad. Preview of 2 chapters. | com | ** | ** |
| ChemSheet | Thermodynamic calculations. Free "light" version. | edu | ** | ** |
| Simple and QUALITY Spreadsheets | Invoices, expenses, time billing, budgets. | com | ** | ** |
| BUSINESS SPREADSHEET SYSTEMS LIMITED | Consultants. They buy spreadsheets, too. | com | ** | ** |
| MaKro Consulting, XLhelp.com | Spreadsheet consultant selling a white noise CD. | com | ** | ** |
| Welcome to the Excel Homepage of Fred Ernst | Pay-for add-ins for extrapolation, interpolation, civil engineering. | nam | ** | ** |
| Technical Analysis Software | Analysis and charts for securities traders. | com | ** | * |
| Sam Reheb's Microsoft Excel Web Site | Strange blend - sending spam, credit cards, scheduling, more. | com | ** | * |
| JEM 97 or JEM 2000 | Add-in that is supposed to make Excel easier. | com | * | **** |
| Visual OLAP | Use wizards to get data from databases into Excel. | com | * | **** |
| ZDCalc | Estate planning. | com | * | **** |
| www.lostpassword.com | Don't believe you can password protect anything. | com | * | **** |
| SQL*XL | Consultants. Software to connect Excel to Oracle. | com | * | *** |
| Statistics for Business and Industry | Consultants in statistics, with book on Statistica. | com | * | *** |
| EXCELRECOVERY | Program to recover corrupt Excel files. | com | * | *** |
| Lost in your spreadsheet? miner3d.excel!!! | Add-ins for data mining in Excel and Access. | com | * | *** |
| Grab It! Graph Digitizer | Convert a graphic to numbers in Excel. | com | * | *** |
| ES Quote$ | Get real time stock quotes in Excel. | com | * | *** |
| PlanningTemplates | Calculate net worth, retirement, mortgage. | com | * | *** |
| ExcelFix | Recover a corrupt spreadsheet. | com | * | *** |
| Spreadsheets for Plant Design | Templates to size pipes, calculate manifold pressure. Free centrifugal pump datasheet. | com | * | *** |
| Ask MrExcel Consulting | Hey, how 'bout some tips? | com | * | *** |
| The Excel Sheet Magazine | Tips you can buy. | com | * | *** |
| Promised Land Technologies, Inc. | "Braincel" add-in for neural networks. | com | * | *** |
| EZ-XML Wizard | Utility for ODBC-to-XML and XML-to-Excel. | com | * | *** |
| Vital News Excel Tips | Tips you can buy. | com | * | *** |
| Concept Data | Program to recover corrupt Excel files. | com | * | *** |
| Distributed Spreadsheet | Add-in to help share and consolidate spreadsheets. | com | * | *** |
| Base2 Consulting, Inc. | Developers for MS Office applications. | com | * | *** |
| Bentz Engineering, LLC | 3-D graphing tool. Free trial version. | com | * | *** |
| Turedata | Consultant with a few tips. | com | * | *** |
| Beside Software | Software to help import data. | com | * | *** |
| Excel 2000 Tutorial | Tutorial for sale. | com | * | ** |
| Advisor Software Style Spreadsheet | Use Excel to select securities. | com | * | ** |
| Welcome Gye Software | Add-in connects Excel to the serial port. | com | * | ** |
| BitStar | Add-in for neural networks. Free ant colony! | com | * | * |
| Mathematical Programming Services | Look elsewhere for something useful. | com | * | 0 |
| Angoss Knowledge Engineering | Data mining add-in for sale. | com | 0 | **** |
| Excel Magic | Spreadsheet-writers. | com | 0 | *** |
| Lerman Associates | High-rated consultant with site under construction. | com | 0 | *** |
| edWIN Consulting, Inc. | Consulting firm. | com | 0 | ** |
| SDA Group, Spreadsheet Design and Analysis | Consulting firm. | com | 0 | 0 |
| Welcome to Certified Computer Services | How Not To Make A Web Site. | com | 0 | 0 |
| "Spreadsheet Modeling & Decision Analysis," Ragsdale | Book ad, respected spreadsheet author. | com | NA | NA |
| Link | Review | Type | Content | Style |
|---|---|---|---|---|
| Microsoft's MVPs | Links to consultants - Microsoft's darlings. | com | **** | **** |
| JWalk & Associates, "The Spreadsheet Page" - Excel link; | A repeat. His links deserve their own mention. | com | **** | **** |
| Mathtools.net > Excel | Well-organized long list of spreadsheets and add-ins, some free. | com | **** | **** |
| Assoc. of Statistics Specialists Using MS Excel | Links to statistical stuff. | com | **** | **** |
| Computer Modelling | Ball in motion, chaos (cool!), chemical titration, data sampling, liquid to solid, weather. | gov | **** | **** |
| Mindtools Spreadsheet Resources | Nice links to spreadsheet resources. | com | *** | *** |
| Excel Tips | A few basic but important concepts. | edu | *** | *** |
| Spreadsheets, Mathematics, Science, and Statistics Education | Many interesting links. | edu | *** | *** |
| Online Spreadsheet Tutorials | Links to tutorials. | edu | *** | *** |
| PlanningObjects | Links to disturbing articles about errors. | com | *** | ** |
| Software - Teaching materials for OR/MS | Links for OR. | edu | ** | * |
| Link | Review | Type | Content | Style |
|---|---|---|---|---|
| John's Finance Page | Excellent site, lots of financial models. | com | **** | **** |
| Borrower.com | Free spreadsheets for loans & trust deeds. | com | **** | **** |
| Spreadsheet Programs | A long list of sophisticated financial models. | edu | *** | **** |
| Downloadable Spreadsheets Available From the Beef Focus Team | Manage your cattle with spreadsheets. | edu | *** | **** |
| The Simtel.Net Windows 95 Collection | About a dozen free Excel-related files, & a lot of other stuff. | edu | *** | *** |
| Simon Benninga | Using Excel for finance. | edu | *** | *** |
| Winsite Excel files | Long list of Excel files and utilities. | com | *** | *** |
| AIM Spreadsheet | AIDS modeling - demography, health, orphans. | com | *** | *** |
| laurencebrundrett.com | ASME VIII Div 1 Pressure Vessel Design Engineering Shareware Spreadsheets. | com | *** | *** |
| The Gantt Tool | Free Excel Gantt chart - for project scheduling. | nam | *** | ** |
| Hotsheets | Cash accounts, time sheets, scheduling, leave, bookkeeping. | com | *** | * |
| The Investment Simulation Spreadsheet | Simulate saving. | edu | ** | **** |
| The Retirement Income Simulation Spreadsheet | Simulate withdrawals. | edu | ** | **** |
| INFO: Gantt Chart Sample Add-In Available for Download | Microsoft's free Excel Gantt chart. | com | ** | **** |
| XL: How to Create a Gantt Chart Using Hours as the Scale | Microsoft, title says it. | com | ** | **** |
| Excel: Creating Gantt Charts | Microsoft, title says it. | com | ** | **** |
| RSD Associates | Use Excel for statistical process control. | com | ** | **** |
| Hyper-Compleat Principles of Leader Design | Do fly fishing better: use Excel to design the leaders. | com | ** | **** |
| Trade Tracker Spreadsheet | Maintain records of investment transactions. | edu | ** | *** |
| Spreadsheet/Planner to Track Exchanges and Recipes | Recipe management. | edu | ** | *** |
| SETI Spreadsheet Templates | Improving your star ship's sensors. | org | ** | *** |
| XYFIT | Add-in for fourier analysis and curve fitting. But awesome non-Excel financial links! | com | ** | *** |
| Time and Attendance Spreadsheet | Maintain employee records. | edu | ** | *** |
| Logistic Growth, Temporal Variation, and Chaos | Write a logistic growth model in Excel. | edu | ** | *** |
| FREE SPREADSHEETS | Golf scores, accounting. | com | ** | ** |
| Excel Trading Oriented Products & Services | Charts for securities traders. | com | ** | ** |
| Tattsoft Spreadsheet Productions | Invoices, cash flow, fixed asset register, library keeper. | com | ** | ** |
| Spreadsheet Download from "Engineering Sign Structures" | Designing free-standing signs. | com | ** | ** |
| Spreadsheet Modelling by B M Baker | A few OR spreadsheet models. | edu | ** | ** |
| Glaze Unity Spreadsheet | Getting the glaze right on your clay pot. | com | ** | ** |
| Wafer Cost Spreadsheet | Assessing productivity of semiconductor fabrication | edu | ** | ** |
| Economic Evaluation of Dairy Feeds: Using the FEEDVAL Spreadsheet | Estimating costs for cattle feed | edu | ** | ** |
| Exl-Plan | Make budgets for a company. | com | ** | ** |
| Spreadsheet for Recipe Design | How to brew beer. | com | ** | ** |
| Mike Lachowski's R/C Soaring Page | Design a remote-controlled airplane. | nam | ** | ** |
| Spreadsheet Templates | Agricultural spreadsheets. | edu | * | *** |
| WebPageConsultant.net. | Consultant. Free sheet to calculate automobile mileage. | com | * | ** |
| LambFeed$--Lamb Feeding Break-even Spreadsheet | Estimate costs of feeding sheep | edu | * | * |
| Excel Spreadsheet | Musical scales in Excel | com | * | * |
Hey, teachers! Teach your students good spreadsheet style! Tell them about Grace Gridwright.
| Link | Review | Type | Content | Style |
|---|---|---|---|---|
| Welcome to MathsNet | Lovely site, mainly for education. Tutorials, free data. | com | **** | **** |
| The Technology Loop | Excel for schoolkids. | edu | **** | *** |
| Mark's Maths and Excel Homepage | Teacher's Friend for recording marks, VBA code & tutorials, worksheet function examples. | nam | *** | *** |
| Beck's Bits and Bytes | Spreadsheets in grade school. | edu | *** | ** |
| Chichester High School - Lesson Plans | Spreadsheets in grade school. | edu | ** | **** |
| Spreadsheets, Suggestions for 3-5, Making and Using Spreadsheets | Spreadsheets in grade school. But please quit pie charts! | edu | ** | **** |
| Education at the Museum - Dinosaur data files | Dino data in Excel! | edu | * | **** |
| Spreadsheet - A Variety of Activities! | How to use spreadsheets for kids. Cute typos! | edu | * | *** |
| Produce a never-ending supply of Maths questions | Title says it. For schoolkids. | edu | * | ** |
| Suzanne Alejandre Spreadsheet Lessons | How to make a graph for 8-year-olds. | edu | * | ** |
| Spreadsheet resources. | Teach kids how to add. | edu | * | * |
| Link | Review | Type | Content | Style |
|---|---|---|---|---|
| Tom Grossman's Web Site | A top academic in modeling, with a special interest in spreadsheets. Articles and cases on modeling, links to management science resources. | edu | **** | **** |
| Spreadsheet Research Interest Group | Management scientists and academics studying spreadsheet problems. An INFORMS group on Tom Grossman's site. | edu | **** | **** |
| Raymond R. Panko | The authority on spreadsheet error. Sobering. Highly recommended. | edu | **** | *** |
| Welcome to SSR | In case you missed the link inside Panko's site. This is important. | edu | **** | *** |
| European Spreadsheet Risks Interest Group | Accountants and academics studying spreadsheet problems. | org | **** | *** |
| Are Two Heads Better than One (At Reducing Spreadsheet Errors)? | Panko article on a Baylor web site. Scary. | edu | **** | *** |
| A Review and Research Agenda for Spreadsheet Based Systems | More on problems with spreadsheets, by two good researchers. (Disclosure: one author is my colleague.) | edu | **** | *** |
| Dr. Ed Huai-hsin Chi | Academic studying visualization with spreadsheets. | edu | **** | *** |
| Research on Integrity Control of Spreadsheet Models | PhD student studying spreadsheet error. Good PDF articles about error. | edu | **** | ** |
| Spreadsheet User Journal | Academic journal about spreadsheets | edu | *** | **** |
| passat.wasa.shh.fi-redovisning-spreadsh.htm | Print references on spreadsheets. | edu | ** | *** |
| Spreadsheet Jokes | God Bless Walkenbach. | com | ** | **** |
| Modeling Spreadsheet Audit...Visualization | New type of spreadsheet, academic. | com | * | *** |
| Link | Review | Type | Content | Style |
|---|---|---|---|---|
| Tips & Tricks för Ms Excel & programmering | A Swedish site devoted to functions. | com | - | **** |
| Herbers Excel-Server | Large German site, a Microsoft MVP. | com | - | **** |
| MacHero Excel/Works Homepage | Large German site. | com | - | *** |
| Willkommen in EXCEL-Forum | Large German site, tips, freeware, shareware. | com | - | * |
Hey, Grace, how do you make your ratings? "Well, boss, first I look for a clean site without a lot of unneeded colors or graphics. Chartreuse or purple make me see red. Then I look for what they've got! If it's only one add-in, even if it's a great one, they might just get one star." Wow, kind of harsh! "I don't mean to be harsh, boss, but we need to give our customers the best possible information."
Hey, Grace, looking at all these links is boring me to death.