Business Spreadsheets

In the early 1980s spreadsheets emerged as a serious business tool on the PC. Microsoft® Excel became available in 1987.

I've worked using Excel on most days in the years since then.

I want to hand on what I've learnt in the hope you might find something useful for improving your spreadsheet productivity.

Last updated on 2024-10-11.

Issues with Spreadsheets

The majority of spreadsheets I've recieved from clients over the decades suffered from impaired accurac, and from inefficiency and difficulty in use due to such shortcomings as these:

• Difficult to amend
• Much more complicated than they need to be
• Yield suspicious results
• No built-in checks for errors
• Contain faulty formulae
• Contain formulae that aren't understood
• Never have been tested properly
• Contain macros that worked when recorded, but not now
• Contain macros nobody understands.

Please email me any ideas you have about what topics I could add to EXCEL TIPS.