2011
Lynda
Dennis Taylor
2:44
English
In Excel 2010: Macros in Depth, author Dennis Taylor explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros. This course also covers advanced topics such as making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions that can't be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario. Exercise files are included with the course.
Introduction 1m 28s
Welcome 1m 12s
Using the exercise files 16s
1. Getting Started 27m 15s
Understanding what a macro does 7m 31s
Reviewing macro examples 4m 29s
Understanding security 3m 40s
Reviewing the recording method 7m 27s
Understanding other techniques for macros 4m 8s
2. Running a Macro (Execute, Play Back, Etc.) 14m 34s
Running macros from the View tab 1m 31s
Running macros from a keyboard shortcut 2m 32s
Running macros from the Quick Access toolbar button 6m 35s
Running macros from an object or clip art 3m 56s
3. Using Visual Basic for Applications (VBA) 10m 45s
Introducing the VBA environment 3m 55s
Viewing the VBA components 6m 50s
4. Recording a Macro in Stages 14m 4s
Recording a simple macro 5m 52s
Adding functionality to a macro 8m 12s
5. Creating Non-Recordable VBA Code 32m 59s
Understanding absolute and relative references 10m 25s
Using For and For...Next statements 8m 33s
Using Do...While and Do...Until statements 7m 58s
Creating interactive macros 6m 3s
6. Macro Project: Converting a Mailing List into a Database List 48m 51s
Planning a macro 3m 51s
Recording partial code 10m 31s
Using loop structures in context 6m 40s
Testing a macro in Step mode 9m 31s
Pulling the data together 7m 11s
Joining two macros 4m 15s
Streamlining macros 6m 52s
7. The Personal Macro Workbook 14m 0s
Creating a personal macro workbook for macros with wide applicability 9m 14s
Closing and updating the personal macro workbook 4m 46s
Conclusion 27s
Final thoughts 27s
http://www.lynda.com/Excel-2010-tutorials/macros-in-depth/74463-2.html

Download File Size:327.98 MB

---