Lynda - Excel 2007: Macros in Depth
- کاربرد : آموزش جامع نرم افزار Excel 2007
- نوع فایل : فیلم آموزشی
- زبان : انگلیسی
- سیستم عامل : Windows-Mac-Linux-Android-iOS
- تولید کننده : Lynda
- سال تولید : 2010
Description
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
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
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