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.
|
Latest Read |
|
|||
|
Excel |
|||
![]() |
Excel 2013 Step by Step
|
|||
![]() |
Excel 2013 Plain & Simple
|
|||
![]() |
Excel 2013 The Missing Manual
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
Explores Power Pivot from an Excels user perspective
|
|||
![]() |
Building Data Models with PowerPivot
Explains the new Power Pivot feature in Excel |
|||
|
||||
![]() |
The Excel Analyst's Guide to Access
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 (Step by Step (Microsoft))
This books is very reminiscent of the manuals that used to
come with Excel back in the day.
|
|||
|
||||
![]() |
Head First Excel: A learner's guide to spreadsheets |
|||
![]() |
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)
This is the 2nd edition of the must have book for serious
developers.
|
|||
![]() |
Excel-Basics-Blackbelt
|
|||
![]() |
RibbonX: Customizing the Office 2007 Ribbon
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
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
|
|||
![]() |
Pro Excel 2007 VBA (Pro)
|
|||
![]() |
Excel 2007 VBA Programmer's Reference (Programmer to Programmer)
|
|||
![]() |
Learn Excel from Mr Excel: 277 Excel Mysteries Solved
|
|||
![]() |
Guerilla Data Analysis Using Microsoft Excel
|
|||
![]() |
VSTO for Mere Mortals: A VBA Developer's Guide to Microsoft Office Development Using Visual Studio 2005 Tools for Office
|
|||
|
Professional Excel Development: The Definitive Guide to
Developing Applications Using Microsoft Excel and VBA
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.
|
|||
|
Programming Excel with VBA and .NET
|
|||
|
Integrating Excel and Access
|
|||
|
VB and VBA in a Nutshell
|
|||
|
Excel Charts
One of the first books
dedicated to the topic of charts.
|
|||
|
The Spreadsheet at 25: 25 Amazing Excel Examples That
Evolved from the Invention That Changed the World
|
|||
|
Analyzing Business Data with Excel
|
|||
|
Beginning Excel What-if Data Analysis Tools: Getting Strated
with Goal Seek, Data Tables, Scenarios, and Solver
I was the Technical Reveiwer on this book. |
|||
|
Visual Studio Tools for Office: Using VB.Net with Excel,
Word, Outlook,and Infopath
|
|||
|
Excel Pivottables Recipe Book: A Problem Solving Approach
|
|||
|
Excel 2000 VBA Programmer's Reference
|
|||
|
A Complete Guide to Pivot Tables: A Visual Approach
I was the Technical Reveiwer on this book.
|
|||
|
Excel Hacks: 100 Industrial Strength Tips and Tools
I contributed a chapter on charting tips
|
|||
|
Formulas and Functions with Microsoft Excel 2003
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
|
|||
![]() |
This isn't Excel, it's Magic!
|
|||
![]() |
Microsoft® Access Version 2002 Inside Out
|
|||
Chart Design |
||||
|
the functional art
|
|||
|
Creating More Effective Graphs
|
|||
|
Show Me the Numbers: Designing Tables and Graphs to
Enlighten
|
|||
|
Information Dashboard Design
|
|||
![]() |
Excel 2007 Dashboards and Reports for Dummies
|
|||
![]() |
The Visual Display of Quantitative Information
|
|||
![]() |
Visual Thinking: For Design
|
|||
|
.Net |
|||
|
Programming Excel with VBA and .NET
|
|||
|
Programming ASP.NET
|
|||
|
ASP.NET 2.0 Cookbook
|
|||
|
Learning C# 2005, Second Edition
|
|||
|
Visual Basic 2005 in a Nutshell
|
|||
|
Programming Visual Basic
|
|||
|
Visual Basic.NET Core Reference
|
|||
|
MS.Net Development for MS Office
|
|||
|
Visual Basic.NET Step by Step 2003
|
|||
|
Visual Basic.NET Class Design Handbook: Coding Effective
Classes
|
|||
|
ASP.NET Web Matrix Starter Kit
|
|||
|
ASP.NET Programming with Visual C#.NET Step by Step 2003
|
|||
|
Introducing ASP.NET 2.0
|
|||
|
SQL |
|||
|
Learning SQL on SQL Server 2005
|
|||
|
SQL Cookbook
|
|||
|
Windows Server 2003 Security Cookbook
|
|||
|
Programming SQL Server 2005
|
|||
|
Learning MySQL (Learning)
|
|||
|
Programming |
|||
![]() |
HTML, XHTML and CSS All in One for Dummies
|
|||
![]() |
HTML 5
|
|||
![]() |
Getting started with D3
|
|||
![]() |
Interactive Data Visualization for the web |
|||
![]() |
Javascript
|
|||
![]() |
Supercharged Javascript Graphics |
|||
![]() |
Head First C# |
|||
![]() |
Head First Object-oriented Analysis and Design
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
|
|||
|
Extreme Programming in Practice (XP S.)
|
|||
|
Javascript for the World Wide Web (Visual QuickStart Guides)
|
|||
|
Object-oriented Software Construction
|
|||
|
Ado.Net and System XML V. 2.0: The Beta Version
|
|||
|
Computational Geometry in C
|
|||
|
.NET XML Web Services Step by Step
|
|||
|
Beginning Visual Basic 6 Objects
|
|||
|
Visual Basic Graphics Programming
|
|||
|
Visual Basic Algorithms
|
|||
|
Professional VB6 Web Programming
|
|||
|
Dan Appleman Visual Basic Programmer's Guide to the Win32
API
|
|||
|
Teach Yourself More Java 1.1 in 21 Days
|
|||
|
Cascading Style Sheets: The Definitive Guide
|
|||
|
Professional Visual Basic 6 XML
|
|||
|
ADO Programmer's Reference
|
|||
|
Monad: An Administrator's Guide
|
|||
|
Windows Server |
|||
|
Learning Windows Server 2003
|
|||
|
Introducing Microsoft Windows Server 2003
|
|||
|
Linux |
|||
|
Linux for Dummies
|
|||
|
Sharepoint Services |
|||
|
Microsoft Windows Sharepoint Services Step by Step
|
|||
|
Windows Vista |
|||
|
Windows Vista the Missing Manual
An informative read.
David's style of writing makes for easy reading.
|
|||
![]() |
Windows Vista in a Nutshell
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.
|
|||
|
XAML |
|||
|
XAML in a Nutshell
|
|||
Last updated 6th October 2013