Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

Excel 2007 - Macros in Depth [Repost]

Posted By: Notsaint
Excel 2007 - Macros in Depth [Repost]

Excel 2007 - Macros in Depth (Lynda.com)
QuickTime (.mov) | AVC | 960x540 | 100Kbps | 02:30:00 | 186 Mb
Audio: English | AAC , 2ch , 96Kbps

In Excel 2007: Macros in Depth, author Dennis Taylor demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros. This course also covers more advanced topics, including 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 accompany the course.

Dennis Taylor

Topics include:
- Running macros
- Understanding the VBA environment
- Storing macros in a Personal Macro Workbook
- Recording macros in stages
- Writing VBA code
- Using loops
- Debugging macros
- Testing in step mode
- Optimizing macros for fast performance


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


Excel 2007 - Macros in Depth [Repost]

Excel 2007 - Macros in Depth [Repost]
Download : Filepost | Uploaded

passowrd - course