About this item
Highlights
- 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.
- About the Author: Tom Urtis is an Excel Microsoft Excel MVP, developer, and programmer with 30 years of experience in business management and developing spreadsheet and database applications for companies of all sizes.
- 496 Pages
- Computers + Internet, Desktop Applications
Description
About the Book
"Complete learning package with online video tutorials"--cover.Book Synopsis
Master VBA automation quickly and easily to get more out of ExcelExcel 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.
From the Back Cover
Quickly get more out of Excel with VBA automation
Excel VBA 24-Hour Trainer, 2nd Edition is your quick-start guide to getting more out of Excel using Visual Basic for Applications. This unique book and video package has been updated with 15 new advanced video lessons, providing a total of 11 hours of video training and 48 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. Meanwhile, concise, step-by-step instructions, illustrations, code examples, and downloadable workbooks give you a practical, in-depth learning experience.
Excel VBA 24-Hour Trainer, 2nd Edition:
- Offers a complete guide to becoming a true Excel power user
- Shows you how to program Excel's newest chart and pivot table object models
- Provides steps for manipulating the user interface with UserForms and embedded Form and ActiveX(R) controls to customize the look and feel of a project
- Helps you utilize message boxes, input boxes, and loops to yield customized, logical results
- Features steps for manipulating Word, Access(R), PowerPoint(R), and Outlook(R) from Excel
More than 11 hours of video training
Most lessons in this book is accompanied by an online instructional demonstration video to reinforce what you learn. Regardless of your learning style, you can now quickly master the basics and expand your skill set with this step-by-step multiplatform learning experience.
About the Author
Tom Urtis is an Excel Microsoft Excel MVP, developer, and programmer with 30 years of experience in business management and developing spreadsheet and database applications for companies of all sizes. He is an Excel instructor and frequent contributor to newsgroups in the Excel community.
Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved.