Please Note: This site’s design is only visible in a graphical browser that supports web standards, but its content is accessible to any browser or Internet device.

Book Reviews

The following books may be useful as further reading. No endorsement of these sites or products is implied.

Scott Mueller’s Upgrading and Repairing PCs - 20th edition

Publisher - Que

Author - Scott Mueller

The brand-new 20th edition of Upgrading and Repairing PCs is better than ever. Mueller's beefed up coverage of the latest hardware innovations and repair techniques, and presents two full hours of DVD video - including a step-by-step video guide to building new PCs from scratch. As always, Mueller presents comprehensive, trustworthy coverage of every PC component: processors, motherboards, buses, BIOS, memory, disk storage, video, audio, I/O, input devices, networking, power supplies, and more. He also presents authoritative coverage of overclocking, cooling, PC diagnostics, testing, and maintenance. It’s a MUST HAVE book for everyone that wants to know more of what is a PC, what technologies are and what will be around in the near future!

Excel 2010 Power Programming with VBA

Publisher - John Wiley & Sons

Author - John Walkenbach

Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel’s capabilities with VBA.

Excel Formulas

Excel 2007 Formulas

Publisher - John Wiley & Sons

Author - John Walkenbach

This book is an excellent resource for learning the tips and techniques about maximizing formulas, one of the most powerful spreadsheet tools. John shows you how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and more with Excel 2007.

Advanced Modelling in Finance

Advanced Modelling in Finance Using Excel and VBA

Publisher - John Wiley & Sons Inc

Author - Mary Jackson and Mike Staunton

This unique book demonstrates that Excel and VBA can play an important role in the explanation and implementation of numerical methods across finance. It takes a comprehensive look at equities, options on equities and options on bonds from the early 1950s to the late 1990s. Each area contains both standard material and more advanced topics.

Advanced Modelling in Finance

Microsoft Office Excel 2007: Data Analysis & Business Modeling

Publisher - Microsoft Press

Author - Wayne L Wilson

This book helps you master the analysis and business modelling techniques that help you transform your data into bottom-line results.

Excel 2007 VBA

Publisher - John Wiley & Sons

Authors - John Green, Stephen Bullen, Rob Bovey and Michael Alexander

This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users.

Professional Outlook 2007 Programming

Publisher - John Wiley & Sons

Authors - Ken Slovak

Explains how to use the many new features of Outlook 2007's object model and offers honest advice from the author on how to deal with common shortcomings and pitfalls of Outlook.

Access 2007 VBA

Access 2007 VBA Programmer's Reference (Programmer to Programmer)

Publisher - John Wiley & Sons

Author - Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Armen Stein

Written for Access 2007 programmers this book provides the tools you need to use Access 2007’s built–in functionality and VBA in order to build more dynamic applications.

Visual Basic 2005 Programmers Reference

Publisher - John Wiley & Sons

Author - Rod Stephens

Visual Basic 2005 adds new features to Visual Basic that make it a more powerful programming language than ever before. This combined tutorial and reference describes VB 2005 from scratch, while also offering in-depth content for more advanced developers. Whether you're looking to learn the latest features of VB 2005 or you want a refresher of easily forgotten details, this book is an ideal resource.

Visual Studio 2005 Tools for Office for Mere Mortals

Publisher - Addison Wesley

Author - Kathleen McGrath and Paul Stubbs

This is for VBA developers who are interested in migrating their skills to the next generation of Office development. Learn all about writing managed code applications with Word 2003, Excel 2003, and Outlook 2003, as well as creating add-ins for the most popular applications in Office 2003 and the 2007 Microsoft Office System. See how to secure and deploy solutions created with VSTO and VSTO 2005 SE.

Office 2003 Programming: Real-World Examples

Publisher - Apress

Author - Ty Anderson

This book is all about a set of independent real-world VB-oriented business applications that utilize, customize, and extend the Microsoft Office applications.

Excel 2003 Power Programming with VBA

Publisher - John Wiley & Sons

Author - John Walkenbach

This is a complete introduction to VBA. The author also shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event–handling applications, and much more.

Professional Access 2000 Programming

Access 2003 VBA Programmer's Reference

Publisher - John Wiley & Sons

Author - Patricia Cardoza, et al

Access 2003 VBA Programmer's Reference provides comprehensive coverage of the use of VBA for building Access applications. The typical reader would be expected to have some experience with VBA programming or attended our training courses. (Note that this book covers both Access 2002 and Access 2003.)

VB SCript Reference

VBScript Programmer's Reference

Publisher - John Wiley & Sons

Author - Adrian KingsleyHughes, Kathie KingsleyHughes, Daniel Read

Sometimes people come on my courses intending to use VB Script as opposed to VBA. I have not used this book but it appears to be a good reference guide. It covers Vista, Windows Server 2003, Internet Explorer, Microsoft PowerShell, and the many developments with the latest version of VBScript.