AJP Excel InformationAJP Excel Information
ChartsVBAFun stuffForumsTipsLinksBooksWhat's newContactAboutSearchRSS Feed


Reference Books

This is a list of the books that I own and use whilst working. They are listed in no particular order.
When it comes to technical books I read, or sometimes just scan, through when I first get them. There after I  refer back to to them as and when a relevant problem arises.

As and when I get time I will attempt to add a summary to each title.
(In some cases this will mean me having re read in order to refresh my memory)

Latest Read




Excel Step by Step 2013   
Excel 2013 Step by Step
by Curtis Frye

Excel Plain & Simple 2013   
Excel 2013 Plain & Simple
by Curtis Frye

Excel 2013 The Missing Manual   
Excel 2013 The Missing Manual
by Matthew MacDonald
Does exactly what is says on the cover. It replaces the manual that is no longer supplied with the software.

PowerPivot for the Data Analyst   
PowerPivot for the Data Analyst
by Bill Jellen
Explores Power Pivot from an Excels user perspective

Excel 2013 Building Data Models with PowerPivot   
Building Data Models with PowerPivot
by Alberto Ferrari and Marco Russo
Explains the new Power Pivot feature in Excel
The Excel Analyst's Guide to Access   
The Excel Analyst's Guide to Access
by Michael Alexander
An very interesting and thought provoking look at using Access to supplement and extend your data analysis skills. I enjoy Michael's writing style and his approach to the subject matter.

Microsoft Excel 2010 Step by Step  
Microsoft Excel 2010 Step by Step (Step by Step (Microsoft))
by Curtis Frye
This books is very reminiscent of the manuals that used to come with Excel back in the day.
It covers all the aspects of the software and its features, which makes this an excellent choice for those not familiar with Excel. It could also be of help to those users who are wary of upgrading to the new ribbon interface in the latest versions of Excel.
Head First Excel: A learner's guide to spreadsheets
by Michael Milton
I am a big fan of the Head First series of books. The approach this series of books takes does indeed make it easier to absorb information about complex subjects. This edition is no different although the Excel level is beginners. If you are new to Excel this is a good introduction to the approaches of  using Excel.

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET: The Definitive Guide to ... and VBA (Addison-Wesley Microsoft Technology)
by Rob Bovey, Dennis Wallentin, Stephen Bullen, John Green
This is the 2nd edition of the must have book for serious developers.
The new content on the ribbon and .net have only reinforced it's place as 'the' book for developers. 

Excel-Basics-Blackbelt :An Accelerated Guide to Decision Support Designs
by Elliot Bendoly
This is an excel book aimed at those who are creating Decision support systems.
It covers advanced topics such as Solver and circular referencing.
The book also includes informative chapters on the use of additional, though not free, application MapPoint, RiskOptimiser and XLStat. I could only read the details on these applications as I do not have any of these add-ins. But if you already any of these applications the sections on VBA automation will be of intereset.

RibbonX: Customizing the Office 2007 Ribbon
By Robert Martin, Ken Puls, Teresa Hennig
This is the book to get if you want to get to grips with programming and customizing the Ribbon UI introduced in some of the Office apps in 2007. The book covers Excel, Word and Access ribbon.

Excel 2007 Power Programming with VBA
By John Walkenbach
As always John's style of writing makes the topic accessible to the reader regardless of their level.

Pivot Table Data Crunching for Microsoft Office Excel 2007
By Bill Jelen and Mike Alexander

Pro Excel 2007 VBA (Pro)
By Jim DeMarco

Excel 2007 VBA Programmer's Reference (Programmer to Programmer)
By John Green, Stephen Bullen, Rob Bovey and Mike Alexander

Learn Excel from Mr Excel: 277 Excel Mysteries Solved
By Bill Jelen


Guerilla Data Analysis Using Microsoft Excel
By Bill Jelen

