Excel VBA Training Course (2016 Advanced) Training ½Òµ{
  Facebook: Excel VBA Training Course (2016 Advanced) Training ½Òµ{
 
Excel VBA Training Course (2016 Advanced) Training ½Òµ{
Excel VBA Training Course (2016 Advanced) Training ½Òµ{ Excel VBA Training Course (2016 Advanced) Training ½Òµ{ Excel VBA Training Course (2016 Advanced) Training ½Òµ{ Excel VBA Training Course (2016 Advanced) Training ½Òµ{ Excel VBA Training Course (2016 Advanced) Training ½Òµ{ Excel VBA Training Course (2016 Advanced) Training ½Òµ{ Excel VBA Training Course (2016 Advanced) Training ½Òµ{ Excel VBA Training Course (2016 Advanced) Training ½Òµ{ Excel VBA Training Course (2016 Advanced) Training ½Òµ{ Excel VBA Training Course (2016 Advanced) Training ½Òµ{ Excel VBA Training Course (2016 Advanced) Training ½Òµ{  
Excel VBA Training Course (2016 Advanced) Training ½Òµ{ Excel VBA Training Course (2016 Advanced) Training ½Òµ{

·Q©w´Áª¾¹D³Ì·s½Òµ{¤ÎÀu´f¶Ü¡H
§K¶O­q¾\¥»¤¤¤ßªº½Òµ{³q°T¡I

½Ò°ó¿ý¼vÀH®ÉÚ» 10 ¤jÀuÂI¤§¦aÂI¤è«K¡G¥»¤¤¤ß¦ì©ó©ô¨¤¡BÆ[¶í¡B¥_¨¤¡B¨F¥Ð¤Î ¤Ùªù¡A´Nªñ´äÅK¯¸¡I

Excel VBA 2016 µ{¦¡½s¼g¶i¶¥½Òµ{
½Òµ{²ºÙ¡GExcel VBA Training Course (2016 Advanced)

  • ½Òµ{®É¶¡
  • ½Òµ{²¤¶
  • ½Òµ{¯SÂI
  • ½Òµ{¤º®e

½Òµ{Àu´f¡I²{¤Z¦P®É³øŪ¥H¤U¨â­Ó½Òµ{¡G
§Y´î $300¡I

±À¤¶ªA°È¡G½Ò°ó¿ý¼vÀH®ÉÚ» (¦b®aÆ[¬Ý = 0%¡A¦b®ÕÆ[¬Ý = 100%)
¾Ç­û¨Ï¥Î¹q¸Ü©Î¥»ºô­¶³ø¦W¡A«Ý¥»¤¤¤ß½T»{¤w¬°¾Ç­û¯d¦ì«á¡A§Y¥i¨Ï¥Î Âà¼Æ§Ö ú¥I¾Ç¶O¡A¹Lµ{²«K¡I
½s¸¹ ¦aÂI ¥i¹w¬ù¬P´Á¤Î®É¶¡ ¾Ç¶O§C¦Ü 85 §é  
EP2403MV ©ô¨¤ ¤@¦Ü¤­¡G14:30 - 22:15   ¤»¡G13:45 - 21:30   ¤é¡G10:15 - 18:00 (¤½²³°²´Á¥ð®§) 95 §é«á¥u»Ý $1,691 «ö¦¹³ø¦W¡GExcel VBA Training Course (2016 Advanced) Training ½Òµ{
EP2403OV Æ[¶í ¤@¦Ü¤­¡G14:15 - 22:00   ¤»¤Î¤é¡G12:15 - 20:00   (¬P´Á¤T¤Î¤½²³°²´Á¥ð®§) 9 §é«á¥u»Ý $1,602 «ö¦¹³ø¦W¡GExcel VBA Training Course (2016 Advanced) Training ½Òµ{
EP2403PV ¥_¨¤ ¤@¦Ü¤­¡G14:15 - 22:00   ¤»¤Î¤é¡G12:15 - 20:00   (¬P´Á¤T¤Î¤½²³°²´Á¥ð®§) 9 §é«á¥u»Ý $1,602 «ö¦¹³ø¦W¡GExcel VBA Training Course (2016 Advanced) Training ½Òµ{
EP2403SV ¨F¥Ð ¤@¦Ü¤­¡G14:15 - 22:00   ¤»¤Î¤é¡G12:15 - 20:00   (¬P´Á¤T¤Î¤½²³°²´Á¥ð®§) 85 §é«á¥u»Ý $1,513 «ö¦¹³ø¦W¡GExcel VBA Training Course (2016 Advanced) Training ½Òµ{
EP2403YV ¤Ùªù ¤@¦Ü¤­¡G14:15 - 22:00   ¤»¤Î¤é¡G12:15 - 20:00   (¬P´Á¤@¡B¤T¤Î¤½²³°²´Á¥ð®§) 85 §é«á¥u»Ý $1,513 «ö¦¹³ø¦W¡GExcel VBA Training Course (2016 Advanced) Training ½Òµ{
* ¦U¬F©²³¡ªù¥i¨Ï¥Î P Card ¥I´Ú  
¦p¨Ï¥Î P Card ú¥I¦Ò¸Õ¶O¡A¦Ò¸Õ¶O»Ý¥t¥[ 1.3% ªþ¥[¶O  
¦b®Õ§K¶O¸ÕÚ»¡G ­º 1 ¤p®É¡A½Ð­P¹q»P¥»¤¤¤ß¾­û¹w¬ù¡C ¬d¬Ý¦U¦aÂI¹q¸Ü
©ô¨¤ 2332-6544
Æ[¶í 3563-8425
¥_¨¤ 3580-1893
¨F¥Ð 2151-9360
¤Ùªù 3523-1560
¦b®Õ§K¶O­«Ú»¡G ¾Ç­û¥i©ó¨É¥Î®É´Á¤º©ó³øŪ¦aÂI¤£­­¦¸¼Æ¦a­«¬Ý½Ò°ó¿ý¼v¡A±q¦Ó¥i¤ÏÂЭ«·Å¾ã­Ó½Òµ{¡I
¾É®v¸Ñµª¡G ¾Ç­û¥i©óÆ[¬Ý¬Y¤@½Ò°ó¿ý¼v«á´£¥X½Ò°óª½±µ¬ÛÃöªº°ÝÃD¡A½Òµ{¾É®v·|¼Ö·N¬°¾Ç­û¥H³æ¹ï³æªº§Î¦¡¸Ñµª¡I
½Ò®É¡G 12 ¤p®É
¨É¥Î®É´Á¡G ³øŪ¤é¦Ü 4 ¬P´Á¤º¡A¶i«×¥Ñ±z±±¨î¡A¥i§Ö¥iºC¡C
½Ò°ó¿ý¼v¾É®v¡G Nethril (¥ô±Ð½Òµ{²M³æ)
¦b®ÕÆ[¬Ý¡G ¸Ô±¡¤Î¥Ü½d¤ù¬q


±À¤¶ªA°È¡G½Ò°ó¿ý¼vÀH®ÉÚ» (¦b®aÆ[¬Ý = 100%¡A¦b®ÕÆ[¬Ý = 0%)
¾Ç­û¨Ï¥Î¹q¸Ü©Î¥»ºô­¶³ø¦W¡A«Ý¥»¤¤¤ß½T»{¤w¬°¾Ç­û¯d¦ì«á¡A§Y¥i¨Ï¥Î Âà¼Æ§Ö ú¥I¾Ç¶O¡A¹Lµ{²«K¡I
½s¸¹ ¦aÂI ¬P´Á¤Î®É¶¡ ¶O¥Î  
EP2403HH ¦b®a ¨É¥Î®É´Á¤º¨C¬P´Á 7 ¤Ñ (¥]¬A¤½²³°²´Á)¡A¨C¤Ñ 24 ¤p®É¥þ¤Ñ­Ô¤£­­¦¸¼Æ¦aÆ[¬Ý¡C $1,780 «ö¦¹³ø¦W¡GExcel VBA Training Course (2016 Advanced) Training ½Òµ{
* ¦U¬F©²³¡ªù¥i¨Ï¥Î P Card ¥I´Ú  
¦p¨Ï¥Î P Card ú¥I¦Ò¸Õ¶O¡A¦Ò¸Õ¶O»Ý¥t¥[ 1.3% ªþ¥[¶O  
¦b®Õ§K¶O¸ÕÚ»¡G ­º 1 ¤p®É¡A½Ð­P¹q»P¥»¤¤¤ß¾­û¹w¬ù¡C ¬d¬Ý¦U¦aÂI¹q¸Ü
©ô¨¤ 2332-6544
Æ[¶í 3563-8425
¥_¨¤ 3580-1893
¨F¥Ð 2151-9360
¤Ùªù 3523-1560
¾É®v¸Ñµª¡G ¾Ç­û¥i©óÆ[¬Ý¬Y¤@½Ò°ó¿ý¼v«á´£¥X½Ò°óª½±µ¬ÛÃöªº°ÝÃD¡A½Òµ{¾É®v·|¼Ö·N¬°¾Ç­û¥H³æ¹ï³æªº§Î¦¡¸Ñµª¡I
½Ò®É¡G 12 ¤p®É
¦b®aÆ[¬Ý®É¸T¥Îµ{¦¡¡G ¤@¨Ç¦M®`½Ò°ó¿ý¼vª©Åvªºµ{¦¡¡C
¨É¥Î®É´Á¡G ³øŪ¤é¦Ü 4 ¬P´Á¤º¡A¶i«×¥Ñ±z±±¨î¡A¥i§Ö¥iºC¡C
½Ò°ó¿ý¼v¾É®v¡G Nethril (¥ô±Ð½Òµ{²M³æ)
¦b®aÆ[¬Ý¡G ªA°È±ø´Ú¤Î¦u«h¡B³øŪµ{§Ç¤Î¥Ü½d¤ù¬q


¦a°Ï ¦a§} ¹q¸Ü ±Ð¨|§½µù¥U½s¸¹
©ô¨¤ ¤EÀs©ô¨¤¨È¬Ò¦Ñµó 109 ¸¹¡A¬Ò©ô°Ó·~¤j·H 18 ¼Ó 1802 - 1807 «Ç 2332-6544 533459
Æ[¶í ¤EÀsÆ[¶í¦¨·~µó 7 ¸¹¹ç®Ê¤¤¤ß 12 ¼Ó G2 «Ç 3563-8425 588571
¥_¨¤ ­»´ä¥_¨¤°¨Ä_¹D 41-47 ¸¹µØÄ_°Ó·~¤j·H 3 ¼Ó 01-02 ¸¹çE 3580-1893 591262
¨F¥Ð ·s¬É¨F¥Ð¥Ûªù¦w¸sµó 3 ¸¹¨Ê·ç¼s³õ 1 ´Á 10 ¼Ó M «Ç 2151-9360 604488
¤Ùªù ·s¬É¤Ùªù¤Ù³ß¸ô 2 ¸¹¤Ùªù¬fÄR¼s³õ 17 ¼Ó 1708 «Ç 3523-1560 592552
ª`·N¡I «È¤á¥²¶·¬d°Ý³øŪ¾Ç®Õªº±Ð¨|§½µù¥U½s¸¹¡A¥H½T»{¸Ó®Õ¬°µù¥U¾Ç®Õ¡A¥H§K»X¨ü¤£¥²­nªº·l¥¢¡I



¥»¤¤¤ß¬O Microsoft »{¥iªº¦X§@¹Ù¦ñ (Microsoft Certified Partner)¡C

¦b®É¥N¨B¥ï«æ³tªº¤µ¤Ñ¡A¤H¤H¤é²z¸U¾÷¡C§Ú­Ì¤£§Æ±æ±N®É¶¡®ö¶O¦b¤@¨Ç¬J­«ÂФSµL·N¸qªº¹q¸£¾Þ§@¤¤¡A®ö¶O¤H¤O¸ê·½¦¨¥»¡C¬G¦¹§Ú­Ì§Æ±æ¨Ï¥Î¹q¸£µ{¦¡¨Ó§¹¦¨¨º¨ÇÁcÂЪº¹q¸£¾Þ§@¡C

¥i¯à§A¤Ñ¤Ñ³£·|¾Þ§@ Excel ³n¥ó¡A¦³¨S¦³µoı¨Ï¥Î Excel ®É¡A´N¦n¹³¤u¼t¸Ìªº¾÷¾¹°µµÛ­«½Æ¨èªOªº¤u§@¡H¦³¨S¦³·Q¹L¨ä¹ê§A¥i¥H¥Î§ó°ª©úªº°µªk¡A©Î¥Î¤pµ{¦¡¨ú¥N¤@¨ÇµL²á¦ý¤S¥²¶·­n°µªº¤u§Ç¡H

VBA (Visual Basic for Application) ¬O Microsoft Office ªº­«­n¤j­û¡A¦³¤F VBA ¡A¥Î¤á¯à°÷Åý¥Î¤á¦b Excel ¤º½s¼g¤@¨Ç¤pµ{¦¡ / ¥¨¶°¥H¬Ù«o¤j¶q­«ÂЪº°Ê§@¡A¨Ï¤u§@®Ä²v±o¥H¤j´T´£¤É¡C

¦b ¡m VBA µ{¦¡½s¼g°ò¦¯Z¡n ¡A§Ú­Ì¤w¸g¤¶²Ð¤F Excel VBA ªº°ò¦ª¾ÃÑ¡A¥Ñ¥¨¶°¡B½sµ{·§©À¡B Excel VBA ª«¥ó¦Ü¿ù»~³B²z³£¤w¸g¤@¤@±´°Q¡A¨Ã¦¨¥\¹B¥Î¥H¤Wªº°ò¥»ª¾ÃÑ»s§@¤F¶}³æµ{¦¡¡C


¡m VBA µ{¦¡½s¼g°ò¦¯Z¡n²ß§@

 

Excel VBA ©Ò¯à°µ¨ìªº¨Ã«D¥u¦³¶}³æµ{¦¡¡A¦b ¡m VBA µ{¦¡½s¼g¶i¶¥¯Z¡n ùØ¡A§Ú­Ì·|±´¤J±´°Q¶i¶¥ªº Excel VBA §Þ³N¡C­º¥ý·|¤¶²Ð¶i¶¥ Excel ª«¥óªº¹B¥Î¡AµM«á«K·|¤¶²Ðªí³æ (Form) ¡A±q¦Ó»s§@¥H¤Uªº²ß§@ :


¡m VBA µ{¦¡½s¼g¶i¶¥¯Z¡n²ß§@ ¡V ªí³æ

 

¤¶²Ðªí³æ¹L«á¡A§Ú­Ì«K·|¤¶²Ð Excel VBA ªº¤@­Ó­«­n¤j­û Add-ins ( ¼W¯q¶° ) ¡A¼W¯q¶°¬O¤@­Ó¦³®Äªº³~®|À°§U§Ú­Ì±N¤w¼g¦nªº VBA µ{¦¡½X¤Àµoµ¹¨ä¥L Excel ¥Î¤á¡C¦b ¡m VBA µ{¦¡½s¼g¶i¶¥¯Z¡n ¤º¡A§Ú­Ì·|»s§@¼W¯q¶°¥H¦Û°Êø»s¹Ïªí¡A¥Î§@Åã¥Ü CPU ¨Ï¥Î±¡ªp¡C

¡m VBA µ{¦¡½s¼g¶i¶¥¯Z¡n²ß§@ ¡V ¼W¯q¶°¾Ç²ß¼W¯q¶°«á¡A§Ú­Ì«K·|¾Ç²ß±N¨¯­W¼g¦nªº VBA µ{¦¡½XÁôÂáAÁקK³Q¤H­×§ï¤Î§Ûŧ¡C


¡m VBA µ{¦¡½s¼g¶i¶¥¯Z¡n²ß§@ ¡V ÁôÂõ{¦¡½X

¤§«á¡A§Ú­Ì«K·|¸õ¥X Excel ªº®Ø®Ø¡C­º¥ý¾Ç²ß·|¨Ï¥Î Excel VBA ±N Access Àɮפºªº¸ê®Æ¶×¤J¨ì Excel §@¤ÀªR¡C

¡m VBA µ{¦¡½s¼g¶i¶¥¯Z¡n²ß§@ ¡V ³s±µ Access ¸ê®Æ®w

§¹¦¨³s±µ Access «á¡A§Ú­Ì«K·|¾Ç²ß¨Ï¥Î Excel VBA ¶Ç°e¹q¶l¡A§Ú­Ì¯à°÷±N­Ó§Oªº¤u§@ªí (WorkSheet) ¤Î¹Ïªí (Graph) ¶Ç°e¶}¥h¡C

¡m VBA µ{¦¡½s¼g¶i¶¥¯Z ¡n²ß§@ ¡V ¶Ç°e¹q¶l ( ³¡¥÷ )

 

³Ì«á¡A§Ú­Ì·|¾Ç²ß¥æ¤¬¨Ï¥Î Word »P Excel¡A¨Ï Excel »s§@¥X¨Óªº¹Ïªí¥i¥H¦³®Ä²v¦a½Æ»s¨ì Word ¤º¡C



½Òµ{¦WºÙ¡G Excel VBA 2016 µ{¦¡½s¼g¶i¶¥½Òµ{
- ²ºÙ¡GExcel VBA Training Course (2016 Advanced)
½Òµ{®É¼Æ¡G ¦X¦@12¤p®É
¾A¦X¤H¤h¡G

¹ï Excel ¦³°ò¥»»{ÃѤβŦX¤U¦C¨ä¤¤¤@¶µ±ø¥ó¡G
- ¹ï¨Ï¥Î VBA ¤Î µ{¦¡³]­p¦³¿³½ì
- ¤w­×²¦¥»¤¤¤ß©Ò¶}¿ìªº¡uVisual Basic µ{¦¡½s¼g°ò¦¯Z¡v
- ¤w­×²¦¥»¤¤¤ß©Ò¶}¿ìªº¥ô¦ó Microsoft Office ¯Z

±Â½Ò»y¨¥¡G ¥H¼sªF¸Ü¬°¥D¡A»²¥H­^»y
½Òµ{µ§°O¡G ¥»¤¤¤ß¾É®v¿Ë¦Û½s¼g¤¤¤å¬°¥Dµ§°O¡A¦Ó³¡¥÷¤¤¤å¦rªþ¦³­^¤å¹ï·Ó¡C


1. ¾É®v¿Ë¦Û½s¼gµ§°O¡G ¥»¤¤¤ß¾É®v¿Ë¦Û½s¼gµ§°O¡Aµ´¹ï¾A¦X½Òµ{¤§¥Î¡A¥O§AµL¶·¡u¦º¾S¡v¦p¦r¨å¯ë«p¤Î¤£¾A¦X­»´äŪ®Ñ®æ½Õªº®Ñ¥»¡C
2. ¤@¤H¤@¾÷¤W½Ò¡G ¥»½Òµ{¥H¤@¤H¤@¾÷¼Ò¦¡¤W½Ò¡C



½Òµ{¦WºÙ¡GExcel VBA 2016 µ{¦¡½s¼g¶i¶¥½Òµ{
- ²ºÙ¡GExcel VBA Training Course (2016 Advanced)

¸Ô²Ó±Ð±Â¤º®e:

1. °ò¦ª¾ÃÑ

2. Excelª«¥óªº¶i¶¥À³¥Î
    2.1. Applicationª«¥óªº¶i¶¥À³¥Î
    2.2. Workbooksª«¥óªº¶i¶¥À³¥Î
    2.3. Worksheetsª«¥óªº¶i¶¥À³¥Î
    2.4. Rangeª«¥óªº¶i¶¥À³¥Î
3. ¨Æ¥ó(Event)
    3.1. Workbook¼h­±ªº¨Æ¥ó(Events)
    3.2. Worksheets¼h­±ªº¨Æ¥ó(Events)
4. ªí³æ
    4.1. ªí³æªº¨Ò¤l
    4.2. ªí³æ±±¨î¶µ
    4.3. ªí³æ (Form)
    4.4. ¼ÐÅÒ (Label)
    4.5. «ö¶s (CommandButton)
    4.6. ¤å¦r¤è¶ô (TextBox)
    4.7. ¿ï¶µ«ö¶s(Option Button) ©M ®Ö¨ú¤è¶ô(CheckBox)
    4.8. ²M³æ¤è¶ô(ListBox)©M²Õ¦X¤è¶ô(ComboBox)
    4.9. ¤ë¾ä±±¨î¶µ
    4.10. ªí³æ°Ó·~¨Ò¤l¡G³z¹Lªí³æ¿é¤J«È¤á¸ê®Æ
5. Add-ins (¼W¯q¶°)
    5.1. »s§@¼W¯q¶°
    5.2. ®M¥Î¼W¯q¶°
    5.3. Add-in°Ó·~¨Ò¤l¡G¨Ï¥Î§é½u¹ÏÅã¥Ü¦øªA¾¹CPU¨Ï¥Î±¡ªp
6. ÁôÂÃVBAµ{¦¡½X
    6.1. ÁôÂõ{¦¡½Xªº¦n³B
    6.2. ÁôÂõ{¦¡½Xªº¨BÆJ
7. ³s±µAccess¸ê®Æ®w
    7.1. ³s±µAccessªº¨BÆJ
    7.2. ³s±µAccessªºVBA»yªk
8. µo°e¹q¶l
    8.1. ¨Æ«e·Ç³Æ ¡V ³]©wMicrosoft Outlook
    8.2. ¶Ç°e²³æ¤å¦r¶l¥ó
    8.3. ¦Û°Ê±NExcelÀÉ®×¥Hªþ¥ó§Î¦¡¶Ç°e
    8.4. ¶Ç°e¤@±i¤u§@ªí(Sheet)
    8.5. ¶Ç°e¤@±i¹Ïªí(Graph)
9. Excel»PWordªº¥æ¤¬¨Ï¥Î
    9.1. ø»s¹Ïªí
    9.2. ±N¹Ïªí½Æ»s
    9.3. ¶}±ÒMicrosoft Word
    9.4. ±N¹Ïªí¶K¤W©óWord¤å¥ó¤º
    9.5. °Ó·~¨Ò¤l ¡V ¦Û°Êø»s¹Ïªí­Ý±N¨ä½Æ»s¦Ü¤@­Ó·sªºWordÀɮפº
10. ªþ¿ý¡G®æ¦¡¤Æ²Å¸¹
11. ªþ¿ý:»s§@Performance Log
12. ªþ¿ý¡G¨Ï¥ÎAccess«Ø¥ß¸ê®Æªí

§ó¦hºî¦X½Òµ{
  Äá¼v½Òµ{
  ¡E Äá¼vªì¯Å
  ¡E Äá¼v¤¤¯Å (­·´º±MÃD)
  ­^¤å½Òµ{
  ¡E IPA «÷­µ¡G¯Å§O 1 ¡E 2 ¡E 3 ¡E 4
  ´¶³q¸Ü½Òµ{
  ¡E °ò¦´¶³q¸Ü«÷­µ (§K¶O)
  ¡E ¶i¶¥´¶³q¸Ü«÷­µ
  ¡E ´¶³q¸Ü·|¸Ü¡G¯Å§O 1 ¡E 2 ¡E 3
  ¦è¯Z¤ú»y¤å½Òµ{
  ¡E ¯Å§O 1 ¡E 2 ¡E 3
  ¤¤Âå½Òµ{
  ¡E Àã¯l»P¥Ö½§±Ó·P¯f
  ¡E ·t½H»P¦â´³ | »ó±Ó·P»P·P«_
  ¡E ²æ¾v»P¥Õ¾v | ±q¤­©x¬Ý°·±d
  ­·¤ô©R²z½Òµ{
  ¡E µµ·L¤æ¼Æ¡G¯Å§O 1 ¡E 2 ¡E 3
  ¡E ¤l¥­¤K¦r¡G¯Å§O 1 ¡E 2 ¡E 3
  ¡E ¤K¦r­·¤ô¡G¯Å§O 1 ¡E 2 ¡E 3
  ¡E ©_ªù¹P¥Ò¡G¯Å§O 1 ¡E 2 ¡E 3