John Green lives and works in Sydney, Australia, as an independent computer consultant, specializing in Excel and Access. He has 35 years of computing experience, a Chemical Engineering degree, and an MBA.
He wrote his first programs in FORTRAN, took a part in the evolution of specialized planning languages on mainframes and, in the early ‘80s, became interested in spreadsheet systems, including 1-2-3 and Excel.
John established his company, Execuplan Consulting, in 1980, specializing in developing computerbased planning applications and in training. He has led training seminars for software applications and operating systems both in Australia and overseas.
John has had regular columns in a number of Australian magazines and has contributed chapters to a number of books including Excel Expert Solutions and Using Visual Basic for Applications 5. He also co-authored Professional Excel Development with Stephen Bullen and Rob Bovey.
From 1995 to 2005 he was accorded the status of MVP (Most Valuable Professional) by Microsoft for his contributions to the CompuServe Excel forum and MS Internet newsgroups.
John Green contributed the Introduction, Chapters 1–11, 13, 15–17, and 19 to this book.
Stephen Bullen lives in Woodford Green, London, England,
with his partner Clare, daughter Becky, and their dogs, Fluffy and
Charlie. He has two other daughters, Jane and Katie, from his first
Rob Bovey is president of Application Professionals, a
software development company specializing in Microsoft Office,
Visual Basic, and SQL Server applications. He brings many
years’ experience creating financial, accounting, and
executive information systems for corporate users to Application
Professionals. You can visit the Application Professionals web site
Michael Alexander is a Microsoft Certified Application
Developer (MCAD) with more than 14 years’ experience
consulting and developing office solutions. He parlayed his
experience with VBA and VB into a successful consulting practice in
the private sector, developing middleware and reporting solutions
for a wide variety of industries. He currently lives in Frisco,
Texas, where he serves as a Senior Program Manager for a top
technology firm. Michael is the author of several books on
Microsoft Access and Excel, and is the principle behind DataPig
Technologies, where he shares Access and Excel knowledge with the