Video description
This unique book-and-DVD package helps even non-programmers extend Excel with VBA
Virtually every manual task in Excel can be automated with VBA, which increases your productivity and saves enormous amounts of time. This unique book-and-DVD package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate many routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons and illustrations, while the accompanying DVD provides demos and screencasts to complement each lesson.
Introduces you to programming with Visual Basic for Applications (VBA), macro composition, and the programming environment
Explains events programming, embedded controls, user forms, message boxes, input boxes, looping, and more
Shows you how to control other Office applications from Excel, such as Word, Outlook, Access, and PowerPoint
Includes enhanced coverage of each lesson on the DVD, which also offers detailed examples
Provides ideas for applying VBA to everyday tasks in a way that's both practical and fun
Use this book-and-DVD package to get the total learning experience of VBA for Excel!
Table of contents
- Chapter 2: Getting Started with Macros 00:07:54
- Chapter 4: Working with VBE 00:04:27
- Chapter 6: Variables, Data Types and Constants 00:09:11
- Chapter 7: Understanding Objects and Collections 00:05:44
- Chapter 8: Making Decisions with VBA 00:10:23
- Chapter 9: Repeating Actions with Loops 00:06:58
- Chapter 10: Working with Arrays 00:11:42
- Chapter 11: Automating Procedures with Worksheet Events 00:13:22
- Chapter 12: Automating Procedures with Workbook Events 00:10:07
- Chapter 13: Using Embedded Controls 00:18:31
- Chapter 14: Programming Charts 00:21:28
- Chapter 15: Programming PivotTables and PivotCharts 00:11:55
- Chapter 16: User Defined Functions 00:09:25
- Chapter 17: Debugging Your Code 00:18:13
- Chapter 18: Creating Userforms 00:18:56
- Chapter 19: Userform Controls and Their Functions 00:32:43
- Chapter 20: Advanced Userforms 00:15:56
- Chapter 21: Class Modules 00:25:08
- Chapter 22: Add-ins 00:11:40
- Chapter 23: Managing External Data 00:10:13
- Chapter 25: Not Gone, Not Forgotten 00:08:22
- Chapter 26: Overview of Office Automation From Excel 00:10:31
- Chapter 27: Working with Word from Excel 00:16:56
- Chapter 28: Working with Outlook from Excel 00:15:59
- Chapter 29: Working with Access from Excel 00:25:42
- Chapter 30: Working with PowerPoint from Excel 00:10:12
Product information
- Title: Excel® VBA: 24-Hour Trainer
- Author(s):
- Release date: May 2011
- Publisher(s): Wrox
- ISBN: 978047089069
You might also like
book
Excel® VBA: 24-Hour Trainer
This unique book-and-video package of Excel® VBA: 24-Hour Trainer, helps even non-programmers extend Excel with VBA …
book
Excel VBA 24-Hour Trainer, 2nd Edition
Master VBA automation quickly and easily to get more out of Excel Excel VBA 24-Hour Trainer, …
video
The Ultimate Excel VBA Course
VBA (visual basic for application) is a language used for programming tasks and actions in Excel, …
book
Mastering VBA for Microsoft Office 365, 2019th Edition
Customize and ramp-up Office 365 applications NOTE: Please click the Downloads link (on the left of …