Lynda.com Excel 2007 Macros in Depth

Tutorial & e-learning. May 20, 2010 by bomb.
Lynda.com Excel 2007 Macros in Depth
Lynda.com Excel 2007 Macros in Depth | ISO | 203 MB

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 are included.

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


Screenshot
Lynda.com Excel 2007 Macros in Depth


Download File

Here you can download files online. Unlimited access to all sources file with one click direct download link!
Share
  • Featured link
  • [20-05-2010]

Comment