by Tom Urtis | Released May 2011 | ISBN: 01420110011SI

This unique book-and-DVD package helps even non-programmers extend Excel with VBAVirtually 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 environmentExplains events programming, embedded controls, user forms, message boxes, input boxes, looping, and moreShows you how to control other Office applications from Excel, such as Word, Outlook, Access, and PowerPointIncludes enhanced coverage of each lesson on the DVD, which also offers detailed examplesProvides ideas for applying VBA to everyday tasks in a way that's both practical and funUse this book-and-DVD package to get the total learning experience of VBA for Excel! Show and hide more

1. Chapter 2: Getting Started with Macros 00:07:54
2. Chapter 4: Working with VBE 00:04:27
3. Chapter 6: Variables, Data Types and Constants 00:09:11
4. Chapter 7: Understanding Objects and Collections 00:05:44
5. Chapter 8: Making Decisions with VBA 00:10:23
6. Chapter 9: Repeating Actions with Loops 00:06:58
7. Chapter 10: Working with Arrays 00:11:42
8. Chapter 11: Automating Procedures with Worksheet Events 00:13:22
9. Chapter 12: Automating Procedures with Workbook Events 00:10:07
10. Chapter 13: Using Embedded Controls 00:18:31
11. Chapter 14: Programming Charts 00:21:28
12. Chapter 15: Programming PivotTables and PivotCharts 00:11:55
13. Chapter 16: User Defined Functions 00:09:25
14. Chapter 17: Debugging Your Code 00:18:13
15. Chapter 18: Creating Userforms 00:18:56
16. Chapter 19: Userform Controls and Their Functions 00:32:43
17. Chapter 20: Advanced Userforms 00:15:56
18. Chapter 21: Class Modules 00:25:08
19. Chapter 22: Add-ins 00:11:40
20. Chapter 23: Managing External Data 00:10:13
21. Chapter 25: Not Gone, Not Forgotten 00:08:22
22. Chapter 26: Overview of Office Automation From Excel 00:10:31
23. Chapter 27: Working with Word from Excel 00:16:56
24. Chapter 28: Working with Outlook from Excel 00:15:59
25. Chapter 29: Working with Access from Excel 00:25:42
26. Chapter 30: Working with PowerPoint from Excel 00:10:12
Show and hide more