My Library
Listed in no particular order, these are the books that I own and use whilst doing my daily work.
When it comes to technical books I read, or sometimes just scan, through them when first recieved.
There after I refer back to to them as and when a relevant problem arises.
![](Site_Images/nav_openonly.png)
Excel
Excel 2013 The Missing Manual![](http://ir-uk.amazon-adsystem.com/e/ir?t=ajpexcelinfor-21&l=ur2&o=2)
by
Matthew MacDonald
Does exactly what is says on the cover. It replaces the manual that is no longer supplied with the software.
Building Data Models with PowerPivot
![](http://www.assoc-amazon.co.uk/e/ir?t=ajpexcelinfor-21&l=as2&o=2&a=0321508793)
by
Michael Alexander
An very interesting and thought provoking look at using Access to supplement and extend your data analysis skills. I enjoyed Michael's style of writing and his approach to the subject matter.
Microsoft Excel 2010 Step by Step
![](http://www.assoc-amazon.co.uk/e/ir?t=ajpexcelinfor-21&l=as2&o=2&a=0735626944)
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
![](http://www.assoc-amazon.co.uk/e/ir?t=ajpexcelinfor-21&l=as2&o=2&a=0596807694)
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
![](http://www.assoc-amazon.co.uk/e/ir?t=ajpexcelinfor-21&l=as2&o=2&a=0321508793)
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
![](http://www.assoc-amazon.co.uk/e/ir?t=ajpexcelinfor-21&l=ur2&o=2)
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
![](http://www.assoc-amazon.co.uk/e/ir?t=ajpexcelinfor-21&l=ur2&o=2)
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.
VSTO for Mere Mortals: A VBA Developer's Guide to Microsoft Office Development Using Visual Studio 2005 Tools for Office
![](http://www.assoc-amazon.co.uk/e/ir?t=ajpexcelinfor-21&l=ur2&o=2)
by
Kathleen McGrath, Paul Stubbs
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA
![](http://www.assoc-amazon.co.uk/e/ir?t=ajpexcelinfor-21&l=ur2&o=2)
by
Stephen Bullen, Rob Bovey, John Green
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!
Excel Charts
![](http://www.assoc-amazon.co.uk/e/ir?t=ajpexcelinfor-21&l=ur2&o=2)
by
by John Walkenbach
One of the first books dedicated to the topic of charts.
My 3d scatter example was mentioned in this book.
Excel Hacks: 100 Industrial Strength Tips and Tools
![](http://www.assoc-amazon.co.uk/e/ir?t=ajpexcelinfor-21&l=ur2&o=2)
by
David Hawley and Raina Hawley
![](Site_Images/nav_openonly.png)
Chart design
![](Site_Images/nav_openonly.png)
.Net programming
Head First C#
![](http://www.assoc-amazon.co.uk/e/ir?t=ajpexcelinfor-21&l=ur2&o=2)
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.
![](Site_Images/nav_openonly.png)
SQL
![](Site_Images/nav_openonly.png)
Programming HTML, javascript, Visual Basic and other languages
![](Site_Images/nav_openonly.png)
Coding practices
![](Site_Images/nav_openonly.png)
Windows server
![](Site_Images/nav_openonly.png)
Linux
![](Site_Images/nav_openonly.png)
Sharepoint Services
![](Site_Images/nav_openonly.png)
Windows Vista
![](Site_Images/nav_openonly.png)
XAML
Created August 2004
Last updated 28th March 2015