Beginning Excel 2007 VBA: From Novice to Professional

by Staneke, Tom Alexander

• ISBN13: 9781590598863
• ISBN10: 1590598865
• Format: Paperback
• Copyright: 2008-04-22
• Publisher: Springer-Verlag New York Inc

Summary

Advanced Excel users will take a step higher with Beginning Excel 2007 VBA: From Novice to Professional by walking through practical, work-environment uses of Excel to discover all the advantages of VBA programming. Youve no need for previous programming experience or knowledge of VBA, and author Tom Staneke will advise you on where VBA is most, and least, useful to use. Teaches professional Excel users the advantages of VBA programming Does not assume prior programming experience Focuses on practical, work-environment uses of Excel What youll learn Learn how to work with directories, workbooks, worksheets, ranges, and cells in a flexible way. Discover alternatives to PivotTables. Master debugging, error handling, and logging. Learn how to create and use user forms. Become skilled at collaboration with other programs (Notes, etc.). Learn how to manipulate VBA modules. Who is this book for? This book is for professional Excel users who wish to take their expertise to the next level through basic VBA programming. About the Apress Beginning Series The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from "novice to professional." Youll start your journey by seeing what you need to knowbut without needless theory and filler. Youll build your skill set by learning how to put together real-world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you thereit is your trusted guide through unfamiliar territory Related Titles from Apress Beginning SharePoint with Excel: From Novice to Professional Excel 2007: Beyond the Manual Excel as Your Database A Complete Guide to Pivot Tables: A Visual Approach Definitive Guide to Excel VBA , Second Edition Beginning Excel What-If Data Analysis Tools: Getting Started with Goal Seek, Data Tables, Scenarios, and Solver