Excel VBA 24-Hour Trainer, Second Edition
- 5h 55m
- Tom Urtis
- John Wiley & Sons (US)
- 2015
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.
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.
In this Book
-
Introduction
-
Introducing VBA
-
Getting Started with Macros
-
Introducing the Visual Basic Editor
-
Working in the VBE
-
Object-Oriented Programming—An Overview
-
Variables, Data Types, and Constants
-
Understanding Objects and Collections
-
Working with Ranges
-
Making Decisions with VBA
-
Repeating Actions with Loops
-
Programming Formulas
-
Working with Arrays
-
Automating Procedures with Worksheet Events
-
Automating Procedures with Workbook Events
-
Handling Duplicate Items and Records
-
Using Embedded Controls
-
Programming Charts
-
Programming PivotTables and PivotCharts
-
User-Defined Functions
-
Debugging Your Code
-
Creating UserForms
-
UserForm Controls and Their Functions
-
Advanced UserForms
-
Class Modules
-
Add-Ins
-
Managing External Data
-
Data Access with ActiveX Data Objects
-
Impressing Your Boss (or at Least Your Friends)
-
Overview of Office Automation from Excel
-
Working with Word from Excel
-
Working with Outlook from Excel
-
Working with Access from Excel
-
Working with PowerPoint from Excel
