Excel 2007 - Macros in Depth [Repost]

0. Introduction
Welcome .. 01:09
Using the exercise files ..00:22

1. Getting Started
Definition and examples .. 04:36
Single-action macro examples .. 10:16
Understanding security .. 07:13
Short examples of the recording method .. 08:58
Overview of other techniques .. 04:23

2. Running a Macro (Execute, Play Back, Etc.)
Running macros from the View tab .. 02:09
Running macros from a keystroke shortcut .. 02:15
Running macros from the Quick Access toolbar button .. 02:13
Running macros from an object or ClipArt .. 03:51

3. Using VBA
Introducing the VBA environment .. 06:41
Viewing the VBA components .. 06:17

4. Recording a Macro in Stages
Recording a simple macro .. 03:04
Adding functionality to a macro .. 08:51

5. Creating Non-Recordable VBA Code
Understanding absolute and relative references .. 08:53
For and For Next statements .. 07:36
Do While and Do Until statements .. 05:40
Creating interactive macros .. 05:39

6. Macro Project: Converting a Mailing List into a Database List
Planning a macro .. 07:36
Recording partial code .. 06:40
Using loop structures in context .. 03:30
Testing a macro in Step mode .. 06:42
Pulling the data together .. 04:53
Joining two macros .. 03:25
Streamlining macros .. 06:05

7. The Personal Macro Workbook
Creating a personal macro workbook for macros with wide applicability .. 08:37
Closing and updating the personal macro workbook .. 01:56

8. Conclusion
Goodbye .. 00:27