The following books may be useful as further reading. No endorsement of these products is implied.
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 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.
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.
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 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 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.
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.
