up vote 1 down vote favorite
share [g+] share [fb]

Is there a good book out there on how to do bigger projects in Excel?

link|improve this question
61% accept rate
It might help if you gave more info on what kind of projects. Would it specifically be accounting, or data tracking, or what? Usually the more complicated topics will have specific books just for them. – Joshua Nurczyk Oct 7 '09 at 12:36
Well just any project would do, just so it is not a toolparade for Excel (Biblestyle) but instead you follow a bigger project all along. – Chris_45 Oct 7 '09 at 12:59
Speaking as a software developer, the idea of doing a large project in Excel frightens me. I'd rather stick to a more conventional and manageable programming language, where, for example, version control is easy. – David Thornley Oct 7 '09 at 16:13
feedback

1 Answer

up vote 0 down vote accepted

Professional Excel Development is an excellent guide to moving beyond using Excel as a glorified calculator.

It uses the same system as an example throughout the book, moving from a simple spreadsheet through UDFs, add-ins, charting, interfaces, classes, database integration all the way to API calls, XLLs and manipulation via .net languages. The 2nd edition in particular expands on the .net aspects, but other than that is basically the same as the first edition.

link|improve this answer
Ok, great thanks! – Chris_45 Oct 7 '09 at 15:19
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.