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