Self-Help Books from Cengage Learning PTR

Microsoft® Excel® VBA Programming for the Absolute Beginner

Microsoft® Excel® VBA Programming for the Absolute Beginner

ISBN 13: 9781598633948

ISBN 10: 1598633945

Author: Duane Birnbaum; Michael Vine

Pages: 400

Published: 06/08/2007

Print Book Price: $29.99 Add to cart

eBook Price: $20.99 Add to cart

eBook Download Instructions

Companion downloads

If you are new to programming with Microsoft Excel VBA and are looking for a solid introduction, this is the book for you. Developed by computer science professors, books in the "for the absolute beginner" series teach the principles of programming through simple game creation. Microsoft Excel VBA Programming for the Absolute Beginner, Third Edition provides you with the skills that you need for more practical Excel VBA programming applications and shows you how to put these skills to use in real-world scenarios. Best of all, by the time you finish the book, you will be able to apply the basic principles you've learned to the next programming language you tackle.
Note*: If you are buying the e-book version of this product, any CD/DVD supplement files referenced throughout the book can be accessed for free at our Companion Downloads page.
  • No previous Excel or programming experience is required.
  • The book has been fully updated to cover the current version of Excel 2007.
  • Teaches programming techniques the fun way ? through simple, game-based programs that run in Excel.
  • Teaches you to write useful applications for data analysis in Excel including Workbooks, Worksheets, Ranges, Formulas, Charts, Menus and Toolbars, and MS Access Databases.
  • Companion website available here:
Author Bio
Duane Birnbaum
Duane Birnbaum began programming in graduate school, where he wrote custom software for interfacing the various electronic devices require for his experiments and analyzing the data obtained from them. Since completing his Ph.D. in physical chemistry, he has worked in academia and the biotech industry while continually teaching on a part-time basis. He has been serving as a part-time lecturer in computer science at Indiana University/Purdue University Indianapolis for seven years teaching courses in programming, data analysis, and database design.
Michael Vine
Michael Vine is a senior IT professional who specializes in data warehousing and business intelligence. Beyond corporate life, he has taught computer science classes at the university and college level and authored many software programming books.
cover image - Microsoft® Excel® VBA Programming for the Absolute Beginner
Table of Contents
Chapter 1 - Visual Basic for Applications with Excel
Chapter 2 - Beginning Programs with VBA
Chapter 3 - Procedures and Conditions
Chapter 4 - Loops and Arrays
Chapter 5 - Basic Excel Objects
Chapter 6 - Enhancing VBA Programs: Adding Multimedia and Intelligence
Chapter 7 - UserForms and Additional Controls
Chapter 8 - Data Access, File I/O, Error Handling, and Debugging
Chapter 9 - Excel Charts
Chapter 10 - VBA Shapes