Office Software

A bioinformatician quickly reaches the limits of Microsoft Office when working on large datasets. But since Microsoft Office is ubiquitous on corporate computers, the bioinformatician will often encounter Excel workbooks that contain critical data coming from the experimentalists. And, of course, the bioinformatician will be required to use Word for generating reports and PowerPoint for presentations.

Publisher’s information Comments
Excel 2003 Power Programming with VBA
by John Walkenbach
2004
ISBN 0-7645-4072-6
Wiley

This book is designed for beginning programmers who want to learn how to create more powerful Excel spreadsheets using VBA.

The book provides background on the various versions of Excel, an overview of developing Excel-based applications, a tutorial on Visual Basic for Applications (VBA), a tutorial on UserForms for creating custom dialog boxes, advanced programming techniques, creating user-oriented applications, some miscellaneous topics, and a set of appendixes. The book contains a CD-ROM with examples of files and applications and a 30-day trial version of Walkenbach’s Power Utility Pak.

Walkenbach is a clear, knowledgeable writer, and the material presented here will keep you busy for many months. The index was produced by professional indexers and is therefore very useful. The figures and code are clear, and I haven’t found any typographical errors yet.

Professional Excel Development
by Stephen Bullen, Rob Bovey, and John Green
April 2005
ISBN 0-321-26250-6
Addison-Wesley
This book is aimed towards professional programmers who need to create an Excel application using Visual Basic for Applications (VBA). The book comes with a CD-ROM that contains the sample application developed in the book, code examples, and development utilities.