Excel Books - Programming | General Excel Books
| Access | Office
Excel Books, by Category
The following list includes Excel books and other Office books that
I own and have used while working on Microsoft Office projects.
Click on a link to go to the Amazon.com site. I earn a small commission
if you purchase products on Amazon through links on this site.
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.
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
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
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
Last updated: March 11, 2021 2:34 PM
Contextures RSS Feed