Master VBA automation quickly and easily to get more out of Excel Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This self-paced tutorial explains Excel VBA from the ground up, demonstrating with each advancing lesson how you can increase your productivity. Clear, concise, step-by-step instructions are combined with illustrations, code examples, and downloadable workbooks to give you a practical, in-depth learning experience and results that apply to real-world scenarios.
This is your comprehensive guide to becoming a true Excel power user, with multimedia instruction and plenty of hands-on practice.
Program Excel's newest chart and pivot table object models Manipulate the user interface to customize the look and feel of a project Utilize message boxes, input boxes, and loops to yield customized logical results Interact with and manipulate Word, Access, PowerPoint, and Outlook from Excel If you're ready to get more out of this incredibly functional program, Excel VBA 24-Hour Trainer, 2nd Edition provides the expert instruction and fast, hands-on learning you need.
Table of contents
Part I: Understanding the BASICs Lesson 1: Introducing VBA Lesson 2: Getting Started with Macros Lesson 3: Introducing the Visual Basic Editor Lesson 4: Working in the VBE Part II: Diving Deeper into VBA Lesson 5: Object-Oriented Programming: An Overview Lesson 6: Variables, Data Types, and Constants Lesson 7: Understanding Objects and Collections Lesson 8: Working with Ranges Lesson 9: Making Decisions with VBA Part III: Beyond the Macro Recorder: Writing Your Own Code Lesson 10: Repeating Actions with Loops Lesson 11: Programming Formulas Lesson 12: Working with Arrays Lesson 13: Automating Procedures with Worksheet Events Lesson 14: Automating Procedures with Workbook Events Lesson 15: Handling Duplicate Items and Records Lesson 16: Using Embedded Controls Lesson 17: Programming Charts Lesson 18: Programming PivotTables and PivotCharts Lesson 19: User-Defined Functions Lesson 20: Debugging Your Code Part IV: Advanced Programming Techniques Lesson 21: Creating UserForms Lesson 22: UserForm Controls and Their Functions Lesson 23: Advanced UserForms Lesson 24: Class Modules Lesson 25: Add-Ins Lesson 26: Managing External Data Lesson 27: Data Access with ActiveX Data Objects Lesson 28: Impressing Your Boss (or at Least Your Friends) Part V: Interacting with Other Office Applications Lesson 29: Overview of Office Automation from Excel Lesson 30: Working with Word from Excel Lesson 31: Working with Outlook from Excel Lesson 32: Working with Access from Excel Lesson 33: Working with PowerPoint from Excel
About The Author
Tom Urtis is a Microsoft Office developer and programming expert with over 20 years of experience in developing customized Office programs with Visual Basic for Applications (VBA) and Application Programming Interface (API). In 2000 Tom founded Atlas Programming Management (www.atlaspm.com), an Office solutions company in Silicon Valley that specializes in Excel to provide consulting, project development, training, and support for a diverse international clientele. As an Excel trainer, Tom created the Excel Aptitude Test (XAT, www.xatcorp.com), which measures knowledge of Excel for a customized training curriculum based on the test score.
Tom is co-author of Holy Macro! It's 2,500 Excel VBA Examples, and he has served as a technical editor and consultant for other Excel books and training materials. Tom received the Most Valuable Professional award for Excel from Microsoft in 2008, and it has been renewed each year thereafter in recognition of his Excel skills and contributions to the Excel community. Tom is one of some 100 Excel experts worldwide who hold the Excel MVP award.
A native of New York state, Tom is a graduate of Michigan State University, and has lived and worked in the San Francisco Bay Area for 30 years. Tom is an avid sports fan and collector of rare sports memorabilia, and he enjoys the outdoor life that California offers. He can be reached by email, at [email protected]