Synopses & Reviews
Written specifically with the beginner in mind, "Microsoft Excel VBA for the Absolute Beginner, Second Edition" is the follow up to the most successful and best selling title in the Absolute Beginner series. The book contains completely updated information written for the current version of Excel, Excel 2003. ?Microsoft Excel VBA for the Absolute Beginner, Second Edition,? is geared towards both students taking introductory programming courses, as well as professionals who frequently use spreadsheets and want to expand their knowledge of the capabilities of Excel by writing their own programs. In recent years, programming has experienced a surge unlike any other technical skill, due to both advancements in technology and the declining cost of computer hardware and software. This boom has created a need for more programmers and this book teaches programming using a very popular software package, making it perfect for new programmers. ?Microsoft Excel VBA for the Absolute Beginner, Second Edition,? uses the Excel VBA language to provide readers with an introduction to programming. Concentrating on introductory programming topics and good programming practices, the book uses the VBA Excel language and the creation of simple games to teach these topics and practices.
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.
This title provides users with the skills they will need to program more practical Excel VBA applications and shows them how to put these skills to use in real-world scenarios.
About the Author
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 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.
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