VSTO for Mere Mortals: A VBA Developer's Guide to Microsoft Office Development Using Visual Studio 2005 Tools for Office
by by Kathleen McGrath, Paul Stubbs  

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA
by Stephen Bullen, Rob Bovey, John Green
Here is a review of the book I wrote and posted at Amazon.
"This book is a must have for anybody who is or aspires to be a serious Excel developer.
For me the techniques and methods put forward by this book go from enlightening & new to reassuringly familiar. The authors' writing style and use of an example project makes reading and comprehending the advanced subject matter straightforward.

One word of caution though, reading this book will change the way you work!

I heartily recommend this book."

Programming Excel with VBA and .NET
by J. Webb, Steven Saunders



Integrating Excel and Access
by Michael Schmalz



VB and VBA in a Nutshell
by Paul Lomax



Excel Charts
by John Walkenbach
One of the first books dedicated to the topic of charts.

My 3d scatter example was mentioned in this book.

The Spreadsheet at 25: 25 Amazing Excel Examples That Evolved from the Invention That Changed the World
by Bill Jelen

Analyzing Business Data with Excel
by Gerald Knight



Beginning Excel What-if Data Analysis Tools: Getting Strated with Goal Seek, Data Tables, Scenarios, and Solver
by Paul Cornell
I was the Technical Reveiwer on this book.

Visual Studio Tools for Office: Using VB.Net with Excel, Word, Outlook,and Infopath
by Eric Carter, Eric Lippert


Excel Pivottables Recipe Book: A Problem Solving Approach
by Debra Dalgleish


Excel 2000 VBA Programmer's Reference
by John Green, Stephen Bullen, Felipe Martins



A Complete Guide to Pivot Tables: A Visual Approach
by Paul Cornell
I was the Technical Reveiwer on this book.


Excel Hacks: 100 Industrial Strength Tips and Tools
by David Hawley, Raina Hawley
I contributed a chapter on charting tips


Formulas and Functions with Microsoft Excel 2003
by Paul McFedries
I provided a quote for the front cover of this book.
"Clear, concise and instantly usable. The book's matter-of-fact approach makes the prospect of using complex formulas less daunting."

Developing Windows Solutions with Office 2000 Components and VBA
by Peter G. Aitken


This isn't Excel, it's Magic!
by Bob Umlas

Microsoft® Access Version 2002 Inside Out
by Helen Feddema


Chart Design

the functional art 
the functional art
by Alberto Cairo

Creating More Effective Graphs
by Naomi B. Robbins


Show Me the Numbers: Designing Tables and Graphs to Enlighten
by Stephen Few


Information Dashboard Design
by Stephen Few


Excel 2007 Dashboards and Reports for Dummies
By Mike Alexander


The Visual Display of Quantitative Information
By Edward Tufte


Visual Thinking: For Design
By Colin Ware





Programming Excel with VBA and .NET
by Jeff Webb, Steve Saunders



Programming ASP.NET
by Jesse Liberty, Dan Hurwitz


ASP.NET 2.0 Cookbook
by Michael A. Kittel, Geoffrey T. LeBlond


Learning C# 2005, Second Edition
by Jesse Liberty


Visual Basic 2005 in a Nutshell
by Tim Patrick, Paul Lomax, Ron Petrusha, Steven Roman


Programming Visual Basic
by Jesse Liberty


Visual Basic.NET Core Reference
by Francesco Balena


MS.Net Development for MS Office
by Andrew Whitechapel


Visual Basic.NET Step by Step 2003
by Catapult, Michael Halvorson (Editor)


Visual Basic.NET Class Design Handbook: Coding Effective Classes
by Andy Olsen, Damon Allison, James Speer


ASP.NET Web Matrix Starter Kit
by M. Pope


ASP.NET Programming with Visual C#.NET Step by Step 2003
by Microsoft Press, G.Andrew Duthie (Editor)


Introducing ASP.NET 2.0
by Dino Esposito





Learning SQL on SQL Server 2005
by Sikha Saha Bagui, Richard Walsh Earp


SQL Cookbook
by Anthony Molinaro


Windows Server 2003 Security Cookbook
by Mike Danseglio, Robbie Allen


