I keep wondering about writing a book about Excel development.
It would be less technical than PED, perhaps a bit more like Code Complete for Excel. A bit more design based than code based. The target audience would be business folks wanting to improve their Excel clicking and IT folks needing to target Excel. It would be set in the context of the reality of working with Excel in big companies.
I did discuss it with a publisher a while ago, but at this stage I would probably do it as a self publish e-book, with maybe a print option.
It would be based on my couple of weeks Excel experience (cataloguing my CD collection), and would touch many complementary technologies like ADO, ExcelDNA, XLL+.
I’m thinking more of a 300 page wordy tome rather than a 1000 page screenshot fest.
The sort of chapters might be something like
- strengths and weaknesses of Excel
- The RAD process with Excel as the client
- Excel dev models (workbook with VBA, Add-in etc)
- Excel grid best practices
- Excel facts and fallacies
The only thing stopping me is the apparent death of Excel as a serious business tool. I’d hate to invest all that effort and then find my mum is the only person willing to buy it. (Well, her and as an excellent stocking filler for my kids at Christmas (not this one of course!)).
There is no doubt in my mind that sensible use of Excel is good in every way for most organisations. Sadly its the bad use that is most common and gets all the bad press. One aim of the book would be to propose some of the smart ways of using Excel (including using some of the newer features).
So my question is:
If there were such a book do you think there would be a market for it? Do you know people who would buy it?
(I know, that’s two questions)