|
|
Post by CanCoOnG on Oct 31, 2008 15:02:45 GMT -5
Ëéͧ¹Õéà»ç¹ÅÔÊ¡ÒúéÒ¹ áÅÐ ÃÒÂÅÐàÍÕ´¹Ð
¤×ͨÐàÍÒäÇé áµèâ¾Ê¡ÒúéÒ¹ ËéÒÁ â¾ÊÍÂèÒ§Í×è¹ ÃÇÁ¶Ö§ ËéÒÁâ¾Ê¤ÇÒÁ¤Ô´àËç¹
ÊÓËÃѺ äÇé´Ù¡Òúéҹ㹠áµèÅèФÃÑé§ ¨Ðä´éà¢éÒÁÒ´Ùä´é§èÒ ¢Öé¹ ¹Ð
àÍ͹Õé ¡ÒúéÒ¹ÅèÒÊØ´ ¡éÍäÇé´Ù ·Õè àû/ â¾Ê ÅèÒÊØ´¹Ð ÍÒ¨à»ç¹ä»ä´éÇèÒ ÍÒ¨ ÍÂÙè˹éÒ 2 ËÃ×ÍÁÒ¡¡ÇèÒ¹Ñé¹áÅéÇ àÇÅÒ´Ù ¡éÍ´Ù˹éÒ »Ñ¨¨ØºÑ¹´éǹРá¤è¹ÕéËÅèÐ ÊÅÑ´¼Ñ¡ àÍêÂ
|
|
|
|
Post by joekung on Oct 31, 2008 22:38:29 GMT -5
|
|
|
|
Post by CanCoOnG on Nov 2, 2008 3:57:59 GMT -5
¡ÒúéÒ¹·Õè¿Ñ§ÇÔ·ÂØ¡àÅÔ¡¹Ð¨êÐ ÇÔ·ÂÒ¡Ã äÁèÁÒ Wow !
|
|
|
|
Post by GuBaBoMZ!!! on Nov 3, 2008 4:46:18 GMT -5
¾ÃØè§ à¹é ãÊè ªØ´ ¹È ¹èÐ
¡ÒúéÒ¹ ÁÕ Êè§ ¾ÃØè§ à¹é
Excel ÊÃØ» º··Õè 3 ¹èШêÐ
Business ·Ó ·éÒ º· ·Õè 1 ÁÑé§..
|
|
|
|
Post by GuBaBoMZ!!! on Nov 4, 2008 4:33:30 GMT -5
CC202 ·Ø¡¤¹ â»Ã´ ·ÃÒº ã¹Çѹ ¾Ø¸·Õè 5 ¾.Â. 51 ¡ÃØ³Ò ãÊè ªØ´¹Ñ¡ÈÖ¡ÉÒ 100% ÁÒ´éǹêÒ ¤ÃêÒ¿
¡ÒúéÒ¹ µÒÁµÒÃÒ§ ÍÐáËÅÐ áµè äÁèÃÙé Êè§äÃ
|
|
|
|
Post by sailom on Nov 4, 2008 9:59:13 GMT -5
äÁèÁÕã¤ÃºÍ¡ÍÕ¡ÅÐ
¡ÒúéÒ¹ÈÔÅ»¡Òþٴ ˹éÒ10 - 12
¶éÒäÁèªèÒ¡٨ÐäÁèºÍ¡ÇèÒã¤Ã
55+
¤¹ÁÒÍѾ¡ÒúéÒ¹ÁÕä˹ÇéÒäÁèºÍ¡ÇèÒÊè§äÃ
|
|
|
|
Post by fongbeer on Nov 5, 2008 9:06:44 GMT -5
¡ÒúéÒ¹Íѧ¡ÄɢͧÍÒ¨ÒÃÂìáÁ¹Ù ãËéáµè§º·Ê¹·¹Òà¡ÕèÂǡѺÊÀÒ¾ÍÒ¡ÒÈ¡Õ躷¡éÍä´é·Óà´ÕèÂÇáµèàÇÅÒâÃÅà¾ÅÂìÍÍ¡¤Ùèà¹éÍ
áÅСéͧ͢àÊÒǹÕÂìãËé·ÓµèͨҡµÑÇÍÂèÒ§·Õ訴º¹¡ÃдҹÍÕ¡ 10 ¢éÍ Ê觷éÒ¤Һ¢Í§áÁ¹Ù¾ÃØè§à¹é
á¤èà¹éáËÅÐ ...
|
|
|
|
Post by sokissme on Nov 7, 2008 4:31:31 GMT -5
¡ÒúéÒ¹Êè§Çѹ ¨Ñ¹·Ãì-Íѧ¤ÒÃ
Excel > ⨷Âì 5 ¢éÍ
1. ¶éÒµéͧ¡ÒáÓ˹´àÊ鹢ͺ ¨ÐµéͧàÅ×Í¡ Tab ... (¹èҨРTab ã´ ¹èÐ)
2. Auto Format ¤×ÍÍÐäà ÁÕ»ÃÐ⪹ìÍÂèÒ§äÃ
3. ¤ÓÊÑè§ Format Painter ¤×ͤÓÊÑè§ÍÐäà ͸ԺÒÂÇÔ¸Õ¡ÒÃãªé§Ò¹
4. ¡ÒáàÅÔ¡Êèǹ·ÕèµÃÖ§á¼è¹§Ò¹ ãªé¤ÓÊÑè§ÍÐäà áÅР͸ԺÒÂÇÔ¸Õ¡Ò÷Ó
5. ¡ÒáÓ˹´·È¹ÔÂÁ 2 µÓáË¹è§ ãªé¤ÓÊÑè§ã´ã¹ Formatting Toolsbar áÅÐãªé¤ÓÊÑè§ã´ã¹ Format Cell
6. ¶éÒµéͧ¡Òà 7 ¾ÄȨԡÒ¹ 2551 ¹.È. µéͧ¡Ó˹´ÍÂèÒ§äÃã¹â»Ãá¡ÃÁ Microsoft Excel 2003
_____________________________________________________________
Commath > ·Ó˹éÒ 147-148 ŧã¹ÊÁØ´ (Êè§ã¹¤Òº)
_____________________________________________________________
Print media > ÇÒ´ÃÙ» à¡ÕèÂǡѺ ö¨Ñ¡ÃÂÒ¹ ŧã¹ÊÁØ´ÇÒ´à¢Õ¹ ¢¹Ò´à·Õèºà·èÒ ¡ÃдÒÉ A4
_____________________________________________________________
|
|
|
|
Post by CanCoOnG on Nov 13, 2008 9:02:14 GMT -5
¡ÒúéÒ¹Êè§ ÇѹÈØ¡Ãì·Õè 14 nov 08
1. ¤³ÔµË¹éÒ 147-148 ·ÓŧÊÁØ´
2. Ê¡ÔÅ ¼Å¡Ãзº¨Ò¡ÇѹÅÍ¡Ãз§ ÇÔ¸Õá¡éä¢
3. ¡ÒúéÒ¹Êèǹ¡ÅÒ§
3.1 ¤Ø³ ³Ã§¤ì µ¹Ò¹ØÇѲ¹ì ´ÓçµÓá˹è§ÍÐäÃ㨻ѨºÑ¹
=> ¤Ø³³Ã§¤ì µ¹Ò¹ØÇѲ¹ì (»ÃиҹËÍ¡ÒäéÒàªÕ§ãËÁè)
3.2 µÓá˹觢ͧ ¤Ø³ ³Ã§¤ì ÁÕ¤ÇÒÁÊÓ¤ÑÍÂèÒ§äõèÍÊѧ¤Á
=>ÁÕ¤ÇÒÁÊÓ¤Ñ ¤×Í ªèÇ¿×鹿ÙÇѲ¹¸ÃÃÁÅéÒ¹¹Ò ªèǾѲ¹ÒÍصÊÒË¡ÃÃÁÀÒ¤à˹×Í áÅÐÊÃéÒ§°Ò¹àÈÃÉ°¡Ô¨ãËÁè ¾Ñ²¹Ò¢Õ´¤ÇÒÁÊÒÁÒö㹡ÒÃá¢è§¢Ñ¹¢Í§ÀÒ¤¸ØáԨ ·Ñé§ÀÒÂã¹áÅÐÃÐËÇèÒ§»ÃÐà·È ʹѺʹعÂØ·¸ÈÒʵÃì·Õè¨ÐãËéàªÕ§ãËÁèà»ç¹ÈÙ¹Âì¡ÅÒ§·Ò§´éÒ¹àÈÃÉ°¡Ô¨¢Í§ÀÒ¤à˹×Í áÅСÃШÒ¤ÇÒÁà¨ÃÔàª×èÍÁâ§ä»ÊÙèÀÒ¤à˹×Í
3.3 ¹È. ¤Ô´ÇèÒ ¤Ø³ ³Ã§¤ì à¡ÕèÂÇ¢éͧÍÂèÒ§äáѺ Quality (ÍÂèÒ§¹éÍ 5 ºÃ÷Ѵ)
3.4 ¤ÓÈѾ·ì à¡ÕèÂǡѺ¤Ø³ÀÒ¾ 5 ¤Ó
credit => ¤ÓµÍº 2 ¢éͨҡ¹ÙêÍѧ«ì ¨êÐ
|
|
|
|
Post by sokissme on Nov 15, 2008 9:27:48 GMT -5
|
|
|
|
Post by >>>[Ku][TiW]<<< on Nov 16, 2008 5:56:47 GMT -5
⨷Âì Excel ¾ÃéÍÁ à©Å (äÁè¶Ù¡ÍÂèÒÇèÒ¡Ò¹à¹éÍ áµèÇèÒÍѹ¹Õé·Óã¹ Excel ¹èҨж١)
1. 2*3/(5^2)+2-3 = -0.76
2. 4^2-1*2 = 14
3. (5^2)+(6/12)-4*2 = 17.5
4. 4^2*3/2-1*2 = 22
5. 2*4/2+(8-10)*(6/2*2) = -8
6. 5-2+3/6*2 = 4
7. 6*3/2-5+4*3-2 = 14
8. 3/3*(2^2)+2-1 = 5
9. (2*2+1/2)*3+2*2 = 17.5
10.((3*2)+5^2*2)-2/6 = 55.66667
|
|
|
|
Post by sokissme on Nov 21, 2008 7:00:13 GMT -5
¡ÒúéÒ¹Êè§Çѹ¨Ñ¹·Ãì-Íѧ¤ÒÃ
Excel > 6¢éÍ
1. ¨§áÊ´§ÇÔ¸Õ¡ÒäӹǹÊٵà =(4*4)/2*2/4+9 µÒÁÅӴѺ
2. àÁ×è͵éͧ¡ÒüÅÃÇÁ D1 ¶Ö§ D2 àÃҨлé͹ÊÙµÃÍÂèÒ§äÃ
3. ¡Òûé͹Êٵäӹǹâ´ÂãªéÊٵà Formula Bar ᵡµèÒ§¨Ò¡¡Òûé͹·ÕèÍ×è¹ÍÂèÒ§äÃ
4. ¨§Í¸ÔºÒ¤ÇÒÁᵡµèÒ§¢Í§¿Ñ§¡ìªÑè¹ Count,CountA,CountIF ¨§Í¸ÔºÒÂ
5. ¶éÒµéͧ¡ÒõÃǨÊͺ¼ÅÃÇÁẺÁÕà§×èÍ¹ä¢ ¤ÇÃãªé¿Ñ§¡ìªÑè¹ÍÐäà 㹡Òäӹdz
6. ͸ԺÒ¤ÓÈѾ·ì
6.1 Criteria
6.2 Average
6.3 Range
6.4 Median
____________________________________________________________
Hardware > ·Óã¹Ë¹Ñ§Ê×Í˹éÒ 31 áÅÐ 32
____________________________________________________________
Speech Art > àµÃÕÂÁÇÔ¨Òóì à´ÕèÂÇ ¤Ùè ËÃ×Í 3 ¤¹ ÇÔ¨ÒóìàÃ×èͧÍÐäáçä´é
_________________________________________________________
Business > §Ò¹¡ÅØèÁ OTOP ãËéÁÒ·Óà´ÕèÂÇá·¹
_______________________________________________________
ã¤ÃÃÙé¤ÓµÍº¢éÍä˹ ªèÇÂâ¾Êµì·Õ¤ÃѺ
|
|
|
|
Post by CanCoOnG on Nov 22, 2008 7:43:45 GMT -5
Business
>>>>>
Otop Íѹà´ÔÁ¡éÍ·Óà»ç¹¡ÅØèÁÍÂÙè¹Ð
áµèÇèÒ ·Õè·Óã¹ÊÁØ´ÍèÐ ÊÔ¹¤éÒÍÐäáéÍä´é ·Óà´ÕèÂÇ äÍ餹¢éÒ§º¹ÁѹÁÑèÇ - -"
|
|
kid
New Member
Posts: 12 
|
Post by kid on Nov 24, 2008 10:37:40 GMT -5
Excel
1. 16/4/4+9
4/4+9
1+9
=10 Ans.
2. =sum(D1:D2)
3.¢éÍ3äÁèÃÙéÇÐ
4.ËÒã¹Ë¹Ñ§Ê×ÍExcellÁÕá¹è«×éÍÁÒÅèÐ ãªéãËé¤ØéÁ (äÁèÁÕãËé¡Ãз׺ Admin)
5. SUMIF
6. Criteria ¤×Í à§×è͹ä¢ËÃ×Íࡳ±ì«Öè§ÍÂÙèã¹ÃٻẺ¢Í§µÑÇÍÑ¡Éà ¹Ô¾¨¹ì ËÃ×Í¢éͤÇÒÁ
Average ¤×Í ¡ÒÃËÒ¤èÒà©ÅÕè¢ͧ¢éÍÁÙÅ
Range ¤×Í ªèǧ¢Í§Cell·Õèµéͧ¡ÒûÃÐàÁÔ³(äÁèá¹è¹ã¨¹èÐ -_-")
Median ¤×Í ¡ÒÃËÒ¤èÒ¡ÅÒ§
»Å.äÁè¶Ù¡ÍÂèÒÁÒÇèÒ¡Ù¹èÐàÇéÂ!!
|
|
|
|
Post by teerapan on Nov 26, 2008 10:11:19 GMT -5
ç¡ÒúéÒ¹ Excel (Êè§Íѧ¤ÒÃ˹éÒ)
1. ãËé¹Ñ¡ÈÖ¡ÉÒ͸ԺÒÂÇÔ¸Õ¡Òäӹdz¢éÒÁá¼è¹§Ò¹
2. ¡ÒÃÍéÒ§ÍÔ§à«ÅÅì ¤×ÍÍÐäà ¨§Í¸ÔºÒÂ
3. ¡ÒÃÍéÒ§ÍÔ§à«ÅÅìÁÕ 2 Ẻ ÍÐäúéÒ§ ¨§Í¸ÔºÒÂ
4. ãËé¹Ñ¡ÈÖ¡ÉÒ͸ԺÒ¡Ò÷ӧҹ¢Í§¿Ñ§¡ìªÑè¹ IF ͸ԺÒµÒÁ¤ÇÒÁà¢éÒã¨
5. ¨§Í¸ÔºÒ¼Ţͧ¡ÒÃÍéÒ§ÍÔ§à«ÅÅì Absolute Referent µèÍ仹Õé
= C$12
= $C12
6. ¶éÒµéͧ¡ÒõÃǨÊͺÇѹ·ÕèáÅÐàÇÅһѨ¨ØºÑ¹ãªé¿Ñ§¡ìªÑè¹ã´ã¹¡ÒõÃǨÊͺ
͸ԺÒ¤ÓÈѾ·ì
IF
ROUND
MAX
COUNT
ÍÂèÒÅ×Á·Ó Picture Dictionary ´éǹФѺ
⪤´Õ ·Ø¡ æ ·èÒ¹!!
|
|
![>>>[Ku][TiW]<<< Avatar](http://photos3.hi5.com/0029/762/674/furBHh762674-02.jpg)
