Excel and Office books On My Bookshelf

Note: Debra Dalgleish is an Amazon Associate. As an Amazon Associate I earn from qualifying purchases.

Professional Excel Development
by Stephen Bullen, Rob Bovey, John Green
In this excellent resource for intermediate to advanced Excel users, every chapter has practical ideas that will help you design robust applications more quickly and consistently. The Best Practices and Worksheet Design chapters have valuable tips for setting up your workbooks, even if you won't use programming. Advanced users can add to their programming skills, by applying the book's techniques for using API calls, creating add-ins, building custom charts, and many more features. You can work through the book's exercises, using the CD's sample files, to build the sample application. Or skim through the book, and use it as a reference for its advanced topics. Either way, the book will pay for itself many times over.

Excel 2002 VBA Programmers Reference
by John Green, Stephen Bullen, Rob Bovey, Robert Rosenberg
A must-have reference book for any Excel programmer. It includes a VBA primer, information on working with specific objects, and an object model reference.

Excel 2000 Power Programming with VBA
by John Walkenbach
An excellent resource, with sample code for the beginning to advanced programmer. Includes a CD with code from the book, and John's Power Utility Pak (PUP) add-in

Microsoft Excel 2002 Visual Basic for Applications Step by Step
by Reed Jacobson
Excellent introduction to programming in Excel.

Microsoft Excel 2003 Programming Inside Out
by Curtis Frye
Many useful tips, good index, CD with code samples, and eBooks

Definitive Guide to Excel VBA, Second Edition
by Michael Kofler, David Kramer
There's some good information, but the book isn't easy to read.

Excel 2000 Developer's Handbook
by Marion Cottingham
A few useful items, but there are too many pictures, and too much beginner material for a developer's handbook.

General Excel Books

Excel Pivot Tables Recipe Book
by Debra Dalgleish
(This is one of the Excel books that I've written.)
Problem solving tips for working with pivot tables and pivot charts. It assumes you know the basics, and only read the manual when all else fails. It's designed to help you understand the advanced features and options that are available, as you need them, or, occasionally, provide confirmation that pivot tables can't do what you want them to do.

Excel 2002 Formulas
by John Walkenbach
Thorough coverage of Excel's functions, and techniques for creating efficient formulas

Managing Data with Excel
by Conrad Carlberg
Excellent resource if you use Excel to analyze data from external sources, or use databases in Excel. (I was a technical editor on this book)

Excel Charts
by John Walkenbach
All you ever wanted to know (and more) about creating charts in Excel.

Special Edition Using Microsoft Excel 2003
by Patrick Blattner
Thorough coverage of Excel's features, including several chapters on functions.

Business Analysis with Microsoft Excel, second edition
by Conrad Carlberg
Focuses on working with financial data, with several case studies that make the information easier to understand.

Mastering Excel 2000 Premium Edition
by Mindy Martin, Steven Hansen, Beth Klingher
Good coverage of Excel's features, well indexed. CD with utilities and code.

Microsoft Excel Version 2002 Inside Out
by Craig Stinson, Mark Dodge
Good coverage of Excel's features, including a function reference. Easy to read, well indexed.

Accessing and Analyzing Data with Microsoft Excel
by Paul Cornell
Good introduction to working with databases in Excel. CD contains code samples and eBook.

Access Books

Access 2000 Developer Handbook
by Litwin, Getz, Gilbert

Microsoft Office Access 2003 Inside Out
by John Viescas

Designing Relational Database Systems
by Rebecca Riordan

Mastering Microsoft Access 2000 Development
by Alison Balter

Access Cookbook
by Ken Getz, Paul Litwin & Andy Baron

Database Design for Mere Mortals
by Michael Hernandez

Office Books

Microsoft Office 2000 Visual Basic for Applications Fundamentals
by David Boctor

Mastering Microsoft Office 2000 Development
by Microsoft Corporation

Microsoft Office 2000 Visual Basic Programmer's Guide
by Microsoft Corporation

Special Edition Using Microsoft Office 2003
by Ed Bott and Woody Leonhard

Microsoft Office System 2003 Inside Out
by Halvorson and Young

Microsoft VBA Professional Projects
by Taruna Goel and Rachna Chaudhary

Developing Microsoft Office Solutions
by Ken Bluttman

Related Links

Excel Books, by Category