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.
Excel
Introduction To Manipulating Data Programmatically In Microsoft Excel With VBA
by Darren Cook
An interesting read at the more complex end of VBA usage. It covers the basics of classes and their construction. This e-book is well worth the cost especially as the bonus chapters are now included.
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.
Building Data Models with PowerPivot
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
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.
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
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.
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
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 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
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!
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!
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 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:
by Bill Jelen
Analyzing Business Data with Excel
by Gerald Knight
Beginning Excel What-if Data Analysis Tools:
by Paul Cornell
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
Excel Hacks: 100 Industrial Strength Tips and Tools
by David Hawley and Raina Hawley
Formulas and Functions with Microsoft Excel 2003
by Paul McFedries
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
PowerPivot for the Data Analyst
by Bill Jellen
Microsoft Excel 2013: Building Data Models with PowerPivot (Business Skills)
by Alberto Ferrari and Marco Russo
Chart design
the functional art
by Alberto Cairo
Creating More Effective Graphs
by Naomi B. Robbins
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
.Net programming
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
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.
SQL
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
Programming HTML, javascript, Visual Basic and other languages
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 Visualization for the web
by Scott Murray
Javascript
by Alexei White
Supercharged Javascript Graphics
by Raffaele Cecco
Javascript for the World Wide Web (Visual QuickStart Guides)
by Tom Negrino, Dori Smith
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
Coding practices
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
Object-oriented Software Construction
by Bertrand Meyer
Windows server
Linux
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
XAML in a Nutshell
by Lori A. MacVittie
Created August 2004
Last updated 28th March 2015