¦p¦ó¦Û°Ê¤U¸ü¸ê®Æ¨Ã¦Û°Ê¬ö¿ý
- ©«¤l
- 24
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 48
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- EXCEL
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-1-22
- ³Ì«áµn¿ý
- 2011-3-8
|
¦p¦ó¦Û°Ê¤U¸ü¸ê®Æ¨Ã¦Û°Ê¬ö¿ý
¦U¦ì¤j®a¦n~
¤p§Ì§Ú¦³¨ÇºÃ°Ý¡AÀµ½Ð¦U¦ìÀ°¦£!
§Ú·Q±q¬YÓºô¶©T©w¸ò·s°òª÷ªº²bÈ¡A¨Ã¥B§â¥¦°O¿ý¤U¨Ó
¥t¥~·Q°µ¤@Ó²bȪºÁͶչϡAÀHµÛ¸ê®Æªº¤@µ§¤@µ§§ó·s¦ÓÅÜ°Ê(³Ìªñ30¤Ñ¤ºªº²bÈÁͶÕ)
§Ú¦³§ä¨ìÃþ¦üªº°ÝÃD¦b¤§«eªº³Â»¶®a±Ú°Q½×°Ï
°ÝÃD¡G§Ú¦³¨C¤Ñ¦bºô¤W¬d¾\ªÑ»ù¡A¦Ó¥B¤]¦³¿é¤H¼Æ¦r¶iExcel¡CºCºC¤@ÓFolder¸ÌÀY´N¦³¤F50ÓÀɮסA§Ú¤]¦³¥ÎAccess°µ¤@ӥؿý¨Ó¶W³s±µFolder¸ÌªºÀɮסC«Ü¶O®Éªº´N¬O§Ú»Ýn¦bºô¤W¬Ý¤FªÑ»ùµM«á¤@Ó¤@Ó¿é¤J¡C
¦³¨S¦³¤èªk¦Û°Ê±qºô¶ªº¼Æ¾Ú¿é¤JExcel?
A¡G³Ì§Öªº¤è¦¡
¤@Ó¤u§@ªí§@ºô¶¸ê®Æ³sµ²
¥t¤@¤u§@ªí¥Î¤½¦¡³sµ²Àx¦s®æ¸ê®Æ
¥un§ó·sºô¶³sµ²¸ê®Æ
¥t¤@¤u§@ªí´N¸òµÛ§ïÅܤF
«D±`¦n¥Î¡A¥i¤½¦¡³sµ²Àx¦s®æ¸ê®Æ¡A¦A§@¦¨¥t¤@¤u§@ªí¡A©Î¹Ïªíµ¥
¤p§Ì§Ú¹ïEXCEL¯uªº«Ü¤£¼ô¡A§Y¨Ï§ä¨ìÃþ¦üªºµª®×¡A¦ý¤£ª¾¹D±q¦ó°µ°_?
¥i§_¦³¹Ï¨Òµ¹§Ú°Ñ¬Ý¬Ý¡A©Î¬O¾Þ§@¨BÆJ!
¤@Ó¤u§@ªí¬O¥u sheet1 sheet2 ¶Ü? |
|
|
|
|
|
|
- ©«¤l
- 24
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 48
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- EXCEL
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-1-22
- ³Ì«áµn¿ý
- 2011-3-8
|
½Ð¥æ¥æ§Ú~§Ú·|§V¤O¾Ç²ßªº!·PÁÂ! |
|
|
|
|
|
|
- ©«¤l
- 559
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 626
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-6-14
|
¥»©«³Ì«á¥Ñ hugh0620 ©ó 2011-1-24 10:30 ½s¿è
¦^´_ 2# GOODHI
¦³¨S¦³¤èªk¦Û°Ê±qºô¶ªº¼Æ¾Ú¿é¤JExcel?
A:¦³³o¼ËªºªF¦è
§AnªºªF¦è~ ÁÙÆZ¼Ò½kªº~
Q1. ¬O§_¦³°ò¥»ªºdata¥i¥H¬Ý (³o¼Ë¤ñ¸û¦nÀ°§A®M¥Î)
Q2. §AªºªÑ²¼¬O¥Îþ¤@Óºô¶?
Q3. §AnªºªÑ²¼¬O³æ¤@°¦ªÑ²¼©Î¬O¦hÀɪѲ¼?
Q4. §Anªº¬O¦¬½L»ùÁÙ¬O·í¤éªÑ»ùªºªi°Ê?
¦pªG°ÝÃD°÷²M·¡~ À³¸Ó·|¤ñ¸û¦nÀ°§A³B²z
ªþ¥ó¬O¤@ÓYAHOOªºªÑ»ù§ó·sÀÉ
ªÑ»ù¦Û°Ê§ó·s_´ú¸ÕÀÉ.rar (5.84 KB)
|
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|
- ©«¤l
- 24
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 48
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- EXCEL
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-1-22
- ³Ì«áµn¿ý
- 2011-3-8
|
¦^´_ 3# hugh0620
¤£¦n·N«ä ±Ôz¤£¤Ó²M·¡!
°²³]§Ún¨C¤é ¹Dã«ü¼Æªº ¶}½L»ù ³Ì°ª»ù ³Ì§C»ù ¦¬½L»ùªº¸ê®Æ¡A§Æ±æ¯à¥´¶}EXCEL¥i¦Û°Ê§ó·s¸ê®Æ ¨Ã¥B¦Û°Ê°O¿ý¨C¤Ñªº¸ê®Æ
¸ê®Æ¨Ó·½¬O http://finance.yahoo.com/q/hp?s=^DJI+Historical+Prices
¥t¥~·Q°µ¤@Ó¹Ïªí °w¹ï¦¬½L»ù°µ¤@Ó¨«¶Õ¹Ï(Ä´¦p³Ìªñ30¤éªº¨«¶Õ¹Ï) ÀHµÛ¨C¤é¸ê®Æªº§ó·s
§Æ±æ¯àÀ°À°§Ú¡A§i¶D§Ú¸Ó¦p¦ó°µ°_! |
|
|
|
|
|
|
- ©«¤l
- 24
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 48
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- EXCEL
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-1-22
- ³Ì«áµn¿ý
- 2011-3-8
|
¬O¤£¬O¤£¬Oµ¥¯Å¤£°÷¡A¨S¿ìªk¤U¸ü±zªºÀɮסA©M¤W¶ÇÀÉ®×??
§Ú¥Dn¬O¬ö¿ý ¹Dã«ü¼Æ SP500 ¶O¦¨¥b¾ÉÅé ¨º´µ¹F§J«ü¼Æµ¥°ê»Ú«ü¼Æ
http://finance.yahoo.com/q/hp?s=^DJI+Historical+Prices
°òª÷ªº²bȳ¡¥÷
http://www.moneydj.com/y/ya/yp010001.djhtm?A=SHZA6
²{¦b¨C¤Ñ³£n¤â°Ê¥h¬ö¿ý°ê»Ú«ü¼Æªº¦¬½L»ù °òª÷²bÈ¡AµM«á¤@µ§¤@µ§¶ñ¤W¸ê®Æ¡AµM«á¦bÅܰʹϪí
¥H¤U³o¨Ç°µªk¡A¯à§_¥æ§Ú¦p¦ó«ç»ò°µ!
¥i§_¦³¹Ï¨Òµ¹§Ú°Ñ¬Ý¬Ý¡A©Î¬O¾Þ§@¨BÆJ!
¤@Ó¤u§@ªí§@ºô¶¸ê®Æ³sµ²
¥t¤@¤u§@ªí¥Î¤½¦¡³sµ²Àx¦s®æ¸ê®Æ
¥un§ó·sºô¶³sµ²¸ê®Æ
¥t¤@¤u§@ªí´N¸òµÛ§ïÅܤF |
|
|
|
|
|
|
- ©«¤l
- 559
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 626
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-6-14
|
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|
- ©«¤l
- 24
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 48
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- EXCEL
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-1-22
- ³Ì«áµn¿ý
- 2011-3-8
|
¦^´_ 7# hugh0620
·PÁ±z!
§Ú¦Û¤v¥Î¤F¤@¤U
Ãö©ó¹Ï«¬ªº°ÝÃD ¾ãÓ¤è¦V¦n¹³¿ù¤F!§Ú¬O§Æ±æªñ¤éªº²bȬO±Æ¦b¥kÃ䪺¡A³on«ç¸Ñ?
µM«á¦]¬°ºô¯¸¥uÅã¥Ü¥Xªñ30¤é¡A©Ò¥H¹Ï§Î¤]·|ÀHµÛ²bȦӧïÅÜ¡A¬O³o¼Ëªº·N«ä¹À? |
|
|
|
|
|
|
- ©«¤l
- 24
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 48
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- EXCEL
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-1-22
- ³Ì«áµn¿ý
- 2011-3-8
|
¦^´_ 6# Hsieh
·PÁ©pªº¸Ñµª!ÁÂÁÂò!
¤£¦n·N«ä¦b½Ð°Ý¤@¤U!EXCEL¤£¤Ó¼ô!
§Ún«ç»ò¦b¥t¤@¤u§@ªí°µ¨C¤é¸ê®Æªº¬ö¿ý!
n«ç»ò§â³Ì¾aªñªñ¤éªº¸ê®Æ¬ö¿ý¦b³Ì¤W±?
Ä´¦p»¡ ¬Q¤Ñªº¸ê®Æ¬ö¿ý¦b1
«e¤Ñªº¸ê®Æ°O¿ý¦b2
¤@Ó¤u§@ªí§@ºô¶¸ê®Æ³sµ²
¥t¤@¤u§@ªí¥Î¤½¦¡³sµ²Àx¦s®æ¸ê®Æ
¥un§ó·sºô¶³sµ²¸ê®Æ
¥t¤@¤u§@ªí´N¸òµÛ§ïÅܤF |
|
|
|
|
|
|