Programming SQL Server 2005
by Bill Hamilton


Learning MySQL (Learning)
By Seyed Tahaghoghi, Hugh Williams





HTML, XHTML& CSS for Dummies   
HTML, XHTML and CSS All in One for Dummies
By Andy Harris

HTML 5   
By Adam McDaniel

Getting started with D3
By Mike Dewar

Interactive Data Visulalization   
Interactive Data Visualization for the web
By Scott Murray
By Alexei White

Javascript Graphics   
Supercharged Javascript Graphics
By Raffaele Cecco

Head First C#
By Andrew Stellman, Jennifer Greene
I really like 'Head first' style of book writing. Both books I have in the series have managed to deliver by allowing me to understand and detain information in topics that are not well know to me.

Head First Object-oriented Analysis and Design
by Brett D. McLaughlin, Gary Pollice, David West
Do not be put off by the unusual layout of this book. It is intended to aid learning and retention of knowledge. To the most part I think they achieve the desired effect. Although I must admit I could not read for more than 20 minutes at a stretch.
This is a book about methodology so don't expect any Excel related content. The books chosen language is Java, which I do not know how to code in, but even this is not a restriction in understanding the principles.
All in all a surprisingly good read.

Code Complete: A Practical Handbook of Software Construction
by Steve McConnell.

For any serious coder, irrespective of their language, this book is a must.
Every chapter contains pearls of wisdom on how to tackle the whole art of coding.
Whether you code alone or in a team reading this book and implementing the suggestions will improve you as a coder.

Extreme Programming in Practice (XP S.)
by James W. Newkirk, Robert C. Martin


Javascript for the World Wide Web (Visual QuickStart Guides)
by Tom Negrino, Dori Smith


Object-oriented Software Construction
by Bertrand Meyer


Ado.Net and System XML V. 2.0: The Beta Version
by Alex Homer, Dave Sussman, Mark Fussell


Computational Geometry in C
by Joseph O'Rourke


.NET XML Web Services Step by Step
by Adam Freeman, Allen Jones


Beginning Visual Basic 6 Objects
by Peter Wright


Visual Basic Graphics Programming
by Rod Stephens


Visual Basic Algorithms
by Rod Stephens


Professional VB6 Web Programming
by Thearon Willis


Dan Appleman Visual Basic Programmer's Guide to the Win32 API
by Dan Appleman


Teach Yourself More Java 1.1 in 21 Days
by Jerry Ablan, Michael Morrison


Cascading Style Sheets: The Definitive Guide
by Eric Meyer


Professional Visual Basic 6 XML
by James Britt, Teun Duynstee, Teun Duynestee


ADO Programmer's Reference
by Dave Sussman


Monad: An Administrator's Guide
by Andy Oakley




Windows Server

Learning Windows Server 2003
by Jonathan Hassell


Introducing Microsoft Windows Server 2003
by Jerry Honeycutt






Linux for Dummies
by Dee-Ann LeBlanc




Sharepoint Services

Microsoft Windows Sharepoint Services Step by Step
by Olga Londer



Windows Vista

Windows Vista the Missing Manual
by David Pogue
An informative read. David's style of writing makes for easy reading.
The book covers all aspects of the new operating system, detailing the variations between the versions.

Windows Vista in a Nutshell
By Preston Gralla
I found the split format of this book is a great idea. It is more suitable for those readers with a prior knowledge of an Windows OS rather than a novice or newbie.
Experience of a previous OS will help you in identifying the correct section of the book in which to find the detail. Each section covers the information in just the right amount of detail.

When I read Vista the Missing Manual I actually wanted to try out and use Vista, which I will be doing once I receive my new works PC. Where as this book will be the book I actually use day to day to resolve any Vista problems or gaps in my knowledge.




XAML in a Nutshell
by Lori A. MacVittie



Last updated 6th October 2013

  Home | Charts | VBA Code | Fun Stuff
Forum Examples | Tips | Links | What's New | Book List
Contact | About
Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2012 Andy Pope