XYZ³nÅé«æ¥ý¾W

Lynda com Excel 2007 Macros in Depth ­^¤å¥¿¦¡ª©(Excel 2007: °]°È¤ÀªR±Ð¾Ç)



-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
³nÅé¦WºÙ:Lynda com Excel 2007 Macros in Depth ­^¤å¥¿¦¡ª©(Excel 2007: °]°È¤ÀªR±Ð¾Ç)
»y¨tª©¥»:­^¤åª©
¥úºÐ¤ù¼Æ:³æ¤ù¸Ë
¯}¸Ñ»¡©ú:
¨t²Î¤ä´©:WIN 9x/WIN ME/WIN NT/WIN 2000/WIN XP/WIN 2003
³nÅéÃþ«¬:Excel 2007: °]°È¤ÀªR±Ð¾Ç
µwÅé»Ý¨D:PC
§ó·s¤é´Á:2010/6/21
©x¤èºô¯¸:http://www.lynda.com/home/DisplayCourse.aspx?lpk2=52291
¤¤¤åºô¯¸:http://www.lynda.com/home/DisplayCourse.aspx?lpk2=52291
³nÅ鲤¶:
¾P°â»ù®æ:80
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=




³nÅ鲤¶:

      

   Lynda com Excel 2007 Macros in Depth ­^¤å¥¿¦¡ª©(Excel 2007: °]°È¤ÀªR±Ð¾Ç)






Lynda.com±À¥Xªº±Ð¾Ç Excel 2007: °]°È¤ÀªR (Excel 2007: Financial Analysis)
¥DÁ¿¡GCurt Frye

©x¤èºô¯¸ http://www.lynda.com/home/DisplayCourse.aspx?lpk2=52291

¼Æ¦ì©M°]°È¸ê®Æ¥¿¦bÅX°ÊµÛ·í¤µªº°Ó·~¥@¬É¡A¥»±Ð¾Ç¦®¦bÀ°§UŪªÌÁA¸Ñ³o¤è­±ªº¸ê°T¡C
¥¿½Tªº²z¸Ñ³o¨Ç¼Æ¦ì¥H¤Î¼Æ¦ì­I«áªº¤½¦¡¡A¬O¥ø·~»P­Ó¤H³q©¹¦¨¥\¤§¸ôªºÃöÁä¡C·L³n
ªºMVP(³Ì¦³»ù­È±M®a) Curt Frye ¦b±Ð¾Ç¤¤Á¿¸Ñ¤F¦b¤½¥q²z°]¤¤°ò¥»¬yºZ©Ê(fluency)
¡A¨Ï±o¥Î¤á¯à°÷¬Ý¨ì°ò¥»°]°È­pºâ­I«áªº·N¸q¡CCurt ¤¶²Ð¤F¦p¦ó¶i¦æ¤½¦¡¼f¬d¥H½T«O
¾A·íªº§ë¤J¡A¨Ã»¡©ú¤F¦p¦ó¸ÑÄÀ¤½¦¡¿é¥X¡C¥LÁÙ¤¶²Ð¤F¦p¦ó­pºâ§þ§ý¤ñ²v¡AÅu¾P¡A§é
®ɶ¡ªí¡A¥H¤Î¹w´ú¥¼¨Ó¼Wªø¡C

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.

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






             


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=